Winter Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

QSBA2024 Qlik Sense Business Analyst Certification Exam-2024 Questions and Answers

Questions 4

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?

Options:

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

Buy Now
Questions 5

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 sheets

• A KPI object that visualizes that the total amount of sales is used once

• A Treemap that shows margin by product group is used one time inside a Container

Which visualization should be added to the master items library?

Options:

A.

Container

B.

KPI

C.

Bar chart

D.

Treemap

Buy Now
Questions 6

A customer needs to demonstrate the value of sales for each month of the year with a rolling 3-month summary. Which visualization should the business analyst recommend to meet the customer's needs?

Options:

A.

Scatter plot

B.

Mekko chart

C.

Combo chart

D.

Pie chart

Buy Now
Questions 7

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?

Options:

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

Buy Now
Questions 8

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?

Options:

A.

Sankey chart

B.

Grid chart

C.

Org chart

D.

Network chart

Buy Now
Questions 9

Refer to the exhibit.

QSBA2024 Question 9

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?

Options:

A.

• Create RodentlD AS RodentID_Counter in the MazeEscapes table.

• Use Count (Distinct RodentlD Counter) as the KPI expression.

B.

• Create 1 AS RodentID_Counter in the Rodent table.

• Use Sum (RodentlD Counter) as the KPI expression.

C.

Create 1 AS RodentID_Counter in the MazeEscapes table.

Use Sum (RodentlD Counter) as the KPI expression.

D.

• Create RodentlD AS RodentlD Counter in the Rodent table.

• Use Count (Distinct RodentID Counter) as the KPI expression.

Buy Now
Questions 10

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?

Options:

A.

Storytelling

B.

Insight Advisor Chat

C.

Action Buttons

D.

Bookmarks

Buy Now
Questions 11

A customer is developing over 100 apps, each with several sheets that contain multiple visualizations and text objects. The customer wants to standardize all colors used every object across every app. The customer also needs to be able to change these colors quickly, as required.

Which steps should the business analyst take to make sure the color palette is easily maintained in every app?

Options:

A.

• Design all base objects as master visualizations

• Link each object in each app to the relevant master visualization

• Adjust the data properties as required

B.

• Develop the first app with every variation of object and visualization that will be required

• Duplicate this app to create every other app

• Remove the variations that are not required and adjust the ones needed

C.

• Create all color expressions as variables in a text file

• Load it in each app with an include statement

• Use these variables in the color property of all objects

D.

• Store color definitions within a .qvd file

• Have each app load this file as a data island in the model

•Have every object select its required color property from the rows within the data island

Buy Now
Questions 12

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?

Options:

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

Buy Now
Questions 13

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?

Options:

A.

Define a variable and use it in a variable input object on the sheet

B.

Create a calculated field in Data manager, using the Class() function

C.

Load an independent source file to contain the user-defined boundary values

D.

Create the price range dimension using the Buckets feature in Data manager

Buy Now
Questions 14

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?

Options:

A.

A Color By Expression property under Appearance

B.

A Dimension reference line add-on

C.

An Alternative dimension with a calculation

D.

A reference line add-on under Properties

Buy Now
Questions 15

Refer to the exhibit.

QSBA2024 Question 15

The users of a Qlik Sense app report slow performance. The app contains approximately 10 million rows of data. The business analyst notices the following KPI master measure definition:

Left{ Trim( TransactionName), 1 ) * Right ( TransactionName, 5) Which steps should the business analyst complete to improve app performance?

Options:

A.

Ask the developer of the underlying database to change the structure of the field TransactionName.

B.

• In the Data manager, use the Split function to split the field values with the underscore character as the separator.

• In the Data manager, use the Add calculated field function to multiply the 1st and the 3rd column of the split field.

• Reload the data.

C.

Change the master measure definition as follows:

subfield( TransactionName, '',!)* subfieldl TransactionName, ' ', 3)

D.

In the Data manager, use the Replace function to remove the middle part of the field TransactionName

Buy Now
Exam Code: QSBA2024
Exam Name: Qlik Sense Business Analyst Certification Exam-2024
Last Update: Dec 4, 2024
Questions: 50

PDF + Testing Engine

$66  $164.99

Testing Engine

$50  $124.99
buy now QSBA2024 testing engine

PDF (Q&A)

$42  $104.99
buy now QSBA2024 pdf