Free Qlik Sense Business Analyst Certification Exam – 2024 Exam QSBA2024 Exam Practice Test

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

• CY Revenue, LY Revenue, CY Cost
• CY Revenue, LY Revenue, Cost
• Revenue and Cost
• 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 dashboardGiven 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?

• Ask the ServiceNow team to create the field in the source dataset
• Create an Excel sheet with all possible age values and the corresponding categories to add to thedata model
• Create a new field for the categories using the Bucket option in the Data manager
• Write a master dimension with a nested IF statement to group ages together

The business analyst creates one table by concatenating and joining several source tables. This has resulted in a table of several thousand rows that may have several columns containing between 30% and 70% null values. The business analyst needs to understand the level of null values in each field of this table to determine if this is an issue.Which capability should the business analyst use?

• Select each field in the Data model viewer and use the Density value to determine the level of nulls
• Enable the Preview Panel in the Data model viewer and inspect the data table visually to determine the level of null values
• Look at the tags fields for any indication that $null is associated to this field
• Inspect each field in the Data model viewer and use the Subset ratio to determine the level of null values

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?

• Apply Section Access to manage the data for each customer
• Create multiple visualizations using set analysis
• Duplicate and rename the apps for each customer
• Unpivot, then re-associate the data tables for each customer

A marketing team needs to display sales for a limited number of products by providing a bar chart that the user can control. The visualization has several requirements:Starts with the top five productsAllows the user to change the number of products displayedAllows the user to scroll through all products on a mini chartThe business analyst creates a bar chat and a variable. Which steps should the business analyst complete next?

• Add the slider object and use the variable to set its value
• Set the number of bars to custom and use the variable to set its value B.
• Use the variable to fix the limitation
• Add an input box to enable the user to enter the required value C.
• Use the variable to fix the limitation
• Add a slider object and use the variable to set its value D.
• Add the slider object and use the variable to set its value
• Use the properties to set the number of bars to custom

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?

• Copy the script from the old application and paste it into the new application's script editor
• Access the Data load editor and select the desired data connection from the list of available connections
• Export the data connection from the old application and import it into the new one
• Use a Qlik Sense extension to search and replicate data connections from other applications

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 sheetsA KPI object that visualizes that the total amount of sales is used onceA Treemap that shows margin by product group is used one time inside a Container Which visualization should be added to the master items library?

• Container
• KPI
• Bar chart
• Treemap

A business analyst is working with a customer to refine the end user experience. The customer has the following requirements:Ability to provide these charts to a specific user groupMinimize the number of navigation clicks between chartsAchieve fastest screen response time when switching between chartsMaximize the chart size in terms of screen real estateWhich action should the business analyst take to meet the requirements?

• Use Conditional show on all charts and overlay the charts in the same location
• Create a single sheet with every required chart on this single sheet
• Use a container object to host the required visualizations
• Create several sheets (one sheet per client) and use buttons to navigate between sheets

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?

• Scatter plot: Measures X-axis Sales and Y-axis Margin, Dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales
• Scatter plot: Measures X-axis Sales and Y-axis Margin, Alternative dimensions Customer or Product category Funnel chart: Segments Stage, Width Sales
• Combo chart: Measures Sales and Margin, Dimensions Customer or Product category Pie chart: Dimension Stage, Measure Sales
• Distribution plot: Alternative measures Sales and Margin, Alternatives dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

In the 'Sales By Product' bar chart, a customer wants to highlight a specific product bar that includes a dynamic label. The label will only be visible when conditions are met. Which feature should the business analyst add to the bar chart?

• A Color By Expression property under Appearance
• A Dimension reference line add-on
• An Alternative dimension with a calculation
• A reference line add-on under Properties