QSBA2024 Practice Exam Questions and Answers

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 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 business analyst is working with retail data for consumer products. The customer is interested in the following:

• Ability to look for outliers on sales volume and margin %

• Ability to understand the clustering of products visually

• Ability to see products that are above the median sales volume

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

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 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 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 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 company director who spends very little time in applications needs to be informed when a threshold is breached. Which feature should the business analyst use?

The CEO has requested a dashboard that tracks the company's performance. The main requirements for the dashboard:

• Minimal number of visualizations or objects

• Display multiple key measures

• Ability to easily navigate to other sheets

Which features would meet the requirements?

A business analyst receives multiple requests for a variety of different filter panes to be placed on a dashboard. Users need to filter on many different values across different fields.

Which Qlik Sense feature do the users need to learn about to meet their needs?