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

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 1 question 94 discussion

Actual exam question from Microsoft's DP-203
Question #: 94
Topic #: 1
[All DP-203 Questions]

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 Hide Answer
Suggested Answer:
by [deleted] at Aug. 9, 2023, 1:15 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
[Removed]
Highly Voted 1 year, 8 months ago
Yes , no, yes - https://learn.microsoft.com/en-us/azure/data-factory/data-flow-aggregate
upvoted 26 times
...
[Removed]
Highly Voted 1 year, 8 months ago
How can one know that the answer to the third question is either yes or no? In my understanding, you'd have to assume that there is no duplicates in the source table, i.e. there are no rows that share the same values in all columns except for productid
upvoted 5 times
...
aeab260
Most Recent 2 months 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
8 months, 3 weeks ago
No, No, Yes.
upvoted 2 times
...
Dusica
11 months, 3 weeks ago
Yes, No, Yes
upvoted 1 times
...
Alongi
1 year 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, 2 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, 2 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, 2 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, 2 months ago
Yes / No / Yes
upvoted 1 times
...
Anto____
1 year, 2 months ago
YES. NO. YES
upvoted 2 times
...
be8a152
1 year, 2 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
11 months, 4 weeks ago
Your explanation is correct for the first but you misscounted the columns - there are 6; Y N Y
upvoted 1 times
7f668ce
11 months, 3 weeks ago
What about the column qualifier !=ProductID ? I think that makes it 5 in the return
upvoted 1 times
...
...
...
jongert
1 year, 3 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, 4 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, 4 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, 4 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, 6 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, 6 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
...
...
kkk5566
1 year, 7 months ago
yes, no, yes
upvoted 4 times
...
kkk5566
1 year, 7 months ago
Yes , no, yes
upvoted 3 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