DP-203 Certification Practice Question #45

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 Storege Gen2 container.
Records are structured as shown in the following sample.
{
"id": 123,
"address_housenumber": "19c",
"address_line": "Memory Lane",
"applicant1_name": "Jane",
"applicant2_name": "Dev"
}
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

The code shape in the exhibit is a CTAS-style external-object pattern over parquet files in serverless SQL. The `FROM ... (BULK ... FORMAT='PARQUET') AS [r]` syntax clearly points to `OPENROWSET`, and because the data lives in ADLS Gen2 for serverless querying, the object being created is an external table, not a regular internal table. The address fields are then selected out of the parquet recordset.

More DP-203 practice questions