QSBA2024 sample questions

Question 1

A financial services firm needs to create a risk exposure dashboard. A key requirement is to color-code a scatter plot of investments based on a calculated Risk Score, where scores below 20 are green, 20-50 are yellow, and above 50 are red. The Risk Score is already calculated as a measure. Which expression, used in the object's color properties, is the most efficient way to implement this requirement?

Accepted Answer

If([Risk Score] < 20, RGB(0,128,0), If([Risk Score] <= 50, RGB(255,255,0), RGB(255,0,0)))

Answer

If([Risk Score] < 20, 'Green', If([Risk Score] <= 50, 'Yellow', 'Red'))

Answer

Pick(Match([Risk Score], ' 50'), Green(), Yellow(), Red())

Answer

ColorMix1( (([Risk Score]-0)/100), Green(), Red())

Question 2

A supply chain analyst is building an application to monitor inventory levels. The primary data table contains `ProductID`, `WarehouseID`, `TransactionDate`, and `Quantity`. The analyst needs to create a master measure that calculates the 'Stock on Hand' for any given date selection. This requires summing all quantities for transactions up to and including the maximum selected date. Which set analysis expression correctly calculates this running total?

Accepted Answer

Sum({ } Quantity)

Answer

Sum({1 } Quantity)

Answer

Sum({ =$(=Min(TransactionDate))'}>} Quantity)

Answer

Aggr(RangeSum(Above(Sum(Quantity), 0, RowNo())), TransactionDate)

Question 3

A business analyst at an e-commerce company is creating a dashboard. They need to display the top 5 customers by sales, but also include an 'Others' category that aggregates the sales for all remaining customers. How can this be achieved within a single bar chart dimension?

Accepted Answer

Use the chart's built-in 'Limitation' property to show the top 5 and check the 'Show others' box.

Answer

Create a calculated dimension using: If(Aggr(Rank(Sum(Sales)), Customer) <= 5, Customer, 'Others')

Answer

Create a bookmark for the top 5 customers and use a button to toggle the view.

Answer

Manually group the customers in the Data Manager.

Question 4

A business analyst has loaded two tables, `Sales` and `Sales_Targets`, into the Data Manager. Both tables contain a `Region` and a `Quarter` field (e.g., 'Q1 2024'). To analyze performance against targets, these tables must be associated. However, the business analyst wants to avoid a synthetic key on `Region` and `Quarter`. What is the recommended approach in the Data load editor to create a robust, single-field key for this association?

Accepted Answer

In the script for each table, create a new key field: Region & '|' & Quarter as CompositeKey.

Answer

Use the Qualify statement on both tables to prevent associations.

Answer

Use the `AutoNumber(Region, Quarter)` function in both tables.

Answer

Rename the Quarter field in one of the tables to `Sales_Quarter` to break the link.

Question 5

During a requirements gathering session for a new human resources dashboard, the HR Director states, 'I need to see the employee headcount trend over the last 3 years, but I also need to be able to see the distribution of employees by age bracket and tenure at any point in time. It must be clear how our demographics are shifting.' Which combination of visualizations would best fulfill all aspects of this request? (Select TWO)

Accepted Answer

A line chart showing headcount over time.

Accepted Answer

A distribution plot or histogram for age brackets and tenure.

Answer

A KPI object showing the current total headcount.

Answer

A pivot table listing every employee and their age.

Answer

A scatter plot with age vs. tenure.

Question 6

True or False: When using Data Manager to associate two tables, if Qlik Sense provides a recommendation with a high confidence score, the analyst should always apply it without further investigation to ensure model efficiency.

Accepted Answer

False

Answer

True

Question 7

An analyst is building an app for the sales team. A requirement is to show the sales performance of each salesperson relative to the average sales of their specific region. Which function should be used to achieve this comparison within a chart expression?

Accepted Answer

Sum(Sales) / Avg(total Sales)

Answer

Sum(Sales) / Avg({ } Sales)

Answer

Sum(Sales) / Avg(Aggr(Sum(Sales), Region))

Question 8

A business analyst is designing a dashboard for executives. The primary goal is to provide a high-level overview of company performance on a single screen, with the ability to understand the status of key metrics at a glance. The design should follow the DAR (Dashboard, Analysis, Reporting) methodology. Which sheet design principle is most appropriate for this initial dashboard sheet?

Accepted Answer

A collection of KPI objects, gauges, and summary charts with minimal text.

Answer

A large pivot table with many dimensions and measures for detailed exploration.

Answer

A text and image object containing a detailed written summary of the quarterly performance.

Answer

A single, complex scatter plot showing the relationship between multiple business drivers.

Question 9

A marketing analyst needs to create a story to present campaign results. The presentation must include a slide showing the state of the app when the 'Email' campaign is selected, and another slide showing the state when the 'Social Media' campaign is selected. However, the analyst also needs one slide with a live, interactive chart where they can make selections during the presentation. How should the analyst construct this story?

Accepted Answer

Take a snapshot for 'Email', a snapshot for 'Social Media', and embed the live sheet for the interactive slide.

Answer

Create three bookmarks for the three states and add them to the story.

Answer

Add three live sheets to the story; make the selections manually during the presentation.

Answer

Export the charts as images for the two campaigns and embed a link to the app for the third slide.

Question 10

A business analyst is profiling a newly loaded `Customers` table. In a filter pane for the `PostalCode` field, the analyst notices that some codes are formatted as five-digit numbers (e.g., 90210) while others are strings (e.g., 'SW1A 0AA'). This data quality issue is causing incorrect associations and sorting problems. What is the most appropriate place to standardize the `PostalCode` field to a text format for all records?

Accepted Answer

In the Data load editor, by wrapping the `PostalCode` field in the `Text()` function during the LOAD statement.

Answer

In the chart properties, using the `Text()` function on the `PostalCode` dimension.

Answer

In the Data Manager, by applying a transformation to the `PostalCode` column.

Answer

In the source database, by asking a DBA to change the column's data type.

Top vendors

Top exams

Free QSBA2024 sample questions

A business analyst at an e-commerce company is creating a dashboard. They need to display the top 5 customers by sales, but also include an 'Others' category that aggregates the sales for all remaining customers. How can this be achieved within a single bar chart dimension?

True or False: When using Data Manager to associate two tables, if Qlik Sense provides a recommendation with a high confidence score, the analyst should always apply it without further investigation to ensure model efficiency.

An analyst is building an app for the sales team. A requirement is to show the sales performance of each salesperson relative to the average sales of their specific region. Which function should be used to achieve this comparison within a chart expression?

10 more free samples are waiting