Qlik Sense Business Analyst Certification Exam - 2022 Sample Questions:

1. The sales manager is investigating the relationship between Sales and Margin to determine if this relationship is linear when choosing the dimension Customer or Product Category The sales manager wants to have the potential percentage Sales tor each Stage (initial to Won) of the sales process What are the two correct visualizations?

A) Scatter Plot Measures X-axis Sates and Y-axis Margin Alternatives dimensions Customer or Product category Funnel Chart Segments Stage Width Sales
B) Distribution Plot Alternatives Measures Sales and Margin Alternatives dimensions Customer or Product category Bar Chart Dimension Stage. Measure Sates
C) Scatter Plot Measures X-axis Sates and Y-axis Margin Dimensions Customer or Product category Bar Chart Dimension Stage, Measure Sates
D) Combo Chan Measures Sales and Margin Dimensions Customer or Product category Pie Chart Dimension Stage Measure Sales

2. An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized What should the business analyst do to meet this requirement?

A) Add the new Customers and Orders tables and concatenate the new tables to the existing data model
Filter the data from the Orders table to bring only data created within the past two years
B) Add the new Customers and Orders tables and associate the new tables to me existing data model
Filter the data from the Customers and Orders table to bring only data created within the past two years
C) Add the new Customers and Orders tables and associate the new tables to the existing data model
Filter the data from the Orders table to bring only data created within the past two years
D) Add the new Customers and Orders tables and concatenate the new tables to the existing data model
Filter the data from the Customers and Orders table to bring only data created within the past two years

3. 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)

4. A business analyst is creating an app for technicians. The app must meet several requirements
Visualization labels must change according to the selected tame period
A button to toggle between Month and Year to Date (YTD)
Two fields combine to create one dimension that is used m several visualizations.
What three options are needed to meet the requirements? (Select three.)

A) Variables
B) Master items
C) Alternate states
D) Set analysis
E) Calculated fields

5. Refer to the exhibit.

What is the selection slate of light gray values?

A) Excluded
B) Alternative
C) Possible
D) Selected

Solutions: