Qlik QSBA2024 Practice Questions with Explanations

Free Qlik QSBA2024 practice questions. 11 of them, each with the correct answer, a full explanation, and the reason every other option is wrong.

QSBA2024 practice questions

Question 1

A business analyst is creating a new app with sales data. 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?

  • A. Container
  • B. KPI
  • C. Bar chart
  • D. Treemap
Show answer and explanation ▾

Correct answer: C

Master visualizations exist so one object can be reused across sheets and maintained in one place. The bar chart is the only visualization used on multiple sheets, so it is the one that belongs in the master items library.

Why the other options are wrong:

  • A. The container is used once, so there is nothing to gain by making it a master item.
  • B. The KPI object is used only once, so it does not need to be a reusable master visualization.
  • D. The treemap is used one time inside the container, so it is not reused anywhere.

Question 2

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?

  • A. Apply Section Access to manage the data for each customer
  • B. Create multiple visualizations using set analysis
  • C. Duplicate and rename the apps for each customer
  • D. Unpivot, then re-associate the data tables for each customer
Show answer and explanation ▾

Correct answer: A

Section Access reduces the data in a single app according to who opens it, so each customer sees only the subset they are entitled to without maintaining separate copies of the app.

Why the other options are wrong:

  • B. Set analysis changes what a chart calculates but does not control which data each customer can reach.
  • C. Duplicating the app creates copies to maintain and does not limit the data inside each copy.
  • D. Unpivoting and re-associating tables changes the data structure, not the data each customer can use.

Question 3

A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customer now wants the price ranges to be dynamically modified so they are configurable by the application users. The business analyst modified the dimension axis on the visualization.

Which step should the business analyst complete next?

  • A. Define a variable and use it in a variable input object on the sheet
  • B. Create a calculated field in Data manager, using the Class() function
  • C. Load an independent source file to contain the user-defined boundary values
  • D. Create the price range dimension using the Buckets feature in Data manager
Show answer and explanation ▾

Correct answer: A

A variable can hold the range width used in the dimension expression, and a variable input object on the sheet lets users change that value themselves, so the price ranges update dynamically.

Why the other options are wrong:

  • B. A calculated field in Data manager is fixed at load time and cannot be changed by app users.
  • C. A separate source file would need editing and reloading, so users cannot change the ranges on the sheet.
  • D. Buckets created in Data manager are fixed at load time and are not configurable by app users.

Question 4

A business analyst is creating an app using a dataset from ServiceNow. The dataset shows information about support cases, including how many days it has been since the case was opened (age). The app requirements are: • The dashboard must display support cases in categories based on the age (New, Aging, and Beyond Service Level Agreement) • The categories will be used multiple times in the dashboard • Given the volume of support cases, it is expected that the dataset will grow to be very large Which solution is the most efficient way for the business analyst to create this app?

  • A. Ask the ServiceNow team to create the field in the source dataset
  • B. Create an Excel sheet with all possible age values and the corresponding categories to add to the data model
  • C. Create a new field for the categories using the Bucket option in the Data manager
  • D. Write a master dimension with a nested IF statement to group ages together
Show answer and explanation ▾

Correct answer: C

The Bucket option in Data manager groups the age values into named ranges and stores the result as a new field at load time. The categories are then calculated once and can be reused across the dashboard, even as the data grows.

Why the other options are wrong:

  • A. Relying on another team to change the source is slower than creating the field in the app.
  • B. A manual sheet of every possible age value must be maintained by hand and adds an unnecessary table.
  • D. A nested IF dimension is evaluated at chart time on every row, which slows down as the dataset grows.

Question 5

A dashboard developer finishes creating a supply chain analysis app and is presenting it to leadership for review. The landing page shows four visualizations including: • Bar chart showing available supply by product category • Line chart showing total cost of deliveries to the warehouse by month-year • Scatter plot showing cost of delivery and time-to-deliver by product • A map that shows the volume of delivery from suppliers to warehouses using a line layer Leadership asks the developer how they can see the total cost of delivery overall. How can the analyst show this information to leadership?

  • A. Use the line chart to add up each month-year to get to the number required
  • B. Create a KPI object that shows the total cost of delivery
  • C. Adjust the line layer on the map to reflect cost of delivery
  • D. Select all products in the scatter plot to see the total delivery cost
Show answer and explanation ▾

Correct answer: B

A KPI object displays a single aggregated value, so it is the direct way to show the overall total cost of delivery on the landing page.

Why the other options are wrong:

  • A. Adding up monthly points by hand is slow and error prone.
  • C. A line layer shows flows between locations, not a single overall total.
  • D. Selecting products in a scatter plot does not display a total value.

Question 6

A business analyst needs to create two side-by-side charts for a sales department with the following data: • Number of orders • Name of the customer • Percentage of margin • Total sales The charts use a common dimension, but each chart has different measures. The analyst needs to create a color association between the two charts on the dimension values. Which action should the business analyst take?

  • A. Use nested IF statements to set the colors by expression for each dimension value
  • B. Define the color values in the master measures and use the color library
  • C. Select 'By Dimension' and 'Persistent colors' in the Colors property panel
  • D. Use the FieldIndex function to set the colors by expression for each dimension value
Show answer and explanation ▾

Correct answer: C

Coloring both charts by the shared dimension with persistent colors assigns each dimension value a color that stays the same between selection states, so a value can be recognized by its color in both charts.

Why the other options are wrong:

  • A. Nested IF color expressions must be written and maintained for every value in each chart.
  • B. Colors on master measures apply to measures, not to the values of the shared dimension.
  • D. A FieldIndex color expression must be built and maintained in each chart and is not the built-in setting for this.

