Microsoft Azure Data Engineer Associate - DP-203

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?

Quiz related visual



Comments

Loading comments...