Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
Remove the column and split. Answers are correct. The purpose of the related report is to recognize weekly sales so removing Customer ID wouldn't impact the report, but you do need Order ID to recognize the revenue in the right period, which leads to second part, you only need dates to recognize the sales in the appropriate week, I would split the Date column then delete the time column
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
I would say : 1- Remove the column Customer 2- Split to keep only days
* Answer: - CustomerID: Remove the column (It’s not needed for weekly sales per region and removing it reduces model size.) - PurchaseDateTime: Split the column into separate date and time columns (This allows you to keep only the date for weekly aggregation and discard unnecessary time details, reducing cardinality and size.)
just a short explanation on the answer: to minimize data size you should remove unnecessary columns, since you don't need customer id it is removed storing datetime timezone data type data takes more storage space than splitting it into 2 components and storing it as date and time.