DP-200 Exam - Question 28

Question

DRAG DROP -You have a table named SalesFact in an enterprise data warehouse in Azure Synapse Analytics. SalesFact contains sales data from the past 36 months and has the following characteristics:✑ Is partitioned by month✑ Contains one billion rows✑ Has clustered columnstore indexesAt the beginning of each month, you need to remove data from SalesFact that is older than 36 months as quickly as possible. Which three actions should you perform in sequence in a stored procedure? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:.

Examice · Accepted Answer

Step 1: Create an empty table named SalesFact_work that has the same schema as SalesFact.

Step 2: Switch the partition containing the stale data from SalesFact to SalesFact_Work.

SQL Data Warehouse supports partition splitting, merging, and switching. To switch partitions between two tables, you must ensure that the partitions align on their respective boundaries and that the table definitions match.

Loading data into partitions with partition switching is a convenient way stage new data in a table that is not visible to users the switch in the new data.

Step 3: Drop the SalesFact_Work table.

Reference:

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-partition

LongBao · Answer

The answer is correct

AngelRio · Answer

1.- Copy the data to a new table by using CTAS.
2.- Switch partition...
3.- Drop new table

Kostali · Answer

1.- Copy the data to a new table by using CTAS.
2.- Switch partition...
3.- Drop new table

DP-200 Exam - Question 28

Discussion