You need to create ...
 
Notifications
Clear all

You need to create an ad analytics system to meet the following requirements:

1 Posts
1 Users
0 Likes
264 Views
(@pochethurman)
Noble Member
Joined: 2 years ago
Posts: 704
Topic starter  

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.

  • A . Group the impressions by Ad_id, Site_name, and Impression_date.
    Aggregate by using the CountRows function.
  • B . Create one-to-many relationships between the tables.
  • C . Create a calculated measure that aggregates by using the COUNTROWS function.
  • D . Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Show Answer Hide Answer

Suggested Answer: B,C

   
Quote

Latest Microsoft PL-300 Dumps Valid Version

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Share: