QSBA2018 Online Practice Questions and Answers

A data architect adds a field to an existing data model that contains new values for the ProductGroup. The business analyst needs to efficiently update the app and meet these requirements: Use the existing charts, which are built using a master item dimension called ProductGroup Existing charts must use the new values for ProductGroup Business users must be able to compare the new and old values

How should the business analyst meet these requirements?

A. Change the ProductGroup dimension using the new field, and create a new dimension in the master items for the old field.

B. Create a calculated dimension on the charts to allow the users to compare the new value to the old value.

C. Replace the dimensions on all charts to use the new ProductGroup field added to the data model.

D. Use set analysis on the chart measures to see the difference in ProductGroup between the new field and the old field.

A business analyst is building a dashboard to track customer loyalty. The app has several requirements: A table that shows the total number of purchases by customer A scatter plot that shows the correlation between the number of purchases and total spent by customer A bar chart that shows the top five customers by sales

Which two measures should the business analyst use to meet these requirements? (Choose two.)

A. Customer Ranking

B. Number of Purchases

C. Purchase Amount

D. Number of Products

E. Correlation

A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays.

Leadership needs the following capabilities: Ability to view the total donation amount Ability to identify departments that raise $10,000 or more

Which two visualizations should the business analyst use without set analysis to meet these requirements? (Choose two.)

A. Pie chart

B. Box plot

C. Bar chart

D. KPI

E. Treemap

A retailer with 300 locations worldwide needs to analyze its workforce to prepare for its next board meeting. The two most important items to the board members are total compensation and number of employees by city.

Which visualization should a business analyst use to meet this requirement?

A. Scatter plot

B. Bar chart

C. Pivot table

D. Map

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, FactoryLocation

C. Shipper, Product

D. Product, ProductGroup, Shipper

A hospital billing department is concerned with the performance of the cardiology and orthopedic departments. The billing department wants to add a visualization to an existing app to analyze billing for these two departments.

The business analyst must consider the hierarchy of: The department The physicians in each department The procedure performed by the physicians

What should the business analyst create to meet the requirements?

A. A scatter plot using alternate dimensions A bookmark for the physician

B. A bar chart with a cyclic group A bookmark for the physician

C. A bar chart using master items drill-down A bookmark for the departments

D. A scatter plot using set analysis A bookmark for the departments

Refer to the exhibit.

A company is starting to use a new customer account system. The business analyst must include this data in an existing app.

Data from the legacy customer account system is already available in the app.

Both tables have similar data, but the columns have different names.

Which actions should the business analyst take to merge data from both systems?

A. 1. Select Legacy Accounts

2.

Click Concatenate tables

3.

Select New Customer Accounts

4.

Map the tables

5.

Click Apply

B. 1. Select New Customer Accounts

2.

Drag it over Invoices

3.

Define the association

4.

Click Apply

C. 1. Select Legacy Accounts

2.

Click Concatenate tables

3.

Select New Customer Accounts

4.

Click Sample data

5.

Click Apply

D. 1. Select New Customer Accounts

2.

Drag it over Legacy Accounts

3.

Rename the association

4.

Click Apply

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. Select the Max trend line in the properties panel of the bar chart

B. Create a calculated field in the data manager and use it as a chart expression

C. Create a reference line using Max(Aggr(Sum(Sales),CompanyName))

D. Create a reference line using Aggr(Max(Sum(Sales),CompanyName))

A business analyst needs to make a complex pie chart easier to understand. The pie chart shows the total number of customers by customer type. There are 12 customer types. Some customers do NOT have a type assigned.

The business analyst needs to: Show all customers including those without a customer type See the total number of customers in each customer type

Which two visualizations could the business analyst use to meet these requirements? (Choose two.)

A. Donut

B. Treemap

C. KPI

D. Scatter plot

E. Bar chart

A business analyst has a QVD containing Sales, Manager, Date, and Region.

The business analyst needs to quickly create a sheet with three visualizations: Total Sales, Sales By Manager, and Sales by Date. The sheet must allow for analysis by Region.

In the search bar, the analyst enters "Sales", "Manager", and "Date", and adds the objects to the sheet.

Which steps should the business analyst perform to finish creating the sheet?

A. 1. Add two filter panes: Region and Sales

2.

Drag and drop Manager from the Fields list onto the sheet

3.

Add a line chart with Date as the dimension and Sales as the measure

B. 1. Add two filter panes: Date and Manager

2.

Drag and drop Sales from the Fields list onto the sheet

3.

Add a line chart with Manager as the dimension and Sales as the measure

C. 1. Add two filter panes: Sales and Manager

2.

Drag and drop Sales from the Fields list onto the sheet

3.

Add a line chart with Date as the dimension and Sales as the measure

D. 1. Add two filter panes: Region and Manager

2.

Drag and drop Sales from the Fields list onto the sheet

3.

Add a line chart with Date as the dimension and Sales as the measure