[Q20-Q37] Full QSBA2021 Practice Test and 52 Unique Questions, Get it Now!

Rate this post

Full QSBA2021 Practice Test and 52 Unique Questions, Get it Now!

The Best QSBA2021 Exam Study Material Premium Files and Preparation Tool

The QSBA2021 exam covers a range of topics related to Qlik Sense Business Intelligence, including data modeling, data visualization, data analysis, and data storytelling. To pass the exam, candidates must demonstrate a deep understanding of these topics and be able to apply their knowledge to real-world scenarios. The exam consists of multiple-choice questions and is timed, with a total duration of 120 minutes. Successful candidates will receive a Qlik Sense Business Analyst Certification, which is a valuable credential in today’s data-driven business environment.

NEW QUESTION 20
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

NEW QUESTION 21
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

NEW QUESTION 22
A business analyst is creating an app that requires several visualizations
* A scatter plot mat shows the margin percentage and total sales by product category
* A map with a the layer that visualizes lines between retail stores and lactones
* A KPI that shows total cost
Margin% can be calculated by dividing profit by revenue Profit is the difference between total cost and total sates Which two sets of fields can the business analyst use to meet these requirements? (Select two.)

Line Geometry
Margin%

Product Category
Location

Sales
Total Cost

Product Category
Retail Store Location
Factory Location

Line Geometry

NEW QUESTION 23
A business analyst must add data from several tables to an existing app This app was built by a previous business analyst who used the data load editor to load some simple tables.
The changes must be implemented in the data manager
Which three actions should the business analyst take to matt these requirements? (Select three )

Associate the new tables with the old tables

Synchronize the scripted tables and modify the tables

Synchronize the new tables and modify the tables

Add the new tables via the Add data icon

Delete the existing tables and re-import the tables

NEW QUESTION 24
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?

An email trigger on a data reload

An action on the sheet containing the KPI

A destination using Qlik NPrinting

A condition using Qlik Alerting

NEW QUESTION 25
The sales manager is investigating the relationship between Sales and Margin to determine if this relationship is linear when choosing the dimension Customer or Product Category The sales manager wants to have the potential percentage Sales tor each Stage (initial to Won) of the sales process What are the two correct visualizations?

Scatter Plot Measures X-axis Sates and Y-axis Margin Dimensions Customer or Product category Bar Chart Dimension Stage, Measure Sates

Distribution Plot Alternatives Measures Sales and Margin Alternatives dimensions Customer or Product category Bar Chart Dimension Stage. Measure Sates

Combo Chan Measures Sales and Margin Dimensions Customer or Product category Pie Chart Dimension Stage Measure Sales

Scatter Plot Measures X-axis Sates and Y-axis Margin Alternatives dimensions Customer or Product category Funnel Chart Segments Stage Width Sales

NEW QUESTION 26
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)

NEW QUESTION 27
A large auditing firm has a proprietary web portal that all of the’ customers use to access their own dat a. 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 Qlik Series app is reloaded.
What should the business analyst recommend?

Qlik Dynamic news

ODAG

Embedded Stories

Qlik APIs

NEW QUESTION 28
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?

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

NEW QUESTION 29
A company CEO requests a dashboard that easily displays provides understating and tracks company performance. There are several ma n dashboard requirements:
* Viewable by a mobile device
* Display multiple key measures
* Provide ability to easily navigate to other sheets
Which feature meets these requirements?

Multi KPI object with master visualizations

Multiple text and images visualizations

Multiple visualizations m a container

Multi master item visualizations

NEW QUESTION 30
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

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

Filter pane scatter plot and a map

Filter pane bar chart and KPIs

Filter panes KPls and a combo chart

Filter pane KPls and a map

Filter panes KPIs and a line chart

NEW QUESTION 32
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?

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

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

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

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

NEW QUESTION 35
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

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

NEW QUESTION 37
Refer to 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?

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

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

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

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