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

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 1 question 2 discussion

Actual exam question from Microsoft's DA-100
Question #: 2
Topic #: 1
[All DA-100 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. 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 Suggested Answer Hide Answer
Suggested Answer: AB 🗳️
by Rahhal at Oct. 6, 2020, 9:54 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
ying1234
Highly Voted 4 years, 6 months ago
A and B. answer is correct. less line will get input.
upvoted 78 times
idavidmei
4 years, 6 months ago
It cannot be A and B. Group by will reduce the Power Query table into two columns, which means you would have to duplicate tables in order to get the desired results. You can use a calculate function - Calculate(Sum(Ad_Impressions), GROUPYBY(Table, Column))
upvoted 6 times
ocelot911
4 years, 6 months ago
that will not reduce the data model. Remember Aggregating data prior to the data model is key
upvoted 3 times
saidMS
4 years, 4 months ago
So how do you think B and C will Minimize the data model size ?
upvoted 1 times
fspellet
4 years ago
It's in the question, "Which two actions should you perform?"
upvoted 1 times
...
...
prabhjot
3 years, 11 months ago
Ans is A & B- @ocelot911 you need to do analytics by joining 2 tables, plus reduce the data model size ( every month 30 million records they collect in impression table)
upvoted 1 times
...
...
...
TechDiva
3 years, 1 month ago
Got in Exam 3/17/2022.
upvoted 2 times
...
...
CDL
Highly Voted 4 years, 5 months ago
Tested, A+B for A, just reduce the Table size in PQ editor. https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#group-by-and-summarize
upvoted 21 times
ZVV
4 years, 4 months ago
Why we need B? Why not just A?
upvoted 1 times
fspellet
4 years ago
It's stated in the question there needs to be two choices, "Which two actions should you perform?"
upvoted 3 times
...
mullered
4 years ago
You have the three tables. They need to relate to each other else the values will be meaningless.
upvoted 2 times
...
...
...
pippo101
Most Recent 2 years, 8 months ago
The way A is written is weird. The questions asks you to group by CAMPAIGN, which is a higher level of granularity, not by ad. In answer A you don't group by campaign, so you lose this information. It makes me question whether it's AB or BC
upvoted 2 times
...
Haughty
2 years, 8 months ago
Why not C?
upvoted 2 times
...
Nurgul
2 years, 9 months ago
Selected Answer: AB
Grouping the impressions table by columns and aggretating by counting rows will reduce the size of the model. Using one-to-may relations will create a relation between tables in a model
upvoted 1 times
...
Fran9415
2 years, 9 months ago
Selected Answer: AB
Estas son las correctas, la B es necesaria porque la información solicitada se encuentra entre dos tablas que no tienen relación y se deben relacionar para obtenerla.
upvoted 1 times
...
vineyvinni
3 years ago
Selected Answer: AB
Both A&B Are correct
upvoted 2 times
...
Shiva1984
3 years, 1 month ago
A and B
upvoted 2 times
...
Jenny321
3 years, 1 month ago
Selected Answer: AB
Got this question on my exam (passed with 880) answered AB
upvoted 2 times
...
Topodhir
3 years, 1 month ago
Selected Answer: AB
A + B are correct
upvoted 2 times
...
PrudenceK
3 years, 2 months ago
On exam 03/01/2022. I answered AB.
upvoted 1 times
...
Ankit_da
3 years, 2 months ago
This question not in my test : 24/02/2022
upvoted 1 times
...
ddams
3 years, 2 months ago
Selected Answer: AB
A and B. answer is correct
upvoted 1 times
...
Joaquim_Ti_Smart
3 years, 2 months ago
Resposta A
upvoted 1 times
...
veenanair
3 years, 2 months ago
A & B is correct
upvoted 1 times
...
futelio
3 years, 3 months ago
Selected Answer: AB
A and B. answer is correct
upvoted 1 times
...
Abood110
3 years, 4 months ago
Selected Answer: AB
Selected
upvoted 1 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