QUESTION: 98 Exam Topic: Design and implement data storage questions

You are designing a sales transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will contain approximately 60 million rows per month and will be partitioned by month. The table will use a clustered column store index and round-robin distribution.

Approximately how many rows will there be for each combination of distribution and partition?

1 million
5 million
20 million
60 million

Answer(s): A

Reveal Solution Next Question

QUESTION: 99 Exam Topic: Design and implement data storage questions

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.

relationships
data formats
linked services
table permissions
table definitions

Answer(s): A,E

Reveal Solution Next Question

QUESTION: 100 Exam Topic: Design and implement data storage questions

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.

[EffectiveStartDate] [datetime] NOT NULL
[EffectiveEndDate] [datetime] NOT NULL
[OriginalProductDescription] NVARCHAR(2000) NOT NULL
[IsCurrentRow] [bit] NOT NULL
[OriginalColor] NVARCHAR(50) NOT NULL
[OriginalProductName] NVARCHAR(100) NULL

Answer(s): C,E,F

Reveal Solution Next Question

QUESTION: 101 Exam Topic: Design and implement data storage questions

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.