Qlik Exam QSDA2022 Topic 5 Question 21 Discussion

Actual exam question for Qlik's QSDA2022 exam

Question #: 21
Topic #: 5

[All QSDA2022 Questions]

Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure. Count<{})>} Customer ID)

Which option shows the resulting table after the expression is applied?

AOption A

BOption B

COption C

DOption D

Show Suggested Answer

Suggested Answer: A

by Malcolm at Apr 14, 2024, 04:51 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Nikita

1 years ago

I'm not sure about the options, but I think adding the region to the data model is crucial for better analysis and reporting.

upvoted 0 times

...

Sherill

1 years ago

I disagree, I believe option D) Create a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table is the better choice.

upvoted 0 times

...

Chun

1 years ago

I think the data architect should use option A) Create a Region field in the SalesTransaction table and populate using fixed region values while loading from each source.

upvoted 0 times

...

Aileen

1 years ago

Oh, come on, you can't be serious! Manual data entry? That's a recipe for disaster. I'd go with option D, no question. It's the most future-proof solution.

upvoted 0 times

...

Nada

1 years ago

You guys are really overthinking this, aren't you? I say we just go with option A and call it a day. How hard can it be to manually enter the region values? *chuckles*

upvoted 0 times

...

Odelia

1 years ago

Hmm, I'm not sure about option B or C. Trying to extract the region from the EmployeeID seems a bit hacky to me. I'd rather keep the employee data separate from the sales transaction data if possible.

upvoted 0 times

Alfreda

1 years ago

I also prefer option A, it seems cleaner and easier to manage.

upvoted 0 times

...

Ma

1 years ago

I think option A makes more sense, creating a Region field in the SalesTransaction table with fixed region values.

upvoted 0 times

...

Alethea

1 years ago

I agree, keeping the employee data separate makes more sense.

upvoted 0 times

...

Lemuel

1 years ago

Option A is tempting, as it's the most straightforward. But I worry about the potential for errors if the region values are hardcoded. What if a new region is added down the line?

upvoted 0 times

...

Sherell

1 years ago

I agree, the question seems a bit open-ended. I'm leaning towards option D, as it seems like the most robust solution. Creating a mapping table based on the Country field in the Customer table seems like a good way to handle the region assignment.

upvoted 0 times

...

Yong

1 years ago

This is a tricky one. I'm not sure how I feel about the region being added to the data model. It seems like there could be multiple ways to approach this problem.

upvoted 0 times

...