You have a file named File1.txt that has the following characteristics:
A header row -
Tab delimited values -
UNIX-style line endings -
You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.
Which query should you execute?

A. SELECT*FROM OPENROWSET(BULK ‘file1.txt’,DATA_SOURCE = ‘Sql1’,FORMAT = ‘CSV’, PARSER_VERSION = ‘2.0’,FIELDTERMINATOR = ‘t’,ROWTERMINATOR = ‘0x0a’,FIRSTROW= 2 -)

B. SELECT*FROM OPENROWSET(BULK ‘file1.txt’,DATA_SOURCE = ‘Sql1’,FORMAT = ‘CSV’, PARSER_VERSION = ‘2.0’,FIELDTERMINATOR = ‘,’,ROWTERMINATOR = ‘n’,FIRSTROW= 2 -)

C. SELECT*FROM OPENROWSET(BULK ‘file1.txt’,DATA_SOURCE = ‘Sql1’,FORMAT = ‘CSV’, PARSER_VERSION = ‘2.0’,FIELDTERMINATOR = ‘,’,ROWTERMINATOR = ‘0x0a’,FIRSTROW= 2 -)

D. SELECT*FROM OPENROWSET(BULK ‘file1.txt’,DATA_SOURCE = ‘Sql1’,FORMAT = ‘CSV’, PARSER_VERSION = ‘2.0’,FIELDTERMINATOR = ‘t’,ROWTERMINATOR = ‘0x0a’,FIRSTROW= 1 -)








 

Suggested Answer: A



This question is in DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Exam
For getting Microsoft Certified: Azure Enterprise Data Analyst Associate Certificate




Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.