Microsoft Exam DP-203 Topic 8 Question 10 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 10
Topic #: 8

You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse Analytics dedicated SQL pool.

You plan to keep a record of changes to the available fields.

The supplier data contains the following columns.

Which three additional columns should you add to the data to create a Type 2 SCD? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Asurrogate primary key

Bforeign key

Ceffective start date

Deffective end date

Elast modified date

Fbusiness key

Show Suggested Answer

Suggested Answer: B, C, F

by Lisha at May 04, 2022, 10:06 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!