Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

Exam PL-300 Topic 1 Question 350 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 350
Topic #: 1
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.

Suggested Answer: B,C Vote an answer

Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size of the model.

by Herbert at Jun 07, 2026, 03:38 AM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.