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

View Answer

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