Qlik QSBA2021 Exam Questions Instant Access

Question 1

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 2

A business analyst is developing an app that contains a data model with fields Country. City. Sales ProductName and ProductCategory. The global sales manager wants to add new visualizations to this app

The business analyst must include the following

* Ability to dynamically change the number of countries and cities

* Display a maximum of 10 countries

* Display a maximum of 5 cities per country

Which steps should the business analyst take?

A1 Create two variables vCountry and vCity
2 Add a slider for vCountry and vCity
3 Apply the vanable to each virtualization

B1 Add an input field for vCountry and vCity
2 Sat the dimension limitation to the required maximum values 5 and 10
3 Apply the variable to each visualization
4 Add a bookmark Country and City

C1 Add an input field for vCountry and vCity
2 Set the dimension limitation to the required maximum values 5 and 10
3 Apply the variable to each visualization

D1 Create two variables vCountry and vCrty
2 Add a slider for vCountry and vCity
3 Apply the variable to each virtualization
4 Set a sheet action that limits the data displayed

Answer : A

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

AGrid chart with diverging color by measure

BLine chart with area gradient color by measure

CWaterfall chart with custom positive value color

DMekko chart with diverging color by dimension

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

Refer to the exhibit.

The business analyst needs to see now me same data wil appear m other chart types Which steps should the business analyst take to meet these requirements?

A1. Create a new chart
2. Enable Insights
3. Select a recommended chart

B1. Duplicate the chart
2. Drag and drop a new chart object over the old chart
3. Select Replace

C1. Create a new chart
2. Enable Chart suggestions
3. Select a recommended chart

D1. Duplicate the chart
2. Enable Chart suggestions
3. Select a recommended chart

Answer : C

Question 6

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)

AFilter pane scatter plot and a map

BFilter pane bar chart and KPIs

CFilter panes KPls and a combo chart

DFilter pane KPls and a map

EFilter panes KPIs and a line chart

Answer : C, D, E

Question 7

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

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