Valid DP-300 Dumps shared by ExamDiscuss.com for Helping Passing DP-300 Exam! ExamDiscuss.com now offer the newest DP-300 exam dumps, the ExamDiscuss.com DP-300 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-300 dumps with Test Engine here:
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?
Correct 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-tablesoverview