Qlik QSBA2022 - Qlik Sense Business Analyst Certification Exam - 2022

A sales manager needs to visualize the company's sales. The sales manager needs to understand how sates and profitability are related over time. The visualization will be used in a printed annual report.
The business analyst has access to the following data:
Order Dates
Order ID
Total Safes by Order
Net profit margin%
Cost of Goods Sow (COGS)
Which visualization should the business analyst use?

• A. Combo Chart
• B. Line Chart
• C. Scatter Plot
• D. Distribution Plot

How does the Qlik Associative Engine analyze data from one or more data sources?

• A. Inner joins multiple data sources together to remove unrequired information
• B. Associates data into cubes to enable multidimensional analysis
• C. Creates a set of pre aggregated queries for Qlik Sense to run
• D. Combines multiple data sources without pre-aggregation

Refer to the exhibit.

The data architect toads these fields from a data source A business analyst is creating an app for the human resources team Several visualizations are required
Line chart to show the number of new hires and terminations monthly
Treemap to show the number of employees by department and job level
Distribution plot of annual salaries or amount of benefits received by duration of employment or location
KPI to show average cost per employee
The cost per employee can be calculated by adding the employee salary to the amount of benefits received Which two additional fields does the business analyst need from the data architect lo meet these requirements? (Select two )

• A. Department
• B. Average cost of employee
• C. Benefits received
• D. Years employed
• E. Number of h res and termination

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 salesdepartment has several additionalrequirements
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. All fields as dimensions and measures
  Selected visualizations
• B. All fields as dimensions and measures
  All visualizations
• C. Seated fields as dimensions and measures
  Selected visualizations
• D. Selected fields as dimensions and measures
  All visualizations

A customer wants to perform a regional sates analysis to learn how products setover time m different areas. The business analyst needs to design a sheet in the app tor business users to perform several tasks
Select two different groups of countries to study
Compare sales over time between these two groups using a bar chart
Change the group items by selecting different countries at any time
Select a time range in the bar chart and drill-down to daily transactional sales.
What steps should the business anaryst follow to meet these requirements?

• A. Create one Alternate State Set1
  Create two Filter Panels one associated to this Set1and one Default State(S)
  Create a Bar chart with the drill-down dimension and two measuressum({Set1'$} Sales)and sum({'Set1"S) Sales)
• B. Create two Alternate States Set1and Set2
  Create two Filter Panels each associated with an Alternate State
  Create a Bar chart with a drill-down dimension and two measures sum({Set1'$} Sales) and sum{fSet2"S} Sales)
• C. Create two Alternate States Sell and Set2
  Create two Finer Panels each associated with an Alternate Stale
  Create a Bar chart with drill-down dimension and two measures sum({Set1'S} Sates) and sum({,Set2'*S} Sales)
• D. Create one Alternate State Set1
  Create two Filter Panels one associated lo this Set1 and one Default State1($)
  Create a Bar chart with the drill-down dimension and two measures sum({Set1-$) Sales) and sum('Set1-S) Sales)