Qlik Sense Business Analyst Certification Exam - 2022 Sample Questions:

1. A business analyst has access to all ofa company's data tor the past 10 years. The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into What should the business analyst do to reprove the app performance?

A) 1. Deselect Cardholder and time fields in data manager
2. Apply a filter to extract data based on transaction year
3. Request a daily reload task from the System Admin
B) 1. Delete Cardholder and time fields in data manager
2. Use a bookmark based on auto-calendar fields
3. Use the reload function in the sheet Editor asset panel
C) 1. Deselect Cardholder and time fieldin data manager
2. Use apant based on auto-calendar fields
3. Perform a daily reload via the data manager
D) 1. Delete Cardholder and time fields in data manager
2. Use set analysis to show data based on transaction year
3. Use an API to perform a daily reload task

2. 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

3. 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) Grid chart with diverging color by measure
C) Waterfall chart with custom positive value color
D) Mekko chart with diverging color by dimension

4. Refer to the exhibit.

A CEO wants to use a similar visualization on the company's dashboards
The visualization must meet several requirements
Show three years of sales data
Display sales trends by month
Allow comparison of years using an area style display
Which set of actions should a business analyst take to meet these requirements?

A) Add an area chart
Add Year first then Month as the dimensions
Add Sum(Sales) as the measure
In the properties panel under Area select the dimensions
B) Add a fine chart
Add Month first then Year as the dimensions
Add Surry Sales > as the measure
In the properties panel under Presentation select Area
C) Add an area chart
Add Month first then Year as the dimensions
Add SumfSates) as the measure
In the properties panel under Area select the dimension Year
D) Add a ,line chart
Add a master drill-down dimension with Year and Month
Add Sum(Sates) as the measure
In the properties panel under Presentation, select Area

5. A company installs Qlik Sense on Windows without any additional visualization bungles A business analyst must create an app with three sheets
Sheet 1 KPIs and sales trends for the past 12 months
Sheet 2 Regional sales by representative
Sheet 3 Sales by country displayed in a map
Users must be able to view all of the sheets and make selections for their analyses.
Which three objects should be added to the three sheets? (Select three)

A) Filter pane KPls and a map
B) Filter panes KPls and a combo chart
C) Filter pane bar chart and KPIs
D) Filter pane scatter plot and a map
E) Filter panes KPIs and a line chart

Solutions: