ExamDumpster

Free QSBA2024 sample questions

These free QSBA2024 sample questions come with the answer and an explanation for each one. They cover business requirements, chart design and app development. Use them to check your Qlik Sense skills.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose one

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

Question 2Choose one

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?

Question 3Choose one

A business analyst is working with sensitive data and needs to implement section access in the script to restrict user access to specific rows. The section access table specifies which `Country` values each user can see. A user who is only granted access to 'USA' makes a selection on a product. What will this user see in the `Country` filter pane?

Question 4Choose one

During application design, an analyst determines that several complex calculations will be used repeatedly across more than 20 charts and tables. To ensure consistency, reduce errors, and simplify maintenance, what is the best practice for managing these calculations?

Question 5Choose 3

An analyst is building a manufacturing dashboard that includes data on production `Volume` and `DefectRate`. The business user wants to see the relationship between these two metrics in a scatter plot. The user also wants the size of each bubble in the plot to represent the `TotalCost` associated with that production run. Which actions must the analyst take to configure the scatter plot correctly? (Select THREE)

Question 6Choose one

Case Study: A mid-sized retail company, 'Urban Threads', wants to revamp its sales analytics. They have data in three separate sources: a transactional SQL database for sales, a CSV file for employee information including regional managers, and an Excel file containing quarterly sales targets per region. The Head of Sales has several requirements. First, they need a dashboard that shows overall sales performance against targets. Second, they need an analysis sheet where they can drill down from Region to individual Store, and then see top-selling products for that store. Third, regional managers must only be able to see data for their own region and the stores within it. The current data model has been loaded into Qlik Sense, but the tables are not yet associated correctly. The analyst needs to create a robust and secure application to meet all requirements. Which initial step in the Data load editor is most critical to ensure regional managers can be linked to their sales data and that security can be applied correctly?

Question 7Choose one

Continuing the 'Urban Threads' Case Study: To meet the requirement for regional managers to see only their own data, the analyst prepares a Section Access table. The table includes the columns `ACCESS` (with value 'USER'), `USERID`, and `Region`. The main sales data table also contains the `Region` field. What must the analyst do to ensure the field used for data reduction in Section Access is correctly capitalized?

Question 8Choose one

A business analyst is using the Data Manager and has loaded a table of transactions. The analyst needs to create a new column called 'Is High Value' which should be 'Yes' if the `SaleAmount` is greater than 1000, and 'No' otherwise. Where in the Data Manager interface can the analyst define this calculated field?

Question 9Choose one

A business analyst needs to create a bar chart showing `Sum(Sales)` by `Month`. The user wants the months to be sorted chronologically (Jan, Feb, Mar...) instead of alphabetically (Apr, Aug, Dec...). The `Month` field is currently a text field loaded from the source. What is the standard method to enforce chronological sorting for the `Month` field?

Question 10Choose one

A business analyst is creating a data model for a manufacturing company. The model includes a `Fact_Production` table and a `Dim_Machine` table. A circular reference occurs because `MachineID` and `ProductionLine` exist in both tables, creating an ambiguous path. What is the most robust and scalable method to resolve this circular reference while preserving all relationships? erDiagram Fact_Production ||--|{ Dim_Machine : "uses" Fact_Production { int ProductionID PK int MachineID FK string ProductionLine datetime Timestamp int Quantity } Dim_Machine { int MachineID PK string MachineName string ProductionLine string Location }

10 more free samples are waiting

Create a free account to unlock the whole QSBA2024 sample bank, or get full access to all 175 practice questions in the simulator.

Create account