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 . Option A
B. Option B
C. Option C
D. Option D
Answer: A
Explanation:
Use FIELDTERMINATOR =’t’ for tab.
Use ROWTERMINATOR =’