Free DP-203 Exam Braindumps
Data Engineering on Microsoft Azure (Replaced with DP-700) Questions 99–103 (page: 23)

You have an Azure Synapse Analytics workspace.
You plan to deploy a lake database by using a database template in Azure Synapse.

Which two elements are included in the template? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You are implementing a star schema in an Azure Synapse Analytics dedicated SQL pool.
You plan to create a table named DimProduct.

DimProduct must be a Type 3 slowly changing dimension (SCD) table that meets the following requirements:

•The values in two columns named ProductKey and ProductSourceID will remain the same.
•The values in three columns named ProductName, ProductDescription, and Color can change.

You need to add additional columns to complete the following table definition.



Which three columns should you add? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

HOTSPOT (Drag and Drop is not supported)
You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a fact table named Table1. Table1 contains sales data. Sixty-five million rows of data are added to Table1 monthly.

At the end of each month, you need to remove data that is older than 36 months. The solution must minimize how long it takes to remove the data.

How should you partition Table1, and how should you remove the old data? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool.
You execute the following query.



Where will the rows returned by the query be stored?

You are deploying a lake database by using an Azure Synapse database template.

You need to add additional tables to the database. The solution must use the same grouping method as the template tables.

Which grouping method should you use?