Discuss Qlik QSBA2024 Exam Topic 4 Question 12

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

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.

Get Premium QSBA2024 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

32 comments · newest first

Val 10 months ago

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

Sherman 10 months ago

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

Murray 10 months ago

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

Theodora 10 months ago

Totally agree, set analysis is key for performance!

Gretchen 11 months ago

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

Olive 11 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.

Kimbery 11 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.

Annabelle 11 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.

Aretha 11 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.

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

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

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

Alida 1 year 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.

Kerry 1 year ago

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

Pa 1 year 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*

Jutta 1 year ago

↳ replying to Pa

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

Alba 1 year ago

↳ replying to Pa

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

Tori 1 year ago

↳ replying to Pa

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

Lorean 1 year 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.

Matilda 1 year 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.

Bonita 1 year ago

↳ replying to Matilda

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

Herman 1 year ago

↳ replying to Matilda

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

Demetra 1 year ago

↳ replying to Matilda

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

Tresa 1 year 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.

Ludivina 1 year ago

↳ replying to Tresa

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

Angelo 1 year ago

↳ replying to Tresa

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

Genevive 1 year ago

↳ replying to Tresa

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

Simona 1 year ago

↳ replying to Tresa

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

Tijuana 1 year 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.

Willodean 2 years ago

I'm not sure, but option D also seems reasonable. Applying a filter to extract data based on transaction year can be effective.

Dwight 2 years ago

I agree with Bulah. Also, using an API for daily reload task seems like a good idea.

Bulah 2 years ago

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

Qlik QSBA2024 Exam - Topic 4 Question 12 Discussion