LeetQuiz Logo
About•Privacy Policy•contact@leetquiz.com
RedditX
© 2025 LeetQuiz All rights reserved.
Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


Comments

Loading comments...

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
Quiz related visual



Powered ByGPT-5