DP-300 Certification Practice Question #15

Question

You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.
You execute the Transact-SQL query shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Hot Area:

Accepted Answer

The query path `csv/busfare/tripdata_2020*.csv` contains a wildcard `*` after `tripdata_2020` and ends with the `.csv` file extension, meaning it matches only CSV files whose names begin with "tripdata_2020". Furthermore, the option `FIRSTROW = 2` is used in the `OPENROWSET` command to skip the first line of the CSV files, which is assumed to contain the column headers (Option "a header"), starting the data import from the second row instead.

More DP-300 practice questions