Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 1 question 2 discussion

Actual exam question from Microsoft's DA-100

Question #: 2
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.

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

Suggested Answer: AB 🗳️

by Rahhal at Oct. 6, 2020, 9:54 p.m.

Comments

Submit Cancel

ying1234

Highly Voted 4 years, 9 months ago

A and B. answer is correct. less line will get input.

upvoted 78 times

idavidmei

4 years, 9 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, 9 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, 7 months ago

So how do you think B and C will Minimize the data model size ?

upvoted 1 times

fspellet

4 years, 4 months ago

It's in the question, "Which two actions should you perform?"

upvoted 1 times

...

prabhjot

4 years, 2 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, 4 months ago

Got in Exam 3/17/2022.

upvoted 2 times

...

CDL

Highly Voted 4 years, 8 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, 8 months ago

Why we need B? Why not just A?

upvoted 1 times

fspellet

4 years, 4 months 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, 3 months 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, 11 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, 12 months ago

Why not C?

upvoted 2 times

...

Nurgul

3 years 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

3 years, 1 month 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

...