Online Access Free QSBA2021 Practice Test

Refer to the exhibit.


A business analyst must add a list of interns to the current sates app. The app contains an existing employees table When the business analyst profiles the data the association vow displays possible associations as shown.
Which action should the business analyst take to meet the requirements?

• A.Concatenate the InternEmp table to the Employees tables within data manager
• B.Create an association between the EmpID and EmployeelD fields
• C.Create a concatenated key to associate the Employees and internEmp tables
• D.Force an association between the InternEmp and the Orders tables

A business analyst is creating an app for the sales department
Users of the app most be able to create sheets and analyze data The sales department has several additional requirements
* Reuse the global sales visualization
* Create new visualizations
* The app has over 100 visualizations
Users will NOT have access to the full data model
What should be added to the master items to meet the requirement?

• A.* Seated fields as dimensions and measures
  * Selected visualizations
• B.* Selected fields as dimensions and measures
  * All visualizations
• C.* All fields as dimensions and measures
  * All visualizations
• D.* All fields as dimensions and measures
  * Selected visualizations

After a campaign a marketing group has data that snows distinct increases of product sales over a 12-month period. The group needs to highlight the products that show the highest revenue.
What should be developed to meet this requirement?

• A.Line chart with area gradient color by measure
• B.Mekko chart with diverging color by dimension
• C.Waterfall chart with custom positive value color
• D.Grid chart with diverging color by measure

Refer to the exhibit.

A business analyst needs to display a bat chart only when less than 100 customers are selected What should the business analyst create to meet this requirement

• A.A show/hide container using a master item bar chart and set the show condition to Count(CustomerlD) < 100
• B.A bar chart and in the Add-ons, set the calculation condition to Count(Customer ID) < 100
• C.A bar chart and in the Add-ons set the calculation condition 10 Count(DlSTINCT CustomerlD) < 100
• D.A show, hide container using a bar chart and set the show condition to Count(Distinct CustomerlD) <100

A business analyst s creating an app for the sales team. The app must meet several requirements
* Compare 10 top -performing sales representatives and the amount of sales for each
* Investigate margin percentage and total sales by each product category
* View distribution of sales amount
Which visualizations should be used for this app?

• A.A treemap box plot, and histogram
• B.A bar chart scatter plot and histogram
• C.A bar chart, line chart, and scatter plot
• D.A treemap container and distribution plot