QSBA2022 by Qlik Valid Free Exam Practice Test

Question 1

A finance manager uses an Excel file to record travel expenses. The file has historical data and is used m multiple Qlik Sense apps. The finance manager needs to deploy only the past three months of data to the regional sales managers Which solution should be used to meet the requirements using the data manager?

A. Create a bucket that groups the three months of data B. Apply a filter" to load three months of data C. Use a WHERE clause to limit the data to three months D. Create a calculated field for the three months of data

Correct Answer: B

Question 2

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. 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 B. 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 C. 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 D. 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

Correct Answer: A

Question 3

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. Number of h res and termination C. Average cost of employee D. Years employed E. Benefits received

Correct Answer: D,E

Question 4

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. Distribution Plot C. Line Chart D. Scatter Plot

Correct Answer: A

Question 5

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. Combo Chan Measures Sales and Margin Dimensions Customer or Product category Pie Chart Dimension Stage Measure 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 Alternatives dimensions Customer or Product category Funnel Chart Segments Stage Width Sales D. Scatter Plot Measures X-axis Sates and Y-axis Margin Dimensions Customer or Product category Bar Chart Dimension Stage, Measure Sates

Correct Answer: C

Question 6

A business analyst needs to uniquely identify tour sheets in the app overview Custom images have been created for each sheet.
What should the business analyst do next?

A. Drag and drop the images onto the sheet edit view B. Use the media library to upload the mages C. Open the assets panel to drag and drop the images D. Add the images from the snapshot library

Correct Answer: B

Qlik Sense Business Analyst Certification Exam - 2022 - QSBA2022 Exam Practice Test