exam questions

Exam QSDA2024 All Questions

View all questions & answers for the QSDA2024 exam

Exam QSDA2024 topic 1 question 16 discussion

Actual exam question from QlikView's QSDA2024
Question #: 16
Topic #: 1
[All QSDA2024 Questions]

Refer to the exhibit.

A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by.
There is only one Sales Person in each Region and only one Region per Customer.
Which data model is the most optimal for use in this situation?

  • A.
  • B.
  • C.
  • D.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Jdossa91
2 weeks, 5 days ago
Selected Answer: B
Fact_Gross_Sales est la table centrale dans ce modèle, avec les informations principales sur les ventes (comme les montants des factures et les identifiants des clients et des articles). Dim_Customer relie chaque vente à un client spécifique via le champ CustomerID. Cette table contient également RegionID, qui est utilisé pour relier cette table à la table Dim_Region. Dim_Region contient les informations sur les régions et fait le lien avec Dim_SalesOrg, qui contient les informations sur les vendeurs via le champ SalesID. Dim_Item fournit des informations sur les articles vendus et est reliée à la table des faits via ItemID.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago