DP-203 Certification Practice Question #94

Question

You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool.

You run the following query in the pool.

SELECT *
FROM OPENROWSET(BULK 'https://mydatalake.blob.core.windows.net/data/**',
FORMAT = 'CSV') AS datarows;

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Accepted Answer

In serverless SQL, `OPENROWSET(... ) AS datarows` names the returned rowset; it does not create a physical table. Microsoft Learn also states that appending `/**` tells serverless SQL pool to traverse subfolders recursively, so files directly in `/data/` and files under `/data/folder1/` are both matched by the bulk path. Therefore the three statements evaluate to No, Yes, and Yes.

More DP-203 practice questions