DP-203 Mid-Assessment

1. 1. Azure Data Lake Storage Gen2 stores data in…

• A document database hosted in Azure Cosmos DB.

• A relational data warehouse hosted in Azure Synapse Analytics.

• An HDFS-compatible file system hosted in Azure Storage.

2. 2. What option must you enable to use Azure Data Lake Storage Gen2?

• Global replication

• Data encryption

• Hierarchical namespace

3. Which feature of Azure Synapse Analytics enables you to transfer data from one store to another and apply transformations to the data at scheduled intervals?

• Serverless SQL pool

• Apache Spark pool

• Pipelines

2. 4. You want to create a data warehouse in Azure Synapse Analytics in which the data is stored and queried in a relational data store. What kind of pool should you create?

• Serverless SQL pool

• Dedicated SQL pool

• Apache Spark pool

5. 5. A data analyst wants to analyze data by using Python code combined with text descriptions of the insights gained from the analysis. What should they use to perform the analysis?

• A notebook connected to an Apache Spark pool.

• A SQL script connected to a serverless SQL pool.

• A KQL script connected to a Data Explorer pool.

6. 6. What function is used to read the data in files stored in a data lake?

• FORMAT

• OPENROWSET

• ROWSET

7. 7. What character in file path can be used to select all the file/folders that match rest of the path?

• &

• *

• /

8. 8. Which external database object encapsulates the connection information to a file location in a data lake store?

• FILE FORMAT

• DATA SOURCE

• EXTERNAL TABLE

9. 9. You need to store the results of a query in a serverless SQL pool as files in a data lake. Which SQL statement should you use?

• BULK INSERT

• CREATE EXTERNAL TABLE AS SELECT

• COPY

10. 10. Which of the following file formats can you use to persist the results of a query?

• CSV only

• Parquet only.

• CSV and Parquet.