Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 25 discussion

Actual exam question from Microsoft's DP-300

Question #: 25
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1.
You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.
You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1.
You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.
Solution: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️

by o2091 at Nov. 18, 2021, 1:08 a.m.

Comments

Submit Cancel

tesen_tolga

Highly Voted 3 years, 4 months ago

This is a DP-203 question.

upvoted 12 times

Sr18

11 months, 4 weeks ago

Its DP 203. Though answer will be NO. I got this question and passed with very very high score.

upvoted 1 times

...

CaptainJameson

Highly Voted 3 years, 4 months ago

Selected Answer: A

Yes, Get Metadata can be used to retrieve the DateTime of the files and allow you to use this data. The question is to add it to Table1, not to an external table.

upvoted 6 times

...

AntonioTest

Most Recent 3 months ago

Selected Answer: B

Agree with B, seems incomplete

upvoted 1 times

...

bingomutant

9 months ago

No - , retrieving the DateTime alone doesn't meet the goal unless the DateTime is also incorporated into the process that inserts the data into the table

upvoted 1 times

...

scottytohotty

1 year ago

Selected Answer: B

Agree with B, seems incomplete

upvoted 1 times

...

U_C

2 years, 2 months ago

Using a Get Metadata activity in an Azure Synapse Analytics pipeline to retrieve the DateTime of the files will not directly ensure that the DateTime is stored as an additional column in Table1. The Get Metadata activity only retrieves metadata information about the files, such as their names, size, and date created or modified. To achieve the goal of storing the DateTime as an additional column in Table1, you would need to use other pipeline activities, such as a Data Flow or a Copy activity, to extract data from the files, transform it as necessary, and load it into Table1. During this process, you could use derived columns or mappings to add the DateTime column and populate it with the appropriate values. Therefore, B is the correct answer.

upvoted 1 times

...

Ciupaz

2 years, 8 months ago

Exam DP-203: Data Engineering on Microsoft Azure

upvoted 1 times

...

Backy

3 years ago

Get Metadata activity retrieves the DateTime of the files but it does not create a column in Table1, so answer is B

upvoted 4 times

...

RehanRajput

3 years ago

Not sure if the answer is Yes. However, the explanation makes absolutely no sense. We want to load data into our SQL Pools, why would we load the data in our SQL serverless pools? :-/ Using metadata activity might be PART of a solution but in itself does not give a complete indication of what the solution should be.

upvoted 1 times

...

o2091

3 years, 7 months ago

Answer looks correct

upvoted 3 times

...