You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table 1.

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table 1.

You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container 1.

You plan to insert data from the files into Table1 and azure Data Lake Storage Gen2 container named container 1.

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 Table 1.

You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table 1.

Solution: In an Azure Synapse Analytics pipeline, you use a data flow that contains a Derived Column transformation.
A . Yes
B . No

Answer: A

Explanation:

Use the derived column transformation to generate new columns in your data flow or to modify existing fields.

Reference: https://docs.microsoft.com/en-us/azure/data-factory/data-flow-derived-column

Latest DP-203 Dumps Valid Version with 116 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments