DP-203 · Question #311
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…
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…
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?
Exhibit
Options
- Athe WITH clause
- Bthe ROWSET_OPTIONS bulk option
- Cthe DATAFILETYPE bulk option
- Dthe DATA_SOURCE parameter
How the community answered
(66 responses)- A73% (48)
- B8% (5)
- C15% (10)
- D5% (3)
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
Topics
Community Discussion
No community discussion yet for this question.