Data Engineering on Microsoft Azure DP-203 Practice Test 1

© examsnet.com

Question : 8 of 20

Marks: +1, -0

You use Azure Data Factory to prepare data to be queried by Azure Synapse Analytics serverless SQL pools.

Files are initially ingested into an Azure Data Lake Storage Gen2 account as 10 small JSON files. Each file contains the same data attributes and data from a subsidiary of your company.

You need to move the files to a different folder and transform the data to meet the following requirements:

⇒ Provide the fastest possible query times.

⇒ Automatically infer the schema from the underlying files.

How should you configure the Data Factory copy activity? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Copy behaviour ______
Flatten hierarchy
Merge files
Perserve hierarchy
Sink file type ______
CSV
JSON
Parquet
TXT

Go to Question:

Advertisements