Administering Relational Databases on Microsoft Azure (DP-300) Test 1
© examsiri.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 ,
FIRSTROW
)
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:
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 ,
FIRSTROW
)
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. ______
- The query assumes that the first row in a CSV file is [answer choice] row. ______
Go to Question: