Qlik Exam QSBA2024 Topic 4 Question 12 Discussion

Actual exam question for Qlik's QSBA2024 exam

Question #: 12
Topic #: 4

[All QSBA2024 Questions]

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

Show Suggested Answer

Suggested Answer: B

A box plot is the best visualization for displaying the distribution of salaries broken down by department with standard deviation indicators. Box plots show the spread of data, including key measures like quartiles, median, and outliers, which are useful for analyzing salary distributions. They also naturally incorporate standard deviation indicators through the spread of data.

Key Concepts:

Box Plot: This type of chart is designed for analyzing the distribution of data across different categories (in this case, departments). It shows the spread and variability of data, which can include standard deviations.

Why the Other Options Are Less Suitable:

A . Distribution plot: While a distribution plot can show spread, it's not as effective for showing standard deviation and is less suited for categorical breakdowns.

C . Histogram: A histogram shows the distribution of a single variable, but it doesn't provide the same detailed breakdown as a box plot.

D . Scatter plot: Scatter plots are used for showing relationships between two variables and are not suitable for showing standard deviation across departments.

References for Qlik Sense Business Analyst:

Box Plot for Distribution Analysis: Box plots are ideal for visualizing data distribution and variability across categories, making them the preferred choice for analyzing salary distribution by department.

Thus, the box plot is the best choice for visualizing salary distribution with standard deviation indicators, making B the verified answer.

by Idella at Mar 09, 2025, 01:59 AM

Limited Time Offer

25%

Off

Get Premium QSBA2024 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

1 months ago

Option D looks good too, but I'm not sure if relying on the system admin for the daily reload is the best approach. Better to automate that process.

upvoted 0 times

Bonita

7 days ago

True, but automating the daily reload task would be more efficient. We should consider that aspect as well.

upvoted 0 times

...

Herman

11 days ago

I agree, but option D also seems like a good option. We can apply a filter to extract data based on transaction year.

upvoted 0 times

...

Demetra

23 days ago

I think option B is the best choice. Using set analysis will help show data based on transaction year.

upvoted 0 times

...

2 months ago

I think option B is the best choice. Using set analysis will help show data based on transaction year.

upvoted 0 times

...