QSBA2024 sample questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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.

Question 9

When interpreting the results from Qlik's associative model, what does the color white signify in a filter pane list?

Accepted Answer

The value is associated with the current selection and is still a possible selection.

Answer

The value has been explicitly selected by the user.

Answer

The value is unrelated to the current selection.

Answer

The value is an alternative selection that is not currently active.

Question 10

A business analyst needs to create a KPI that shows the Year-over-Year (YoY) sales growth percentage. The app contains a `Sales` field and a `Year` field. Which expression would correctly calculate this metric, assuming the user might select a single year?

Accepted Answer

(Sum({ } Sales) - Sum({ } Sales)) / Sum({ } Sales)

Answer

(Sum(Sales) - Above(Sum(Sales))) / Above(Sum(Sales))

Answer

Sum(Sales) / Sum({$ } Sales) - 1

Answer

Sum(Sales) / Sum(total Sales) - 1

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?

When interpreting the results from Qlik's associative model, what does the color white signify in a filter pane list?

A business analyst needs to create a KPI that shows the Year-over-Year (YoY) sales growth percentage. The app contains a `Sales` field and a `Year` field. Which expression would correctly calculate this metric, assuming the user might select a single year?

10 more free samples are waiting