Qlik Exam QSDA2021 Topic 4 Question 29 Discussion

Actual exam question for Qlik's QSDA2021 exam

Question #: 29
Topic #: 4

[All QSDA2021 Questions]

Refer to the exhibit.

Refer to the exhibits.

An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.

How should the data architect modify the data model to correct this issue?

ACreate a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

BCreate a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

CJoin the Departments and Salespeople tables to resolve the many-to-many relationship

DJoin the Transactions and Salespeople tables to resolve the many-to-many relationship

Show Suggested Answer

Suggested Answer: D

by Craig at May 22, 2024, 01:02 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jody

1 years ago

This is a tough one, but I think I'm going to go with Option D. I mean, who doesn't love a good 'ORDER BY' clause, am I right? It's like the pineapple on the pizza of SQL queries.

upvoted 0 times

Alisha

11 months ago

I think Option C might be a better choice. It's always good to consider all the options before making a decision.

upvoted 0 times

...

Sage

12 months ago

I agree, Option D seems like the way to go. 'ORDER BY' is essential for sorting data.

upvoted 0 times

...

Glory

12 months ago

Yeah, 'ORDER BY' is definitely a game-changer in sorting data.

upvoted 0 times

...

Rolf

12 months ago

I agree, Option D seems like the way to go.

upvoted 0 times

...

Rebecka

1 years ago

I'm going with Option A. It's the only one that has the word 'sort' in it, so it must be the correct answer. Plus, it's the shortest, and we all know the right answer is always the shortest one.

upvoted 0 times

...

Bernardo

1 years ago

Hmm, Option B has 'IMPORT DATA' and 'SORT BY', so that might be the answer. Unless the data architect is a philosopher trying to trick us, then it's definitely Option C.

upvoted 0 times