Q: Refer to the exhibit. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/QLIK_QSBA2024/page_47_img_1.jpg A movie analyst is using an app to gain insights into films created in the early 20th century. The analyst reviews the filter for Length Range, notices a hyphen "-", and selects it. What can the analyst determine from the resulting filter panes?

D Explanation: In Qlik Sense, a hyphen (-) displayed in a filter pane is the default visual representation for null values. Null values signify that data is missing or non-existent in the source for a particular field. The number 6 appearing next to the hyphen indicates that there are exactly six records (in this case, movies) in the dataset that have a null or empty value for the Length Range field. By selecting the hyphen, the analyst isolates these six records, confirming that their length data is missing.

Q: A business analyst has access to all of a company's data for the past 10 years. The source table consists of the following fields: TransactionID, TransactionTime, Transaction Date, Transaction Year, Cardholder, Cardholder address, Cardissuer, and Amount. Users request to create an app based on this source with the following requirements: • Users only review the data for the past 2 years • Data must be updated daily • Users should not view cardholder info Which steps should the business analyst complete to improve the app performance?

D Explanation: To optimize app performance, the primary goal is to reduce the amount of data loaded into Qlik's in-memory engine. This involves reducing both the number of columns (fields) and rows (records). Option D provides the most effective and appropriate strategy. Deselecting the Cardholder and other unnecessary fields reduces the width of the data model. Applying a filter during the data extraction process to only load the last two years of transactions significantly reduces the number of rows, which is the most impactful performance improvement. Finally, in a managed Qlik Sense environment, scheduling automated daily reloads is an administrative task performed in the Qlik Management Console (QMC), so requesting this from a system administrator is the correct procedure.

Question 1

A business analyst needs to create a visualization that compares two measures over time using a
continuous scale that includes a range. The measures will be Profit and Revenue.
Which visualization should the business analyst use?

Accepted Answer

A

Explanation: A line chart is the most suitable visualization for this scenario. It is specifically designed to display trends of one or more measures over a continuous interval or time period. By plotting both Profit and Revenue as separate lines on the same chart, the business analyst can effectively compare their performance and identify patterns, trends, and relationships over time. The continuous x-axis represents time, and the y-axis represents the value of the measures, fulfilling all the requirements of the question.

Question 2

A business analyst is creating a new app with sales dat
a. The visualizations must meet several requirements:
A Bar chart that shows sales by product group is used in multiple sheets
• A KPI object that visualizes that the total amount of sales is used once
• A Treemap that shows margin by product group is used one time inside a Container
Which visualization should be added to the master items library?

Accepted Answer

C

Explanation: The primary purpose of the master items library in Qlik Sense is to create reusable assets to ensure consistency and simplify app maintenance. The scenario explicitly states the Bar chart is "used in multiple sheets." Making it a master visualization allows the analyst to create it once and reuse it across the app. Any subsequent modifications to the master item will automatically propagate to all instances, which is the intended and most efficient use of this feature. The other visualizations (KPI, Treemap) are used only once, so the reusability benefit of making them master items is not applicable in this context.

Question 3

The VP of Sales asks a business analyst to include a KPI object on the sales dashboard that shows
total sales value for the year 2022, regardless of selections. Existing fields in the data model include
Sales and Year.
How should the business analyst write the measure for the KPI object?

Accepted Answer

C

Explanation: The requirement is to calculate a value "regardless of selections." In Qlik's Set Analysis syntax, the identifier 1 is used to represent the entire set of records in the data model, thereby ignoring any selections made by the user. The expression Sum({1} Sales) correctly calculates the sum of the Sales field over all records in the application. While the full expression to meet the request would also need a modifier for the year ( ), this option correctly uses the identifier required to ignore selections.

Question 4

A project management team uses an app to monitor different projects.
• Projects may have co-dependent tasks and processes
• Some projects include subtasks
The business analyst needs to use a diagram similar to a workflow with the processes and the sub
tasks represented as boxes with lines to relate them to each other. The color of the boxes could also
be determined by the status of each project or task.
Which visualization should be used?

Accepted Answer

D

Explanation: A network chart is the ideal visualization for this scenario. It is specifically designed to represent entities (nodes) and the relationships between them (links or edges). In this case, the project tasks and subtasks are the nodes, and their co-dependencies are the links. The network chart allows for complex, non-hierarchical relationships, which is crucial for co-dependent tasks. Furthermore, it supports customizing the visual properties of the nodes, such as coloring the boxes based on the project or task status, directly fulfilling all the business analyst's requirements.

Question 5

A business analyst receives an image of a dashboard from the HR Director and is asked to recreate
the image in Qlik Sense. The image shows charts for:
• Company employee structure
• Average employee salary by region
• Geographical representation of office capacity
• Company retention over time
Which charts will meet these analysis requirements?