Question 7

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, TransactionDate, TransactionYear, 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?

  • A. • Delete Cardholder and time fields in Data manager • Use a bookmark based on auto-calendar fields • Use the reload function in the sheet Editor asset panel
  • B. • Delete Cardholder and time fields in Data manager • Use set analysis to show data based on transaction year • Use an API to perform a daily reload task
  • C. • Deselect Cardholder and time fields in Data manager • Use a filter pane based on auto-calendar fields • Perform a daily reload via the Data manager
  • D. • Deselect Cardholder and time fields in Data manager • Apply a filter to extract data based on transaction year • Request a daily reload task from the system admin
Show answer and explanation ▾

Correct answer: D

Deselecting the cardholder and time fields keeps them out of the app, and filtering on transaction year loads only the two years users need, so the app holds less data. A scheduled reload task set up by the system admin keeps it updated daily.

Why the other options are wrong:

  • A. A bookmark does not reduce the data loaded, and it does not provide a daily update.
  • B. Set analysis limits what a chart shows but all 10 years are still loaded into the app.
  • C. A filter pane does not reduce the data loaded, and a manual reload is not a dependable daily update.

Question 8

A business analyst is 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. A bar chart, scatter plot, and histogram
  • B. A treemap, container, and distribution plot
  • C. A bar chart, line chart, and scatter plot
  • D. A treemap, box plot, and histogram
Show answer and explanation ▾

Correct answer: A

A bar chart compares the sales of the top 10 representatives, a scatter plot relates margin percentage to total sales for each product category, and a histogram shows how the sales amounts are distributed.

Why the other options are wrong:

  • B. A container only holds other charts, so this set does not cover the three requirements.
  • C. A line chart shows trends over time and does not show the distribution of sales amounts.
  • D. A treemap shows hierarchy and share, and this set has no chart relating margin percentage to total sales.

Question 9

An app needs to load a few hundred rows of data from a .csv text file. The file is the result of a concatenated data dump by multiple divisions across several countries. These divisions use different internal systems and processes, which causes country names to appear differently. For example, the United States of America appears in several places as 'USA', 'U.S.A.', or 'US'.

For the country dimension to work properly in the app, the naming of countries must be standardized in the data model.

Which action should the business analyst complete to address this issue?

  • A. Create a calculated master dimension expression
  • B. Load a lookup table to convert values
  • C. Cleanse the source text file prior to loading
  • D. Use the Replace option in Data manager
Show answer and explanation ▾

Correct answer: B

A lookup table that pairs each variant such as USA, U.S.A. and US with one standard country name converts the values during the load, so the country field is consistent in the data model and stays consistent on every reload.

Why the other options are wrong:

  • A. A calculated master dimension works at chart level and does not standardize the field in the data model.
  • C. Editing the source file by hand has to be repeated each time the file is produced.
  • D. Replacing values one by one in Data manager is a manual edit for every variant and is not the maintainable way to standardize the names.

Question 10

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 for each Stage (Initial to Won) of the sales process.

Which visualizations will meet these requirements?

  • A. Scatter plot: Measures X-axis Sales and Y-axis Margin, Dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales
  • B. Scatter plot: Measures X-axis Sales and Y-axis Margin, Alternative dimensions Customer or Product category Funnel chart: Segments Stage, Width Sales
  • C. Combo chart: Measures Sales and Margin, Dimensions Customer or Product category Pie chart: Dimension Stage, Measure Sales
  • D. Distribution plot: Alternative measures Sales and Margin, Alternatives dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales
Show answer and explanation ▾

Correct answer: B

A scatter plot with Sales and Margin on the axes shows whether their relationship is linear, and alternative dimensions let the manager switch between Customer and Product Category. A funnel chart shows Sales for each stage of the sales process from Initial to Won.

Why the other options are wrong:

  • A. A bar chart does not present the stages as a sales process funnel, and the dimensions are not set up as alternatives.
  • C. A combo chart does not show whether Sales and Margin have a linear relationship.
  • D. A distribution plot shows the spread of one measure, not the relationship between Sales and Margin.

Question 11

A banking organization needs a dashboard that shows the following: • A KPI indicator for current year (CY) versus last year (LY) revenue • A scatter plot that shows the cost versus revenue of product categories • A treemap that shows average customer satisfaction rating based on regions • A table that shows CY cost by record number, financial instrument, and bank In addition to the customer satisfaction rating, which fields should be used to create the required measures?

  • A. CY Revenue, LY Revenue, CY Cost
  • B. CY Revenue, LY Revenue, Cost
  • C. Revenue and Cost
  • D. Revenue and CY Cost
Show answer and explanation ▾

Correct answer: A

The KPI compares CY Revenue with LY Revenue, and the table lists CY Cost. The scatter plot of cost versus revenue can be built from the same CY Cost and CY Revenue fields, so these three fields cover every measure apart from the satisfaction rating.

Why the other options are wrong:

  • B. The table requires current year cost specifically, which a general Cost field does not provide.
  • C. Revenue and Cost alone do not separate current year from last year values.
  • D. A single Revenue field cannot provide the current year versus last year comparison.

That was 11 of 50.

The full Qlik QSBA2024 pack has all 50 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. $39.00 USD, paid once, with free monthly updates and a pass-or-your-money-back guarantee.

Get the full pack

Not ready yet? Get the first 16 free as one PDF by email. Get the Half Pack →

About the QSBA2024 exam

These 11 Qlik QSBA2024 questions are free here. The free PDF has 16, free by email.

They are drawn from the same bank as the full QSBA2024 pack, which has 50 questions in total.

Back to blog