ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 26 discussion

Actual exam question from Microsoft's PL-300
Question #: 26
Topic #: 2
[All PL-300 Questions]

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. Create one-to-many relationships between the tables.
  • B. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.
  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️
by sidyndiaye at Sept. 21, 2022, 12:30 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
sidyndiaye
Highly Voted 2 years, 7 months ago
I agree.
upvoted 26 times
...
RazaTheLegend
Highly Voted 2 years ago
Selected Answer: AB
AB is the correct 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. Therefore, the answer AB is correct!
upvoted 18 times
...
rcaliandro
Most Recent 8 months, 1 week ago
Selected Answer: AB
AB is the correct one
upvoted 2 times
...
Kiran37
9 months, 1 week ago
correct answer
upvoted 1 times
...
MoneyStacking
12 months ago
For the Guys and Girls, At this page, you will no longer find any free questions from Examtopics. However, if you're hesitant about purchasing Contributor Access, don't hesitate any longer; buy it. It costs only $50 and provides a significant boost to your CV and career. I recently passed with a score of 917 out of 1000. Save yourself time by learning and memorizing all these questions, as 85% of the 50 exam questions were identical to those provided here. Cheers and good luck!
upvoted 9 times
...
ab97776
1 year ago
Neither option a or d reduce model size but option a at least allows for proper data structure for accurate analysis -> option A the better of the two option C increases model size so hard no option b reduces model size , yay therefore answer is A and B
upvoted 2 times
...
Dsbuff
1 year, 4 months ago
Selected Answer: AB
Creating one-to-many relationships = optimizing the model. => A is correct. Group the Impressions query in Power Query = pre-summarizing the data which results in a smaller and more efficient data model => B is correct.
upvoted 5 times
...
fbbucky
1 year, 5 months ago
I feel like A and D should be the right answers given the fact that option B does not group by Campaign which is wrong. Any thoughts on this?
upvoted 4 times
ExamTopPicks
1 year, 2 months ago
...i also believe that D does not reduce the model size as stated in the requirements. you are keeping the same number of Impressions rows and just adding a DAX measure.
upvoted 1 times
...
ExamTopPicks
1 year, 2 months ago
A and B are correct, i believe. B is grouping the Impressions table, it does not have Campaign ID column. That column is in the Ads table, which remains unmodified in solution B.
upvoted 2 times
...
...
BI_life
1 year, 6 months ago
Guys, I feel like B and C are wrong. They didn't do anything with the campaign but we need to analyze the campaigns. Since D also work, I believe the answer should be A & D
upvoted 4 times
...
rainy_255
1 year, 6 months ago
This was in the exam this week.
upvoted 5 times
...
Igetmyrole
1 year, 7 months ago
B and C are the correct answers. B. This step will help us aggregate the impression data at the desired level of granularity (day, campaign, and site_name) in Power Query itself, reducing the amount of data loaded into the data model. C. By creating a calculated table that contains only the necessary columns (Ad_id, Site_name,and impression_date), we further minimize the data model size.
upvoted 1 times
AyoJose
1 year, 6 months ago
creating a calculated table will increase the data model size
upvoted 6 times
...
...
Pocu
1 year, 8 months ago
I would say AD is correct. Let us ignore the day and site_name and focus on the Ad vs Campaign. The reason is campaign to Ad is one to many relation thus one campaign can include some Ads. Assume campaignA(Campaign_ID=1) includes Ad1(Ad_id =1)&Ad2(Ad_id =2), RowsOfAD1 = Countrows(FILTER(Impressions, [Ad_id]=1)) RowsOfCampaign1 = Countrows(FILTER(Impressions, AND([Ad_id]=1,[Ad_id]=2))) They are different.
upvoted 4 times
...
tke44
1 year, 11 months ago
A and B for optimisation purpose. even if A and D is working
upvoted 7 times
...
Shalaleh
1 year, 12 months ago
Given answer is correct.
upvoted 2 times
...
ewelaela
2 years, 3 months ago
Selected Answer: AB
AB is correct
upvoted 4 times
...
yordiye
2 years, 3 months ago
It should be A & D we can created aggregation with COUNTROWS DAX and group by Campaign Name, Date & Site name . B is using wrong columns for calculations
upvoted 1 times
yordiye
2 years, 3 months ago
Sorry I am Wring it is A & B
upvoted 7 times
...
...
SumaiyaShah
2 years, 4 months ago
A is correct. I have a doubt about B. Aren't we suppose to group by campaign too? Grouping by AddID, we might have several campaigns against an add. Pls correct me if I am wrong
upvoted 5 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago