Free Preparation Discussions
MENU
Qlik Exam QSDA2024 Topic 3 Question 11 Discussion
Topic #: 3
Exhibit.
Refer to the exhibit.
The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales.
During loading, the data architect resolves a synthetic key by creating the composite key.
For validation, the data architect creates a table that contains Customer, Month, Sales, and Budget columns.
What will the data architect see when selecting a month?
In the scenario where the data model is built with a composite key (keyYearMonthCustNo) to resolve synthetic keys, the following outcomes occur:
Sales and Budget Data Integration:
The composite key ensures that each combination of Year, Month, and Customer is uniquely represented in the combined Sales and Budget data.
During data selection (e.g., when a specific month is selected), Qlik Sense will show all the customer names that have either Sales or Budget data associated with that month.
Resulting Data View:
For the selected month, customers with sales records will display their Sales data. However, if the corresponding Budget data is missing, the Budget column will contain null values.
Similarly, if a customer has a Budget but no Sales data for the selected month, the Sales column will show null values.
Validation Outcome: When the data architect selects a month, they will see the following:
Customer Names and Sales records for the selected month, where the Sales column will have values and the Budget column may contain null or non-null values depending on the data availability.
Laurena
24 days agoTyisha
6 days agoMelodie
29 days agoJimmie
1 months agoSheron
10 days agoJulieta
20 days agoEllen
23 days agoElmira
1 months agoKristian
6 days agoShawn
23 days agoSanda
29 days agoOren
1 months agoNichelle
2 months agoMerilyn
2 months ago