最新のQSBA2018問題集で試験を準備する

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

A business analyst must create new master items for quarterly calendar measures with company-specific naming conventions based on
* The Date field and the Sum of Sales
* The new master items will calculate QTD Sales. Current QTD Sales, Last QTD Sales, Current Quarter Sales, Last Year Current Quarter Sales, and Last Quarter Sales Which three steps should the business analyst take to meet these requirements? (Select three.)

• A. Right-click the Sales field in the assets panel and select Create calendar measures
• B. Select Date. Sales. Sum. and Yearly
• C. Right-click the Date field in the assets panel and select Create calendar measures
• D. Select Date, Sales, Sum, and Quarterly Save to master items, rename master items

Refer to the exhibit.

A business analyst must analyze sales using an existing sales order app.
* The Orders table in the app was added from a QVD file using the data manager
* The Orders table in the app and the QVD do NOT contain a SalesAmount field
* SalesAmount can be calculated by multiplying the Quantity and UnitPrice How should the business analyst add a SalesAmount field into the Orders table?
A)

B)

C)

D)

• A. Option A
• B. Option C
• C. Option D
• D. Option B

A company has customers in 16 countries. The majority of the customers are in Germany A business analyst creates a fitter pane for Country and wants "Germany" listed first. The rest of the countries should be listed in alphabetical order.
Which method should the business analyst use to meet this requirement?

• A. In the data manager edit the table, select Country! then select Order from the data profiling card
• B. Edit the sheet, select Chart Properties panel Custom sorting, then select Germany
• C. In the data manager, edit the table, select Country, then select Order from the column header
• D. Edit the sheet, select Chart Properties panel Custom sorting, then click Descending Frequency

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