QlikView QSBA2024 Practice Exams
Last updated on Apr 01,2025- Exam Code: QSBA2024
- Exam Name: Qlik Sense Business Analyst Certification Exam - 2024
- Certification Provider: QlikView
- Latest update: Apr 01,2025
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
A business analyst needs to build a chart that enables users to analyze the correlation between the following measures for all products:
• Product Sales ($)
• Order Volume
• Margin%
Which visualization should the business analyst use?
- A . Multi KPI
- B . Combo chart
- C . Scatter plot
- D . Pivot table
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, Transaction Date, Transaction Year, 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
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 Fieldlndex function to set the colors by expression for each dimension value
A business analyst needs to create a visualization that compares two measures over time using a continuous scale that includes a range. The measures will be Profit and Revenue.
Which visualization should the business analyst use?
- A . Line chart
- B . Bullet chart
- C . Bar chart
- D . Scatter plot
A data analyst is working on a new Qlik Sense application and realizes that some of the required data sources have already been used in previous applications. To streamline the data loading process and maintain consistency, the analyst decides to leverage existing data connections.
What actions should the analyst take to utilize the pre-existing data connections in Qlik Sense?
- A . Copy the script from the old application and paste it into the new application’s script editor
- B . Access the Data load editor and select the desired data connection from the list of available connections
- C . Export the data connection from the old application and import it into the new one
- D . Use a Qlik Sense extension to search and replicate data connections from other applications
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
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
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
Refer to the exhibit.
A business analyst must add a list of temporary employees (interns) to the current sales app. The app contains an existing employees table. When the business analyst profiles the data, the association view displays possible associations as shown.
Which action should the business analyst take in Data manager to meet the requirements?
- A . Create a concatenated key to associate the Employees and InternEmp tables
- B . Concatenate the InternEmp table to the Employees tables within Data manager
- C . Force an association between the InternEmp and the Orders tables
- D . Create an association between the EmpID and EmployeelD fields