Qlik Sense Business Analyst Certification Exam - June 2018 Release : QSBA2018 Exam Questions

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. Replace the dimensions on all charts to use the new ProductGroup field added to the data model
• B. Change the ProductGroup dimension using the new field, and create a new dimension in the master items for the old field
• C. Use set analysis on the chart measures to see the difference in ProductGroup between the new field and the old field
• D. Create a calculated dimension on the charts to allow the users to compare the new value to the old value

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

A wholesaler needs to show sales and products in a PowerPoint presentation. The dimensions and measures are:
* Product Name
* Sum of Sales
* Number of Orders
Which two chart types could the business analyst use to meet these requirements? (Select two.)

• A. Treemap
• B. Combo chart
• C. Scatter plot
• D. Distribution plot
• E. Stacked bar chart

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 set analysis
  * A bookmark for departments
• B. * A bar chart using master items drill-down
  * A bookmark for departments
• C. * A bar chart with a cyclic group
  * A bookmark for the physician
• D. * A scatter plot using alternate dimensions
  * A bookmark for the physician

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 S10,000 or more
Which two visualizations should the business analyst use without set analysis to meet these requirements?
(Select two.)

• A. Bar chart
• B. Treemap
• C. KPI
• D. Pie chart
• E. Box plot