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. 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.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.