Exam DP-300 topic 4 question 10 discussion

Actual exam question from Microsoft's DP-300

Question #: 10
Topic #: 4

You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.
You need to create a surrogate key for the table. The solution must provide the fastest query performance.
What should you use for the surrogate key?

A. an IDENTITY column
B. a GUID column
C. a sequence object

Show Suggested Answer

Suggested Answer: A 🗳️
Dedicated SQL pool supports many, but not all, of the table features offered by other databases.
Surrogate keys are not supported. Implement it with an Identity column.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview

by aakben at Sept. 26, 2021, 12:17 p.m.

Comments

Submit Cancel

Ciupaz

6 months, 4 weeks ago

This question is more related to the DP-203 exam. I've never seen a topic like this in MeasureUp practice test.

upvoted 4 times

...

Fedor

1 year, 4 months ago

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-identity Surrogate Keys. Implement with Identity - it is meant that Identity is OK

upvoted 4 times

...

quermi

1 year, 5 months ago

i don't know. The only one correct is B Dedicated SQL pool supports many, but not all, of the table features offered by other databases. The following list shows some of the table features that aren't supported in dedicated SQL pool: - Foreign key, Check Table Constraints - Computed Columns - Indexed Views - Sequence (OPTION C) - Sparse Columns - Surrogate Keys. Implement with Identity (OPTION A). - Synonyms - Triggers - Unique Indexes - User-Defined Types https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview#unsupported-table-features

upvoted 3 times

...