Câu 102: PL-300: Microsoft Power BI Data Analyst
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. M…
Nội dung câu hỏi
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.
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Create one-to-many relationships between the tables. — đáp án hiện tại
- B. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function. — đáp án hiện tại
- C. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
- D. Create a calculated measure that aggregates by using the COUNTROWS function.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.