Qlik QSBA2021 Exam Practice Test Instant Access

Question 1

Refer to the exhibit.

What is the selection slate of light gray values?

APossible

BExcluded

CSelected

DAlternative

Answer : B

Question 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?

AScatter Plot

BCombo Chart

CDistribution Plot

DLine Chart

Answer : C

Question 3

To improve efficiencies a hospital must analyze how often a surgery is started late by operating room and surgeon The business analyst must consider several factors

* Dates of each surgery

* Number of minutes the start of the surgery is delayed

* Operating room

* Surgeon name

Which visualization should the business analyst use to meet these requirements?

AA combo chart that shows total minutes of delayed starts by operating room and surgeon

BA bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon

CA scatter plot with delayed start minutes per day operating room and surgeon

DA line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

Answer : D

Question 4

A company that manages several tennis clubs uses an app mat includes three master measures TotalCost, Totallncome. and TotalMargin A business analyst needs to create a new table that utilizes master items and meets the following requirements:

* Number of bookings that users make

* Cost associated with booking (including electricity and indirect costs)

* Income obtained and profit originated m each booking

* Sales margin: percentage of margin over income

* Detail by tennis clubs

Which optimal expressions should the business analyst use?

A* count(BookinglD)
* [TolalCost]
* [Totalincomel
* sum(income|-sum[TotalCost]
* [TotalMargin]-sum(Cost)/sumTotal(lncome)*100

B* count(dislinct BookinglD)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100

C* count(dislinct BookinglD)
* [TolalCost]
* [Totalincome]
* [Totalincome|-[TotalCost]
* [TotalMargin]/[Totalllncome}*100

D* count(distinct BookinglO)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100

Answer : C

Question 5

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

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

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)

Answer : D

Question 6

A business analyst wants to send an email to app users when the region's sales exceed $50,000. The notification must be delivered through a mobile app What should the business analyst configure?

AAn email trigger on a data reload

BAn action on the sheet containing the KPI

CA destination using Qlik NPrinting

DA condition using Qlik Alerting

Answer : A

Question 7

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?

AUse the Stones feature to create a story with embedded sheets for each department

BEdit the Show Condition expression field in the sheets tor each department

CChoose to add a bookmark for each department

DCreate sheets with alternate states for each department

Answer : C

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