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

Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 1

© examsnet.com

Question : 23

Total: 39

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?

Yes
No

Go to Question:

Prev Question

Next Question

More Free Exams: