Exam DP-203 All QuestionsBrowse all questions from this exam
Go to Exam
Question 176

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 in container1 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?

    Correct Answer: B

    Using a Get Metadata activity in an Azure Synapse Analytics pipeline to retrieve the DateTime of the files does not directly meet the goal of storing the DateTime as an additional column in Table1. The Get Metadata activity can retrieve metadata attributes such as the file's created datetime, but it does not cover the entire process necessary to insert this metadata as a new column in the destination table. This requires additional steps beyond just retrieving the metadata, such as transforming the data to include the DateTime before loading it into Table1. Therefore, this solution by itself is insufficient to achieve the stated goal.

Discussion
juanlu46Option: B

Is part of a posible solution, but it isn't sufficient to meet the goal, yo need to pass the "Get metadata"'s output as a parameter to the ingest process, processing each file inside a "for" loop, for example. https://docs.microsoft.com/en-us/azure/data-factory/control-flow-get-metadata-activity

oldponyOption: A

https://docs.microsoft.com/en-us/azure/data-factory/control-flow-get-metadata-activity points that Get Metadata activity can retrieve the corresponding Matadata type of: Created datetime of the file or folder.

esaadeOption: B

No, using a Get Metadata activity in an Azure Synapse Analytics pipeline to retrieve the DateTime of the files does not meet the goal of storing the DateTime as an additional column in Table1. The Get Metadata activity retrieves metadata about the files, such as file size, file name, or last modified date, but it does not provide the file content needed to extract the DateTime value and store it as an additional column in Table1. To achieve the goal, you need to use a data flow in the pipeline that loads the data from container1, extracts the DateTime value, and transforms the data by adding the DateTime column to Table1.

vctrhugoOption: B

According to ChatGPT: B. No The proposed solution of using a Get Metadata activity in an Azure Synapse Analytics pipeline will retrieve the DateTime of the files, but it does not address the requirement of storing the DateTime as an additional column in Table1.

Qordata

chatGpt is not to be trusted at all.

rlnd2000

But in this case is right :)

MvanGOption: B

It seems rather odd that in the same two previous questions "Use the derived column transformation to generate new columns in your data flow or to modify existing fields." was the answer. This is very confusing. Reference: https://docs.microsoft.com/en-us/azure/data-factory/data-flow-derived-column

OldSchoolOption: A

If DateTime is part of data in files in container1 than answer is A, but if it is not part of data in files but only Meta data of files then B. Wording in question is really strange but I think it is A because it says "data from files in container1"

Deeksha1234Option: B

Its confusing, if we need to insert the dateTime of insertion then answer should be No, but if we need to insert the datetime of file modified then answer should be yes. To me looks like the question is about 1st case so the answer should be No

Dusica

AGREED

StrixOption: B

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables

g2000Option: A

Get Metadata seems possible https://www.mssqltips.com/sqlservertip/6246/azure-data-factory-get-metadata-example/

learnwellOption: B

This is my take on the answer. The question clearly states that "You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1." Here the focus should be on the term "additional column" which helps us understand that the datetime column does not already exist in the files in container1. Now what is Get Metadata activity? As per documentation link https://learn.microsoft.com/en-us/azure/data-factory/control-flow-get-metadata-activity "You can use the Get Metadata activity to retrieve the metadata of any data in Azure Data Factory or a Synapse pipeline". This will work only if the underlying data files contains the DateTime column which is not the case here. Hence to add an additional column to Table1 in Synapse, Get Metadata activity won't be of help and we have to derive the column through data flow transformation which is the result for Question 59.

mghf61Option: A

The Get Metadata activity in Azure Synapse Analytics pipeline can retrieve the metadata of any data, including the DateTime of the files. So Answer is Yes

jpgsa11

yes but it won't map as a column

kkk5566Option: B

nonono

Ram9198Option: B

Does not meet the goal

Davico93

I'm confusing more every time a read the solution, I don't know if it says that you have to do it in two setps, that changes everything