Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 159

You have an Azure subscription that contains an Azure Synapse Analytics workspace.

You create an Azure Data Lake Storage Gen2 account and upload a CSV file named File1.csv.

You need to use Synapse Studio to query the data in File1.csv by using a serverless SQL pool.

Which Transact-SQL operator should you include in the query?

Answer options

• A. OPENQUERY
• B. OPENROWSET
• C. STRING_SPLIT
• D. OPENDATASOURCE

Correct answer: B

Explanation

The correct answer is B, OPENROWSET, as it allows for direct access to the data in external files such as CSV in Azure Data Lake Storage. OPENQUERY is used for executing pass-through queries against linked servers, STRING_SPLIT is a function for splitting strings, and OPENDATASOURCE is used for connecting to external data sources, making them unsuitable for this scenario.