PL-300 · Question #107
PL-300 Question #107: Real Exam Question with Answer & Explanation
Sign in or unlock PL-300 to reveal the answer and full explanation for question #107. The question stem and answer options stay visible for context.
Question
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?
Options
- AUse the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
- BDuplicate the Date query in Power Query and use active relationships between both Date tables.
- COn the Date table, use a reference query in Power Query and create active relationships between
- DCreate an active relationship between Sales and Date for the purchase date and an inactive
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.