Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 94 discussion

Actual exam question from Microsoft's DP-203

Question #: 94
Topic #: 1

HOTSPOT
-

You have an Azure data factory named adf1 that contains a pipeline named ExecProduct. ExecProduct contains a data flow named Product.

The Product data flow contains the following transformations:

1. WeeklyData: A source that points to a CSV file in an Azure Data Lake Storage Gen2 account with 20 columns
2. ProductColumns: A select transformation that selects from WeeklyData six columns named ProductID, ProductDescr, ProductSubCategory, ProductCategory, ProductStatus, and ProductLastUpdated
3. ProductRows: An aggregate transformation
4. ProductList: A sink that outputs data to an Azure Synapse Analytics dedicated SQL pool

The Aggregate settings for ProductRows are configured as shown in the following exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by [deleted] at Aug. 9, 2023, 1:15 p.m.

Comments

Submit Cancel

aeab260

4 months, 2 weeks ago

Y,N,Y. Almost exactly same solution on Microsoft https://learn.microsoft.com/en-us/azure/data-factory/data-flow-aggregate#removing-duplicate-rows

upvoted 1 times

...

Aurangzaib

11 months, 2 weeks ago

No, No, Yes.

upvoted 2 times

...

Dusica

1 year, 2 months ago

Yes, No, Yes

upvoted 1 times

...

Alongi

1 year, 3 months ago

Yes, no, yes. You can take a look on https://learn.microsoft.com/en-us/azure/data-factory/data-flow-aggregate

upvoted 2 times

...

mariano2

1 year, 4 months ago

How come we might have multiple product description for unique product id if we group by product id ? It must be yes yes yes

upvoted 4 times

lola_mary5

1 year, 4 months ago

I also think it's yes, yes, yes. We're grouping by ProductID and select the first/max ProductDescr per ProductID, like so: select ProductID, first/max(ProductDescr) as FirstProductDescr from ProductColumns group by ProductID

upvoted 2 times

...

Bharatkumarc

1 year, 4 months ago

What if product id is duplicate i.e. for different combinations of the other columns we have the same product ID.. in that case, we will have multiple records for same product id even after aggregation and so answer to third Q would be No

upvoted 1 times

...

Charley92

1 year, 5 months ago

Yes / No / Yes

upvoted 1 times

...

Anto____

1 year, 5 months ago

YES. NO. YES

upvoted 2 times

...

be8a152

1 year, 5 months ago

No - Input Schema is same as output schema, since there is no derived column to hold the aggregate value ( Function "first" -returns the fist row among duplicate grouping key ie thge first unique row Product Id in this example ). Input Schema will be same as Output Schema as the aggregator in this case is only used for removing duplicate rows by Product Id No - Product Description is not a group by column, hence there is no guarantee it will be unique. Yes - Product Id is the grouping Key hence the out will only have 1 unique row per Product Id

upvoted 2 times

Dusica

1 year, 2 months ago

Your explanation is correct for the first but you misscounted the columns - there are 6; Y N Y

upvoted 1 times

7f668ce

1 year, 2 months ago

What about the column qualifier !=ProductID ? I think that makes it 5 in the return

upvoted 1 times

...

jongert

1 year, 6 months ago

1 - Yes, group by productId and then column pattern match the others results in 1 + 5 = 6 columns 2 - No, for aggregation using a group by clause we get one row for each unique value that we group by. 3 - Yes, the opposite compared to (2), since we are actually grouping by productId now.

upvoted 1 times

...

hcq31818

1 year, 7 months ago

1- Yes 2- No 3- Yes we are not creating new column, using aggregate function for deduplication https://learn.microsoft.com/en-us/azure/data-factory/data-flow-aggregate

upvoted 2 times

...

Tincox

1 year, 7 months ago

The syntax mentions name!= which means "not equal to" ProductID, so my answer would be: yes, yes, no

upvoted 1 times

Tincox

1 year, 6 months ago

Upon second glance my assumption was incorrect; the "first" pattern applies to all rows who's name is not ProductID. ProductID itself is the grouping column, so will return one output row for each unique value. ProductDescr., however, is part of the other columns so here it's the combination of these columns that has to be unique (first row of this combination of values is returned, the rest is dropped). The ProductDescr. column itself can generate more rows per unique value. So answer should be Yes, No, Yes.

upvoted 2 times

...

OldSchool

1 year, 9 months ago

1. No There will be 7 in output (6 are at input) 2. No We haven't tested anything by ProductDescr 3. Yes We have grouped by ProductID and added new column

upvoted 4 times

Vanq69

1 year, 9 months ago

Did we add a new column tho? $$ -> first($$) would just remove duplicate rows in ProductID and only keep the first value that is encountered. So it should be yes, no, yes. https://learn.microsoft.com/en-us/azure/data-factory/data-flow-aggregate

upvoted 3 times

...