Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
You are performing exploratory analysis of bus fare data stored in an Azure Data Lake Storage Gen2 account using an Azure Synapse Analytics serverless SQL pool. You run the following Transact-SQL query.
SELECT
TOP 100 *
FROM
OPENROWSET(
BULK 'https://datalakeaccount.dfs.core.windows.net/container/path/busfares.csv',
FORMAT = 'CSV',
PARSER_VERSION = '2.0',
HEADER_ROW = TRUE
) AS [result]
SELECT
TOP 100 *
FROM
OPENROWSET(
BULK 'https://datalakeaccount.dfs.core.windows.net/container/path/busfares.csv',
FORMAT = 'CSV',
PARSER_VERSION = '2.0',
HEADER_ROW = TRUE
) AS [result]
What is included in the results of this query?
You are performing exploratory analysis of bus fare data stored in an Azure Data Lake Storage Gen2 account using an Azure Synapse Analytics serverless SQL pool. You run the following Transact-SQL query.
SELECT
TOP 100 *
FROM
OPENROWSET(
BULK 'https://datalakeaccount.dfs.core.windows.net/container/path/busfares.csv',
FORMAT = 'CSV',
PARSER_VERSION = '2.0',
HEADER_ROW = TRUE
) AS [result]
SELECT
TOP 100 *
FROM
OPENROWSET(
BULK 'https://datalakeaccount.dfs.core.windows.net/container/path/busfares.csv',
FORMAT = 'CSV',
PARSER_VERSION = '2.0',
HEADER_ROW = TRUE
) AS [result]
What is included in the results of this query?
Exam-Like
A
Only CSV files in the tripdata_2020 subfolder.
B
All files that have file names that beginning with "tripdata_2020".
Comments
Loading comments...