Qlik QSBA2021 Exam Practice Test Instant Access

Question 1

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 2

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 3

An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized

What should the business analyst do to meet this requirement?

A* Add the new Customers and Orders tables and associate the new tables to me existing data model
* Filter the data from the Customers and Orders table to bring only data created within the past two years

B* Add the new Customers and Orders tables and concatenate the new tables to the existing data model
* Filter the data from the Orders table to bring only data created within the past two years

C* Add the new Customers and Orders tables and associate the new tables to the existing data model
* Filter the data from the Orders table to bring only data created within the past two years

D* Add the new Customers and Orders tables and concatenate the new tables to the existing data model
* Filter the data from the Customers and Orders table to bring only data created within the past two years

Answer : C

Question 4

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 5

Country

USA

U,S,A

Refer to the exhibit.

A business analyst needs to load several data files and notices that some of the values for the United States of America are formatted inconsistently.

What should the business analyst do?

AUse data profiling to group the country values

BUse data profiling and replace the country names

CUse data profiling 10 hide the inconsistent country names

DUse the filter and rename the country values

Answer : C

Question 6

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 7

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

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