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
2 months agoDortha
1 months agoArlette
1 months agoGretchen
1 months agoTyisha
1 months agoMelodie
2 months agoJimmie
2 months agoSheron
2 months agoJulieta
2 months agoEllen
2 months agoElmira
3 months agoKristian
1 months agoShawn
2 months agoSanda
2 months agoOren
3 months agoNichelle
3 months agoMerilyn
3 months ago