PL-300 · Question #98
PL-300 Question #98: Real Exam Question with Answer & Explanation
Sign in or unlock PL-300 to reveal the answer and full explanation for question #98. The question stem and answer options stay visible for context.
Question
You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: - Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required. - Minimize the data model size. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- AGroup the impressions by Ad_id, Site_name, and Impression_date.
- BCreate one-to-many relationships between the tables.
- CCreate a calculated measure that aggregates by using the COUNTROWS function.
- DCreate a calculated table that contains Ad_id, Site_name, and Impression_date.
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.