DP-203 · Question #270
Nicole is working on migrating on-premises SQL Server databases to Azure SQL data warehouse (Synapse dedicated SQL pools) tables. The tables of the dedicated SQL pools of Synapse Analytics require…
The correct answer is A. CTAS. Option A is correct because the CTAS statement can be used as the most efficient method while splitting the partitions that contain data. Option B is incorrect because CETAS is used in the dedicated SQL pool of Synapse for creating External table and data export operations in…
Question
Nicole is working on migrating on-premises SQL Server databases to Azure SQL data warehouse (Synapse dedicated SQL pools) tables. The tables of the dedicated SQL pools of Synapse Analytics require partition. She's designing SQL table partitions for this data migration to the Azure Synapse. The partition of the tables already contains the data, and she's looking for the most efficient method to split the partitions in the dedicated SQL pool tables. What T-SQL statement can she use for splitting partitions that contain data?
Options
- ACTAS
- BCETAS
- COPENROWSET
- DClustered Columnstore Indexes
How the community answered
(55 responses)- A73% (40)
- B9% (5)
- C15% (8)
- D4% (2)
Explanation
Option A is correct because the CTAS statement can be used as the most efficient method while splitting the partitions that contain data. Option B is incorrect because CETAS is used in the dedicated SQL pool of Synapse for creating External table and data export operations in parallel for Hadoop, Azure Blob Storage, and ADLS Option C is incorrect because the OPENROWSET function in Synapse SQL reads the content of the file(s) from a data source and returns the content as a set of rows. Option D is incorrect because Clustered column store tables offer both the highest level of data compression and the best overall query performance. It doesn't help in partition splitting. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-tables-partition?context=/azure/synapse-analytics/context/context
Topics
Community Discussion
No community discussion yet for this question.