DP-300 Certification Practice Question #10

Question

You are building a database in an Azure Synapse Analytics serverless SQL pool.
You have data stored in Parquet files in an Azure Data Lake Storage Gen2 container.
Records are structured as shown in the following sample.

The records contain two applicants at most.
You need to build a table that includes only the address fields.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To build a queryable schema on top of Parquet files in Azure Data Lake Storage Gen2 within a Synapse serverless SQL pool, you must create an external table using the Create External Table As Select (CETAS) pattern. The syntax `CREATE EXTERNAL TABLE ... WITH (...)` defines the location and format settings of the external table. The data is retrieved by querying the source files using the `OPENROWSET` function with the `BULK` option configured for the Parquet format.

More DP-300 practice questions