Exam DP-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 25

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?

    Correct Answer: B

    Using a Get Metadata activity in an Azure Synapse Analytics pipeline helps in retrieving metadata information about files, such as their names, size, and creation or modification dates. However, this activity alone does not ensure that the DateTime is stored as an additional column in Table1. To fully achieve the requirement, additional steps would be necessary, such as using a Data Flow or a Copy activity to process the data and include the DateTime as a new column when inserting the data into Table1. Thus, the solution described does not meet the goal.

Discussion
tesen_tolga

This is a DP-203 question.

Sr18

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

CaptainJamesonOption: 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.

BackyOption: B

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

o2091Option: A

Answer looks correct

scottytohottyOption: B

Agree with B, seems incomplete

U_COption: B

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.

Ciupaz

Exam DP-203: Data Engineering on Microsoft Azure

RehanRajputOption: B

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.