Qlik QSBA2021 Exam Questions Instant Access

Question 1

A Help Desk department sets a first-time fix target of 65% for ail customer calls. The department has a measure that captures the actual first-time fix percentage. A business analyst needs to choose the visualization that most effectively shows the performance against the target using a color gradient Which visualization should the business analyst use?

ATable

BText and Image

CGauge

DCombo chart

Answer : A

Question 2

A business analyst inherits an app full of sheets The business analyst needs to redesign the app using the DAR principle How should the business analyst order the visualizations?

A* KPIs
* Table PivotTable
* Bar Chart Pie Chart Line Chart

B* Bar Chart Pie Chart Line Chart
* KPIs
* Table Pivol Table

C* KPIS
* Ba' Chart Pie Chart Line Chart
* Table Pivot. Table

D* Bar Chart Pie Chart Line Chart
* Table Pivot Table
* KPIs

Answer : D

Question 3

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?

ACreate a bucket that groups the three months of data

BUse a WHERE clause to limit the data to three months

CApply a filter' to load three months of data

DCreate a calculated field for the three months of data

Answer : B

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?

AScatter Plot

BCombo Chart

CDistribution Plot

DLine Chart

Answer : C

Question 5

A business analyst s developing an app 10 track the influence of the company's mascot cat on instagram The marketing department has several requirements for this solution.

* Information must be updated every hour to the company's information monitor

* Data from Instagram must be fetched over a REST connection and combined with Google Analytics data

* There must be a way to visualize changes of followers *i a map

Which two features are needed to meet these requirements? (Select two.)

AStandard map visualization

BMashups

CQlik Sense Mobile offline

DQlik NPrinting

EQlik web connectors

Answer : A, C

Question 6

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

Which three options are needed to meet the requirements? (Select three.)

AMaster items

BVariables

CCalculated fields

DAlternate states

ESet analysis

Answer : A, B, C

Question 7

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

Qlik Sense Business Analyst Certification Exam - February 2021 Release QSBA2021 Exam Questions