Free Qlik QSBA2021 Practice Exam with Questions & Answers

Name: How to Pass QSBA2021 Exams
Brand: Examstrack
SKU: qsba2021
Price: 42 USD
Availability: InStock

Questions 1

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:

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

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

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

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

Qlik QSBA2021 Premium Access

Brice

20-Jun-2025

QSBA2021 became manageable with examstrack.com. Their competent IT experts made all the difference.

Questions 2

To improve efficiencies a hospital mustanalyze 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?

Options:

A combo chart that shows total minutes of delayed starts by operating room and surgeon

A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon

A scatter plot with delayed start minutes per day operating room and surgeon

A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

Questions 3

A business analyst has access to all ofa company's data tor the past 10 years The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source

Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into

What should the business analyst do to reprove the app performance?

Options:

1. Deselect Cardholder and time fieldin data manager

2. Use apant based on auto-calendar fields

3. Perform a daily reload via the data manager

1. Delete Cardholder and time fields in data manager

2. Use set analysis to show data based on transaction year

3. Use an API to perform a daily reload task

1. Deselect Cardholder and time fields in data manager

2. Apply a filter to extract data based on transaction year

3. Request a daily reload task from the System Admin

1. Delete Cardholder and time fields in data manager

2. Use a bookmark based on auto-calendar fields

3. Use the reload function in the sheet Editor asset panel

Questions 4

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?

Options:

• 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

• 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

• 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

• 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

Questions 5

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?

Options:

Create a bucket that groups the three months of data

Use a WHERE clause to limit the data to three months

Apply a filter" to load three months of data

Create a calculated field for the three months of data

Questions 6

A large auditing firm has a proprietary web portal that all of the' customers use to access their own data. The owner of the portal has asked if it is possible to embed some Ok visualizations within the portal when will present the data back to the Individual customers.

The data within the visualizations must be live and provide up-to-date data every time the customer logs in to the portal and updates when the QlikSeriesapp is reloaded.

What should the business analyst recommend?

Options:

Qlik Dynamic \news

ODAG

Embedded Stories

QlikAPIs

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

Options:

Grid chart with diverging color by measure

Line chart with area gradient color by measure

Waterfall chart with custom positive value color

Mekko chart with diverging color by dimension

Questions 8

A business analyst ;s creating an app tor the team. A set of selections must be applied every time an app is opened.

What should the business analyst do to meet this requirement?

Options:

Use a sheet action and apply a bookmark named 'Default'

Create a masnup and use the API to apply default selections

Create a bookmark and select 'Set selections as app default"

Use Section access to predefine tie default selections

Questions 9

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?

Options:

Use data profiling to group the country values

Use data profiling and replace the country names

Use data profiling 10 hide the inconsistent country names

Use the filter and rename the country values

Questions 10

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:

Create default bookmark, maps sheet actions enable the insight Bot

Create master measures alternate states GeoAnalytics enable Insights in app capabilities

Create default bookmark GeoAnalytics alternate states enable the insight Bot

Create master measures sheet actions maps enable Insights in app capacities