You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named account1 and an Azure Synapse Analytics workspace named workspace1.You need to create an external table in a serverless SQL pool in workspace1. The external table will reference CSV files stored in account1. The solution must maximize performance.How should you configure the external table?
Answer(s): A
HOTSPOT (Drag and Drop is not supported)You have an Azure Synapse Analytics serverless SQL pool that contains a database named db1. The data model for db1 is shown in the following exhibit.Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the exhibit.NOTE: Each correct selection is worth one point.
You have an Azure Databricks workspace and an Azure Data Lake Storage Gen2 account named storage1.New files are uploaded daily to storage1.You need to recommend a solution that configures storage1 as a structured streaming source. The solution must meet the following requirements:•Incrementally process new files as they are uploaded to storage1.•Minimize implementation and maintenance effort.•Minimize the cost of processing millions of files.•Support schema inference and schema drift.Which should you include in the recommendation?
Answer(s): C
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?
You have an Azure Synapse Analytics dedicated SQL pool.You plan to create a fact table named Table1 that will contain a clustered columnstore index.You need to optimize data compression and query performance for Table1.What is the minimum number of rows that Table1 should contain before you create partitions?
Answer(s): D
Post your Comments and Discuss Microsoft DP-203 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the DP-203 content, but please register or login to continue.