Qlik QSBA2021 Exam Practice Test Instant Access

Question 1

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 2

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

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

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

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