Accepted Answer

D

Explanation: This combination of charts directly addresses the four analytical requirements. An org chart is specifically designed to visualize hierarchical data like a company's employee structure. A bar chart is ideal for comparing a measure (average salary) across a categorical dimension (region). A map chart is the standard and most effective way to display geographical data, such as office locations and their capacity. Finally, a line chart is the best practice for showing trends and changes in a measure (company retention) over a continuous period, such as time.

Question 6

Two customers in an organization want to use an app that contains a finance data set. With different
analysis objectives, each customer will only use a subset of that data. Which procedure should the
business analyst follow?

Accepted Answer

B

Explanation: Set analysis is the most appropriate Qlik Sense feature for this scenario. It allows a business analyst to create specific expressions within visualizations that define a data scope independent of the user's current selections. By using set analysis, the analyst can build different charts or tables on the same or different sheets, each tailored to a customer's unique analytical objective. This approach maintains a single app and a single data model, ensuring efficiency, consistency, and ease of maintenance while providing customized analytical views for each customer.

Question 7

A clothing manufacturer has operations throughout Europe and needs to manage access to the data.
There is data for the following countries under the field SACOUNTRY -> France, Spain, United
Kingdom and Germany. The application has been designed with Section Access to manage the data
displayed.
QSBA2024 practice exam questions

What is the expected outcome of this Section Access table?

Accepted Answer

A

Explanation: The Section Access table controls data visibility. USER1, with an ACCESS level of 'USER', is linked to SACOUNTRY values 'France' and 'Spain' across two rows, granting access to data from both countries. USER2, also a 'USER', is linked only to 'United Kingdom' and will see data for that country exclusively. The USERID 'ADMIN' is assigned the 'ADMIN' ACCESS level. This level grants the user complete access to all data within the application, bypassing any data reduction fields. Therefore, the ADMIN user will see data for all countries present in the data model: France, Spain, United Kingdom, and Germany.

Question 8

A business analyst created a visualization that has a color indicator when an order is below a certain
fixed profit threshold. This visualization now needs to change so that the threshold can be defined by
the user. The user base is approximately 1000 heavy Excel users. These thresholds will be defined by
each user somewhat frequently, although the data changes only once per day.
Which action should the business analyst take to update this visualization?

Accepted Answer

C

Explanation: The most effective and efficient solution is to use a variable controlled by a slider. Variables in Qlik Sense act as dynamic placeholders whose values can be changed by users in real-time without requiring a data reload. By linking a variable to a slider object, users can intuitively adjust the threshold value. The visualization's color expression can then reference this variable (e.g., If(Sum(Profit) < $(vProfitThreshold), 'red', 'green')). This approach provides each user with a personalized, interactive experience, which is ideal for "what-if" analysis and aligns perfectly with the requirements.

Question 9

Refer to the exhibit. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/QLIK_QSBA2024/page_47_img_1.jpg A movie analyst is using an app to gain insights into films created in the early 20th century. The analyst reviews the filter for Length Range, notices a hyphen "-", and selects it. What can the analyst determine from the resulting filter panes?

Accepted Answer

D

Explanation: In Qlik Sense, a hyphen (-) displayed in a filter pane is the default visual representation for null values. Null values signify that data is missing or non-existent in the source for a particular field. The number 6 appearing next to the hyphen indicates that there are exactly six records (in this case, movies) in the dataset that have a null or empty value for the Length Range field. By selecting the hyphen, the analyst isolates these six records, confirming that their length data is missing.

Question 10

A business analyst has access to all of a company's data for the past 10 years. The source table
consists of the following fields: TransactionID, TransactionTime, Transaction Date, Transaction Year,
Cardholder, Cardholder address, Cardissuer, and Amount.
Users request to create an app based on this source with the following requirements:
• Users only review the data for the past 2 years
• Data must be updated daily
• Users should not view cardholder info
Which steps should the business analyst complete to improve the app performance?

Accepted Answer

D

Explanation: To optimize app performance, the primary goal is to reduce the amount of data loaded into Qlik's in-memory engine. This involves reducing both the number of columns (fields) and rows (records). Option D provides the most effective and appropriate strategy. Deselecting the Cardholder and other unnecessary fields reduces the width of the data model. Applying a filter during the data extraction process to only load the last two years of transactions significantly reduces the number of rows, which is the most impactful performance improvement. Finally, in a managed Qlik Sense environment, scheduling automated daily reloads is an administrative task performed in the Qlik Management Console (QMC), so requesting this from a system administrator is the correct procedure.

Free Qlik QSBA2024 Actual Exam Questions