QSBA2024 Qlik Sense Business Analyst Practice Questions
Prepare for QSBA2024 with more than an answer.
- Exam fee
- $250 USD
- Level
- Professional
- Valid for
- No expiration
Domains covered on the exam 4
- Identify Requirements30%
- Design Applications24%
- Prepare and Load Data14%
- Develop Applications32%
- 1
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?
Show answer details
Correct answer: C
This is the most critical first step. Creating a clean, logical data model (like a star schema) is fundamental. Ensuring the
Regionfield is standardized and used as the key to link sales, targets, and employee data allows for both the performance analysis (sales vs. targets) and the implementation of Section Access for regional managers. Without this foundational link, none of the other requirements can be met reliably. - 2
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, andRegion. The main sales data table also contains theRegionfield. What must the analyst do to ensure the field used for data reduction in Section Access is correctly capitalized?Show answer details
Correct answer: B
A critical rule of Section Access is that the field names used for data reduction must be in all uppercase letters in both the
SECTION ACCESSpart of the script and theSECTION APPLICATIONpart. Therefore, the analyst must ensure the field is namedREGION(uppercase) in the Section Access table and that the corresponding field in the main data model is also loaded or aliased asREGION. - 3
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
SaleAmountis greater than 1000, and 'No' otherwise. Where in the Data Manager interface can the analyst define this calculated field?Show answer details
Correct answer: B
Within the Data Manager, you can select a table and choose to edit it. This opens a view of the table's data and columns, where there is an option to add a new calculated field. The analyst can then enter an expression, such as
If(SaleAmount > 1000, 'Yes', 'No'), to create the new column. - 4
A business analyst needs to create a bar chart showing
Sum(Sales)byMonth. The user wants the months to be sorted chronologically (Jan, Feb, Mar...) instead of alphabetically (Apr, Aug, Dec...). TheMonthfield is currently a text field loaded from the source. What is the standard method to enforce chronological sorting for theMonthfield?Show answer details
Correct answer: D
The
Dual()function is the canonical way to solve this problem in Qlik. It creates a field that stores both a string value (for display) and a numeric value (for sorting and calculations). By creating theMonthfield in the script withDual(MonthName, MonthNumber), Qlik will automatically sort it chronologically in all objects by default. - 5
A business analyst is creating a data model for a manufacturing company. The model includes a
Fact_Productiontable and aDim_Machinetable. A circular reference occurs becauseMachineIDandProductionLineexist 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 }Show answer details
Correct answer: B
Creating a composite key (often called a link key or concatenated key) is the standard best practice for resolving synthetic keys or circular references caused by multiple common fields. This method creates a single, unique key (
%MachineLine_Key) that represents the combination ofMachineIDandProductionLine. This key is then used to link the fact and dimension tables, resolving the ambiguity and creating a clean star schema model. Renaming fields breaks valid relationships, and dropping fields leads to data loss. - 6
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?
Show answer details
Correct answer: D
The most efficient and correct method is to use a nested
Ifstatement with theRGB()color functions. Using color names like 'Green' is not a valid function output for color expressions.Pick(Match())is overly complex for a numerical range comparison.ColorMix1is used for creating a gradient between two colors based on a value's position within a range (0 to 1), not for defining discrete color breaks as required by the scenario. - 7
A supply chain analyst is building an application to monitor inventory levels. The primary data table contains
ProductID,WarehouseID,TransactionDate, andQuantity. 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?Show answer details
Correct answer: A
This expression correctly calculates the cumulative sum. The set modifier
TransactionDateis less than or equal to the maximumTransactionDatecurrently in the selection scope. This effectively creates a running total up to the selected point in time, while still respecting other selections likeProductIDorWarehouseID. - 8
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?
Show answer details
Correct answer: A
The most direct and intended way to achieve this in Qlik Sense is by using the dimension or measure limitation properties within the chart itself. You can set the limitation to 'Fixed number' for the top 5, and then simply enable the 'Show others' option to automatically group the remaining values.
- 9
A business analyst has loaded two tables,
SalesandSales_Targets, into the Data Manager. Both tables contain aRegionand aQuarterfield (e.g., 'Q1 2024'). To analyze performance against targets, these tables must be associated. However, the business analyst wants to avoid a synthetic key onRegionandQuarter. What is the recommended approach in the Data load editor to create a robust, single-field key for this association?Show answer details
Correct answer: B
The best practice to resolve a multi-field association and avoid synthetic keys is to create a composite key. This involves concatenating the linking fields (Region and Quarter) with a separator into a new, single key field in both tables. This creates a clean, efficient, and direct link between the tables.
- 10
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)
Show answer details
Correct answer: A, D
A line chart is the standard and most effective way to show a trend over a continuous period, directly addressing the requirement to see the headcount trend over 3 years.
A distribution plot or histogram is specifically designed to show how data is distributed across different bins or brackets, making it the perfect choice to visualize the distribution of employees by age and tenure.
