QSBA2024 Qlik Sense Business Analyst Certification Exam Free Dumps

1. 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?

2. 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

3. A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of data.

The requirements include:

• Users need to drill down to various details within the available data set.

• Several final measures will be repeatedly used. These final measures require combining several fields in a single table.

• User experience and load time is a high priority.

Which action should the business analyst take to meet these requirements?

A. Aggregate the data to the source period

B. Develop a master item using the required source fields

C. Combine the various source fields in a calculated item in the Data manager

D. Combine the source fields and create additional fields in Excel

4. A project management team uses an app to monitor different projects.

• Projects may have co-dependent tasks and processes

• Some projects include subtasks

The business analyst needs to use a diagram similar to a workflow with the processes and the sub tasks represented as boxes with lines to relate them to each other. The color of the boxes could also be determined by the status of each project or task.

Which visualization should be used?

A. Sankey chart

B. Grid chart

C. Org chart

D. Network chart

5. 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

6. 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?

7. The VP of Finance is requesting a presentable solution that allows them to share finance information in monthly meetings with C-suite executives. Given the monthly meeting agendas, the solution must be customizable.

Which Qlik Sense feature should be implemented to meet this requirement?

8. Refer to the exhibit.





An app that will track experiments for rodents (e.g., rats and mice) that navigate mazes (labyrinths) is being developed. Individual rodents are catalogued in the Rodent table, while the Mazes table has metadata for the mazes. The MazeEscapes table holds a record of each attempt at a maze by a rodent. A business analyst needs to build a KPI that will allow users to see how many rodents have made at least one attempt at any maze.

How should the analyst construct the KPI?

9. 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?

10. The VP of Sales asks a business analyst to include a KPI object on the sales dashboard that shows total sales value for the year 2022, regardless of selections. Existing fields in the data model include Sales and Year.

How should the business analyst write the measure for the KPI object?

A. Sum ({ < year="|" '2022,="" }="" /> } Sales)

B. Sum ({ $ < year="{" '2022*="" )="" /> } Sales)

C. Sum ({ 1 < year="{" '2022'="" )="M /> ) Sales)

D. Sum (1 { < year="(" '2022'="" )="" /> ) Sales)

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?

12. 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

13. 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

14. 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

15. A business analyst needs to rapidly prototype an application design for a prospective customer. The only dataset provided by the customer contains 30 fields, but has over one billion rows. It will take too long to keep loading in its entirety while the analyst develops the data model.

Which action should the business analyst complete in the Data manager?

A. Split the dataset and create a normalized star schema of associated tables

B. Deselect text columns with unique data values to reduce the memory footprint

C. Use the Filter data option to reduce the number of rows

D. Truncate text fields longer than 256 characters to create preview fields