Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 1

© examsnet.com

Question : 33 of 39

Marks: +1, -0

HOTSPOT
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.
SELECT
payment_type,
SUM (fare_amount) AS fare_total
FROM OPENROWSET (
BULK 'csv/busfare/tripdata_2020*.csv',
DATA_SOURCE = 'BusData',
FORMAT ′‌′‌′ CSV' ‌′, PARSER_VERSION =′2.0′,
FIRSTROW =2
)
WITH (
payment_type INT 10,
fare_amount FLOAT 11
) AS nyc
GROUP BY payment_type
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Hot Area:

The query results include only [answer choice] in the csv/busfare folder. ______
CSV files in the tripdata 2020 subfolder
files that have files names beginning with "tripdata_2020"
CSV files that have file names containing "tripdata_202"
CSV files that have file named beginning with "tripdata_2020"
The query assumes that the first row in a CSV file is [answer choice] row. ______
a header
a data
an empty

Go to Question:

Prev Question

Next Question