Summer Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

QSBA2021 Sample Questions Answers

Questions 4

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

• Printed work summary documents produced daily

• Information monitors that show custom website with visualizations from QIA Sense

• Ability to calculate the shortest routes between two sets of coordinates

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

Options:

A.

Mashup

B.

Qlik Compose

C.

Qlik NPrinting

D.

Custom objects

E.

Qlik GeoAnalytics

Buy Now
Questions 5

A business analyst needs to develop a visualization that compares performances of every product the company sells and each product category. The CEO wants to highlight the worst- and best-performing products and categories in a meeting that beg/is in one hour Using a bar chart which two approaches should the business analyst use? (Select two.)

Options:

A.

Alternative dimensions using fixed number limitations

B.

Stacked bar chart using ColorMix function

C.

Stack dimensions and color by measure

D.

Alternative dimensions and diverging color scheme

E.

Stack dimensions and color by dimension

Buy Now
Questions 6

A business analyst wants to send an email to app users when the region's sales exceed $50,000. The notification must be delivered through a mobile app What should the business analyst configure?

Options:

A.

An email trigger on a data reload

B.

An action on the sheet containing the KPI

C.

A destination using Qlik NPrinting

D.

A condition using Qlik Alerting

Buy Now
Questions 7

A business analyst using a shared folder mapped to S \419379942\ receives an Excel We with more than 100 columns Many of the columns are duplicates. The current set of columns mat should be used have the suffix '_c* appended to the column name

What should the business analyst do to load the Excel data?

Options:

A.

Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded

B.

Deselect the fields that do NOT have the '_c' suffix in the data manager table preview

C.

Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition

D.

Load all columns because the recommended associations will use only columns with the suffix '_c*

Buy Now
Questions 8

A business analyst wants to create a dashboard for the Finance team to use The app must include four sheets one looking at the full dataset and three others focused on the regions APAC EMEA and AMERICAS each.

The team needs visualizations for

• Sales by Product in the past 6" months

• Cost of Sales on a map by Country

• Sales Cost and Margin by Month

Additionally the learn wants to dear fillers while navigating between sheets and enable chat in the hub Which features should be used?

Options:

A.

Create default bookmark, maps sheet actions enable the insight Bot

B.

Create master measures alternate states GeoAnalytics enable Insights in app capabilities

C.

Create default bookmark GeoAnalytics alternate states enable the insight Bot

D.

Create master measures sheet actions maps enable Insights in app capacities

Buy Now
Questions 9

Country

USA

US

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?

Options:

A.

Use data profiling to group the country values

B.

Use data profiling and replace the country names

C.

Use data profiling 10 hide the inconsistent country names

D.

Use the filter and rename the country values

Buy Now
Questions 10

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?

Options:

A.

Scatter Plot

B.

Combo Chart

C.

Distribution Plot

D.

Line Chart

Buy Now
Questions 11

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)

Options:

A.

Filter pane scatter plot and a map

B.

Filter pane bar chart and KPIs

C.

Filter panes KPls and a combo chart

D.

Filter pane KPls and a map

E.

Filter panes KPIs and a line chart

Buy Now
Questions 12

How does the Qlik Associative Engine analyze data from one or more data sources?

Options:

A.

Creates a set of pre aggregated queries for Qlik Sense to run

B.

Associates data into cubes to enable multidimensional analysis

C.

Inner joins multiple data sources together to remove unrequired information

D.

Combines multiple data sources without pre-aggregation

Buy Now
Questions 13

A business analyst creates an app for a large retailer The app is based on me past ^2 months of transactional data in CSV formal

After successfully demonstrating the app the retailer provides a tile that contains another seven years of data

After the new datais loaded the previously responsive app takes 10 times longer to respond to users' selections The app has many complex expressions

Which two actions should the business analyst take to resolve the issues?(Select two)

Options:

A.

Request the data architect to create flagsin the data model to optimize set analysis expressions

B.

Use JOIN statements to reduce the number of tables m the data model

C.

Make sure a I master items contain variables that define the expressions

D.

Replace set analysis with calculated fields in the data manager

E.

Create versions of the app using a WHERE clause m the data manager to restrict the data

Buy Now
Questions 14

Refer to the exhibit.

A business analyst needs to display a bat chart only when less than 100 customers are selected

What should the business analyst create to meet this requirement

Options:

A.

A show, hide container using a bar chart and set the show condition to Count(Distinct CustomerlD) <100

B.

A bar chart and in the Add-ons set the calculation condition 10 Count(DlSTINCT CustomerlD) < 100

C.

A bar chart and in the Add-ons, set the calculation condition to Count(Customer ID) < 100

D.

A show/hide container using a master item bar chart and set the show condition to Count(CustomerlD) < 100

Buy Now
Questions 15

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?

Options:

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

Buy Now
Exam Code: QSBA2021
Exam Name: Qlik Sense Business Analyst Certification Exam - February 2021 Release
Last Update: May 19, 2024
Questions: 50
$64  $159.99
$48  $119.99
$40  $99.99
buy now QSBA2021