Exit demo QSBA2021 Qlik Sense Business Analyst Certification - February 2021 Release PDF format · free preview

QlikView QSBA2021 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/qsba2021.html

Question 1
Single choice

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?

A.

Create a bucket that groups the three months of data

B.

Use a WHERE clause to limit the data to three months

C.

Apply a filter" to load three months of data

D.

Create a calculated field for the three months of data

Question 2
Single choice

A business analyst needs to create a master item from an object m an app After right-clicking the object the analyst notices the Add to master Items option is NOT available.

What should the business analyst do to fixthis issue?

A.

Remove the master items tag

B.

Unlock the object

C.

Unlink the object

D.

Disable chart suggestions

Question 3
Single choice

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:

1. Ability to dynamically change the number of countries and cities
2. Display a maximum of 10 countries
3. Display a maximum of 5 cities per country

Which steps should the business analyst take?

A.

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

B.

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

C.

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

D.

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

Question 4
Single choice

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

Question 5
Multiple choice

A business analyst is designing a business intelligence solution to track production.There are several requirements in the complicated factory environment:

1. Printed work summary documents produced daily
2. Information monitors that show custom website with visualizations from QIA Sense
3. Ability to calculate the shortest routes between two sets of coordinates

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

A.

Mashup

B.

Qlik Compose

C.

Qlik NPrinting

D.

Custom objects

E.

Qlik GeoAnalytics

Question 6
Single choice

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?

A.

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

B.

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

C.

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

D.

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

Question 7
Single choice

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:

1. Order Dates
2. Order ID
3. Total Safes by Order
4. Net profit margin%
5. Cost of Goods Sow (COGS)

Which visualization should the business analyst use?

A.

Scatter Plot

B.

Combo Chart

C.

Distribution Plot

D.

Line Chart

Question 8
Single choice

Refer to the exhibit.

A business analyst must add a list of interns to the current sates app. The app contains an existing employees table When the business analyst profiles the data the association vow displays possible associations as shown.

Which action should the business analyst take to meet the requirements?

A.

Create a concatenated key to associate the Employees and internEmp tables

B.

Force an association between the InternEmp and the Orders tables

C.

Create an association between the EmpID and EmployeelD fields

D.

Concatenate the InternEmp table to the Employees tables within data manager

Question 9
Single choice

Refer of the exhibit.

A business analyst needs to add a table and make sure it is associated appropriately.

The table contains regional information about employee offices and must be able to titer the orders by employee office.

Which steps should the business analyst take?

A.

1. Click the Offices bubble
2. Click Synchronize scripted tables
3. Move the Offices bubble on top of the Employees bubble

B.

1. Select the Offices bubble and click the more options menu
2. Select concatenate or join option then select concatenate option from the drop-down menu
3. Select the Employees bubble

C.

1. Select the Employees bubble
2. Move the Employees bubble on top of the Offices bubble
3. Select the associated field

D.

1. Select the Offices bubble
2. Move the Offices bubble on top of the Employees bubble
3. Select the associated field

Question 10
Single choice

A business analyst needs to uniquely identify tour sheets in the app overview Custom images have been created for each sheet

What should the business analyst do next?

A.

Use the media library to upload the mages

B.

Add the images from the snapshot library

C.

Open the assets panel to drag and drop the images

D.

Drag and drop the images onto the sheet edit view

Showing 10 of 50 questions · Unlock the full set