[May 01, 2023] Free Qlik QSBA2021 Exam Questions & Answer [Q22-Q44]

Rate this post

[May 01, 2023] Free Qlik QSBA2021 Exam Questions and Answer

Verified QSBA2021 dumps Q&As Latest QSBA2021 Download

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

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

Associates data into cubes to enable multidimensional analysis

Inner joins multiple data sources together to remove unrequired information

Combines multiple data sources without pre-aggregation

QUESTION 23
A business analyst is creating a story One visualization must be scaled only vertically. Which steps are needed to apply this in the storytelling view?

Select the Effects library to rescale the visualization

Select Edit in the Snapshot library and rescale the visualization

Select Unlock the snapshot and rescale the visualization

Select Edit on the visualization and enter the new height

QUESTION 24
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 fix this issue?

Remove the master items tag

Unlock the object

Unlink the object

Disable chart suggestions

QUESTION 25
Refer to the exhibit.

What is the selection slate of light gray values?

Possible

Excluded

Selected

Alternative

QUESTION 26
Several departments use an app. The business analyst needs to modify access to the sheets so that each department can access their sheets only What should me business analyst do?

Use the Stones feature to create a story with embedded sheets for each department

Edit the Show Condition expression field in the sheets tor each department

Choose to add a bookmark for each department

Create sheets with alternate states for each department

QUESTION 27
A business analyst has access to all of a 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?

1. Deselect Cardholder and time field in data manager
2. Use a pant 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

QUESTION 28
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.)

Master items

Variables

Calculated fields

Alternate states

Set analysis

QUESTION 29
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?

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*

QUESTION 30
A customer wants to perform a regional sates analysis to learn how products set over time m different areas The business analyst needs to design a sheet in the app tor business users to perform several tasks
* Select two different groups of countries to study
* Compare sales over time between these two groups using a bar chart
* Change the group items by selecting different countries at any time
* Select a time range in the bar chart and drill-down to daily transactional sales Which steps should the business anaryst follow to meet these requirements?

* Create one Alternate State Set1
* Create two Filter Panels one associated to this Set1 and one Default State(S)
* Create a Bar chart with the drill-down dimension and two measures sum({Set1’$} Sales)and sum({‘Set1″S) Sales)

* Create two Alternate States Set1 and Set2
* Create two Filter Panels each associated with an Alternate State
* Create a Bar chart with a drill-down dimension and two measures sum({Set1’$} Sales) and sum{fSet2″S} Sales)

* Create one Alternate State Set1
* Create two Filter Panels one associated lo this Set1 and one Default State1($)
* Create a Bar chart with the drill-down dimension and two measures sum({Set1-$) Sales) and sum(‘Set1-S) Sales)

* Create two Alternate States Sell and Set2
* Create two Finer Panels each associated with an Alternate Stale
* Create a Bar chart with drill-down dimension and two measures sum({Set1’S} Sates) and sum({,Set2’*S} Sales)

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

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

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

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

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

QUESTION 32
A company CEO requests an app that contains global sales information. The CEO needs to present this information to an audience of international investors during an upcoming meeting The presentation must meet several requirements
* Contain visualizations that present dearly to a large audience
* Answer audience questions dynamically
* Be made available as shared content
* Emphasize important sales revenue
Which Qlik Sense features must the business analyst prepare?

Set up Nprinting to connect to the app and design a slideshow-style report

Create a storytelling narration m a published app that contains embedded sheets

Embed a video player m the shared app with a recording to describe the charts

Create a sheet that features colorful and layered visualizations and export as a PDF

QUESTION 33
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?

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

QUESTION 34
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?

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

QUESTION 35
A business analyst is creating an app for the sales department
Users of the app most be able to create sheets and analyze data The sales department has several additional requirements
* Reuse the global sales visualization
* Create new visualizations
* The app has over 100 visualizations
Users will NOT have access to the full data model
What should be added to the master items to meet the requirement?

* All fields as dimensions and measures
* All visualizations

* All fields as dimensions and measures
* Selected visualizations

* Seated fields as dimensions and measures
* Selected visualizations

* Selected fields as dimensions and measures
* All visualizations

QUESTION 36
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?

* count(BookinglD)
* [TolalCost]
* [Totalincomel
* sum(income|-sum[TotalCost]
* [TotalMargin]-sum(Cost)/sumTotal(lncome)*100

* count(dislinct BookinglD)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100

* count(dislinct BookinglD)
* [TolalCost]
* [Totalincome]
* [Totalincome|-[TotalCost]
* [TotalMargin]/[Totalllncome}*100

* count(distinct BookinglO)
* [TolalCost]
* [Totalincomel
* ITotalincome|-[TotalCost]
* [TotalMargin]/{Totalllncome}*100

QUESTION 37
Refer to the exhibit.

The data architect toads these fields from a data source A business analyst is creating an app for the human resources team Several visualizations are required
* Line chart to show the number of new hires and terminations monthly
* Treemap to show the number of employees by department and job level
* Distribution plot of annual salaries or amount of benefits received by duration of employment or location
* KPI to show average cost per employee
The cost per employee can be calculated by adding the employee salary to the amount of benefits received Which two additional fields does the business analyst need from the data architect lo meet these requirements? (Select two )

Number of h res and termination

Benefits received

Average cost of employee

Years employed

Department

QUESTION 38
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)

Mashup

Qlik Compose

Qlik NPrinting

Custom objects

Qlik GeoAnalytics

QUESTION 39
A business analyst s creating an app for the sales team. The app must meet several requirements
* Compare 10 top -performing sales representatives and the amount of sales for each
* Investigate margin percentage and total sales by each product category
* View distribution of sales amount
Which visualizations should be used for this app?

A treemap box plot, and histogram

A bar chart, line chart, and scatter plot

A treemap container and distribution plot

A bar chart scatter plot and histogram

QUESTION 40
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?

Create a concatenated key to associate the Employees and internEmp tables

Force an association between the InternEmp and the Orders tables

Create an association between the EmpID and EmployeelD fields

Concatenate the InternEmp table to the Employees tables within data manager

QUESTION 41
A user makes a selection within a sheet and then navigates to another sheet to validate the details However when the user returns to the original sheet the selection is removed What is causing this behavior?

The original sheet is in a different alternate state

A bookmark has been applied with default selections

The data has been reloaded and cleared the selection

An action has been defined to dear selections

To prepare for the QSBA2021 exam, candidates are encouraged to attend Qlik Sense training courses, read Qlik Sense documentation, and practice hands-on with Qlik Sense. The exam is available online and can be taken from anywhere in the world. Candidates have 120 minutes to complete the exam, which consists of 50 multiple-choice questions.

The QSBA2021 exam covers various topics, including data modeling, data analysis, and data visualization. The exam also tests the candidate’s ability to create and use Qlik Sense apps, manage data connections, and apply security measures. Additionally, the exam evaluates the candidate’s understanding of Qlik Sense’s architecture and deployment options.

Use Real Dumps – 100% Free QSBA2021 Exam Dumps: https://www.testkingfree.com/Qlik/QSBA2021-practice-exam-dumps.html