Qlik QSBA2024 Exam - 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

Val

2 months ago

I’m not sure about using an API for the reload. Isn’t that overkill?

upvoted 0 times

...

Sherman

2 months ago

Option D looks good too, especially with the filter for transaction year.

upvoted 0 times

...

Murray

2 months ago

I think option B makes the most sense for daily updates.

upvoted 0 times

...

Theodora

3 months ago

Totally agree, set analysis is key for performance!

upvoted 0 times

...

Gretchen

3 months ago

Wait, why are we deleting cardholder info? Seems risky.

upvoted 0 times

...

Olive

3 months ago

I think requesting a daily reload from the system admin is important, but I’m not clear on whether we should delete or just deselect the time fields.

upvoted 0 times

...

Kimbery

3 months ago

I feel like using set analysis could help with performance, but I’m a bit confused about how it interacts with the daily reload task.

upvoted 0 times

...

Annabelle

4 months ago

I remember a similar question where we had to limit data visibility. Using a filter pane sounds familiar, but I can't recall if it was the best option here.

upvoted 0 times

...

Aretha

4 months ago

I think we need to remove the cardholder info to comply with privacy requirements, but I'm not sure if we should delete or just deselect the fields.

upvoted 0 times

...

Jean

4 months ago

This is a tricky one, but I think I've got it. Deselecting the sensitive fields, using a filter pane, and setting up a daily reload should do the trick. Option D looks like the winner to me.

upvoted 0 times

...

Salena

4 months ago

I'm a little confused by the different options. Can we go through them step-by-step? I want to make sure I understand the best approach before answering.

upvoted 0 times

...

Cristy

4 months ago

Okay, let's think this through. We need to optimize the data for the past 2 years, remove sensitive cardholder info, and set up a daily refresh. I think option C looks like the way to go.

upvoted 0 times

...

Alida

5 months ago

Hmm, I'm a bit unsure about the best approach here. Deleting fields and using filters seems like a good start, but I'm not sure about the daily reload part.

upvoted 0 times

...

Kerry

5 months ago

This looks like a straightforward data management question. I think I can handle this one.

upvoted 0 times

...

Pa

9 months ago

Wait, they want to create an app based on 10 years of data, but only show the past 2 years? Sounds like someone's trying to hide something... *wink wink*

upvoted 0 times

Jutta

8 months ago

C: I agree, it's important to follow the requirements and ensure the data is updated daily without showing sensitive information.

upvoted 0 times

...

Alba

8 months ago

B: Yeah, that way users can only see the data from the past 2 years and the app performance will be improved.

upvoted 0 times

...

Tori

9 months ago

A: Option D seems like the best choice to filter the data based on the transaction year and request a daily reload task.

upvoted 0 times

...

Lorean

10 months ago

Option A is a bit too simple. Relying solely on the reload function in the sheet Editor asset panel might not be enough to handle the daily updates.

upvoted 0 times

...

Matilda

10 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

9 months ago

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

upvoted 0 times

...

Herman

9 months 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

9 months ago

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

upvoted 0 times

...

Tresa

10 months ago

I agree, Option B is the way to go. Deleting the cardholder and time fields, along with the daily reload, will keep the app running smoothly and maintain data privacy.

upvoted 0 times

Ludivina

9 months ago

User 4: I agree, Option B seems like the most efficient choice for improving app performance.

upvoted 0 times

...

Angelo

9 months ago

User 3: The daily reload with an API is a smart move for keeping data up to date.

upvoted 0 times

...

Genevive

10 months ago

User 2: Yeah, deleting the sensitive info and using set analysis is key.

upvoted 0 times

...

Simona

10 months ago

User 1: Option B sounds good. It covers all the requirements.

upvoted 0 times

...

Tijuana

10 months ago

Option B seems the most comprehensive solution. Using set analysis and an API to perform a daily reload task would optimize the app's performance while ensuring the users only see data from the past 2 years.

upvoted 0 times

...