Qlik Sense Business Analyst Certification Exam - February 2021 Release (QSBA2021) Free Practice Test

Question 1

A business analyst has access to all of a 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 field in data manager
2. Use a pant based on auto-calendar fields
3. Perform a daily reload via the data manager

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

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

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: C

Question 2

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 sales department has several additional requirements
* 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. * Selected fields as dimensions and measures
* All visualizations

D. * Seated fields as dimensions and measures
* Selected visualizations

Correct Answer: B

Question 3

A customer wants to perform a regional sates analysis to learn how products set over 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 Which steps should the business anaryst follow to meet these requirements?

A. * 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)

B. * Create two Alternate States Set1 and 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 one Alternate State Set1
* Create two Filter Panels one associated to this Set1 and one Default State(S)
* Create a Bar chart with the drill-down dimension and two measures sum({Set1'$} Sales)and sum({'Set1"S) Sales)

D. * 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)

Correct Answer: D

Question 4

Several departments use an app. The business analyst needs to modify access to the sheets so that each department can access their sheets only What should me business analyst do?

A. Create sheets with alternate states for each department

B. Use the Stones feature to create a story with embedded sheets for each department

C. Choose to add a bookmark for each department

D. Edit the Show Condition expression field in the sheets tor each department

Correct Answer: C

Question 5

Refer to the exhibit.

A business analyst is modifying a box plot End users report unexpected blue dots in a box plot What should the business analyst do?

A. Ask the data architect to modify the data model

B. Under Box plot elements deselect Include outliers

C. Under the Dimensions menu, deselect Include null values

D. Under Box plot elements, select Whisker length and increase to two interquartile ranges

Correct Answer: D

Question 6

A business analyst s creating an app for the sales team. The app must meet several requirements
* Compare 10 top -performing sales representatives and the amount of sales for each
* Investigate margin percentage and total sales by each product category
* View distribution of sales amount
Which visualizations should be used for this app?

A. A bar chart, line chart, and scatter plot

B. A bar chart scatter plot and histogram

C. A treemap container and distribution plot

D. A treemap box plot, and histogram

Correct Answer: D

Welcome to TestSimulate

Qlik Sense Business Analyst Certification Exam - February 2021 Release (QSBA2021) Free Practice Test