QSBA2018 무료 덤프문제 온라인 액세스

A business analyst is creating a dashboard to analyze supply chains. The app must contain several elements
* A bar chart that shows a number of products and product groups handled by shipper
* A map that shows the number of shipments sent from factory locations
* A bar chart that shows average delivery costs by shipper
Which dimensions should the business analyst use for this app?

• A.Product, Shipper. FactoryLocation
• B.Shipper, Factor/Location
• C.Product, ProductGroup. Shipper
• D.Shipper, Product

A CEO of an automotive manufacturing company wants a single dashboard sheet to track the company's sales.
The app must meet several requirements:
* All charts must be on one sheet
* Show summary charts of key performance data
* Ability to scroll up and down the sheet
Which set of actions should the business analyst use to meet these requirements?

• A.* Adjust grid spacing
  * Use Insight Advisor
• B.* Use KPI objects
  * Activate Chart assistance
• C.* Use KPI objects
  * Use Insight Advisor
• D.* Adjust grid spacing
  * Activate Extend sheet

A business analyst uses the data manager to load customer data from a QVD file. The data manager automatically profiles the data, and recognizes City and Country values as Geo data.
The app must meet the following requirements;
* Country field should be in Geo data format
* City should NOT be allowed as a mapping option for the users
* There must be an association between the Country and City fields
Which actions should the business analyst take to meet these requirements?

• A.1. In the Associations view, select the City field
  2 Change the format from 'Geo data' to 'No data profiling'
• B.1 In the Associations view select the City field
  2 Delete the City field
• C.1. In the Associations view, select the City field
  2 Change the format from 'Geo data' to 'General'
• D.1. In the Associations view, select the City field
  2 Delete Sgeoname-tag from field properties

Refer to the exhibit.

A business analyst needs to add a reference line to a bar chart.
Which action should the business analyst take to meet this requirement?

• A.Create a calculated field in the data manager and use it as a chart expression
• B.Create a reference line using Max(Aggr(Sum(Sales),CompanyName))
• C.Select the Max trend line in the properties panel of the bar chart
• D.Create a reference line using Aggr(Max(Sum(Sales),CompanyName))

Refer to the exhibit.

A business analyst must update an app by adding a new table called 'Invoices'. This table must be associated to the existing model via reference code values.
There is NO column available with reference codes in the Invoices table. This information can only be retrieved by splitting a field called 'Full Invoice No' from the Invoices table
'Full Invoice No' includes the 'CostCenter Code', the 'Department Code', and a 'Reference Code' The CostCenter Code is NOT relevant for further analysis, so the analyst must split this new field into two new columns.
Which set of actions should the business analyst take to meet these requirements?

• A.* Select the split marker
  * Click All Instances
  * Uncheck the last two columns
  * Rename the fields
  * Click Reset
• B.* Select the split marker
  * Click This instance
  * Uncheck the last two columns
  * Rename the fields
  * Click Reset
• C.* Select the split marker
  * Click All instances
  * Uncheck the first column
  * Rename the fields
  * Click Create fields
• D.* Select the split marker
  * Click This instance
  * Uncheck the first column
  * Rename the fields
  * Click Create fields