You have the tables shown in the following table (detailed in explanation below): 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. *(refer to diagram in explanation below)* Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Select one answer.
Marked answer: A
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
