
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]
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]
What is included in the results of this query?
Exam-Like

Comments
Loading comments...