DP-203 · Question #311
DP-203 Question #311: Real Exam Question with Answer & Explanation
The correct answer is A: the WITH clause. To specify explicit column names and data types, you can override the default column names and inferred data types by providing a schema definition in a WITH clause. https://learn.microsoft.com/en-us/training/modules/query-data-lake-using-azure-synapse- serverless-sql-pools/3-que
Question
You have an Azure subscription that contains the resources shown in the following table. You need to read the TSV files by using ad-hoc queries and the OPENROWSET function. The solution must assign a name and override the inferred data type of each column. What should you include in the OPENROWSET function?
Options
- Athe WITH clause
- Bthe ROWSET_OPTIONS bulk option
- Cthe DATAFILETYPE bulk option
- Dthe DATA_SOURCE parameter
Explanation
To specify explicit column names and data types, you can override the default column names and inferred data types by providing a schema definition in a WITH clause. https://learn.microsoft.com/en-us/training/modules/query-data-lake-using-azure-synapse- serverless-sql-pools/3-query-files
Community Discussion
No community discussion yet for this question.