Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 12 discussion

Actual exam question from Microsoft's DP-203

Question #: 12
Topic #: 1

You need to design an Azure Synapse Analytics dedicated SQL pool that meets the following requirements:
✑ Can return an employee record from a given point in time.
✑ Maintains the latest employee information.
✑ Minimizes query complexity.
How should you model the employee data?

A. as a temporal table
B. as a SQL graph table
C. as a degenerate dimension table
D. as a Type 2 slowly changing dimension (SCD) table

Show Suggested Answer

Suggested Answer: D 🗳️

by bc5468521 at May 27, 2021, 4:18 p.m.

Comments

Submit Cancel

rashjan

Highly Voted 3 years, 6 months ago

Selected Answer: D

D is correct (voting comment that people dont have to open discussion always, please upvote to help others)

upvoted 196 times

...

bc5468521

Highly Voted 4 years ago

Answer D; Temporal table is better than SCD2, but it is not supported in Synpase yet

upvoted 82 times

Preben

4 years ago

Here's the documentation for how to implement temporal tables in Synapse from 2019. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-temporary

upvoted 1 times

mbravo

4 years ago

Temporal tables and Temporary tables are two very distinct concepts. Your link has absolutely nothing to do with this question.

upvoted 20 times

Vaishnav

3 years, 11 months ago

https://docs.microsoft.com/en-us/azure/azure-sql/temporal-tables Answer : A Temporal Tables

upvoted 2 times

berserksap

3 years, 7 months ago

I think synapse doesn't support temporal tables. Please check the below comment by hsetin.

upvoted 2 times

...

Load full discussion...

...

sparkchu

3 years, 3 months ago

though this not something relative to this question. temproal tables looks alike to delta table.

upvoted 1 times

...

GodfreyMbizo

2 years, 4 months ago

Temporarytables is completely offtopic ,the catch here is ...at a point in time hence SCD is the way to go

upvoted 2 times

...

SolutionA

1 year, 10 months ago

temPORAL table purpose is to query point in time data which can perform beyond what SCD2 can do, but its not supported in synapse

upvoted 1 times

...

EmnCours

Most Recent 6 months, 3 weeks ago

Selected Answer: D

Correct Answer: D

upvoted 1 times

...

mavdplas

6 months, 3 weeks ago

Selected Answer: D

Answer: D

upvoted 1 times

...

GBA30

7 months, 3 weeks ago

Selected Answer: D

Answer is D

upvoted 1 times

...

dakku987

1 year, 6 months ago

Selected Answer: D

scd 2 maintain the iasactive current time end time like this in table

upvoted 2 times

...

Bail

1 year, 6 months ago

Selected Answer: D

It's D

upvoted 2 times

...

hassexat

1 year, 9 months ago

D Because is the way as you can get historical data for the employee

upvoted 1 times

...

kkk5566

1 year, 9 months ago

Selected Answer: D

correct

upvoted 2 times

...

Deeksha1234

2 years ago

D is correct

upvoted 1 times

...

steveo123

2 years, 1 month ago

Selected Answer: D

D is correct.

upvoted 2 times

...

haidebelognime

2 years, 4 months ago

Selected Answer: D

it is D 100%, stop messing around with answers like "temporal table"

upvoted 5 times

...

bubby248

2 years, 4 months ago

SCD type 2 which has latest boolean flag to retreive

upvoted 1 times

...

vigilante89

2 years, 6 months ago

Type 1 SCD - This concept overwrites the existing value within the dimension table with the new value without retaining the old data. Type 2 SCD - This concept maintains the versioning of the table. It creates and adds a new row with the new value and maintains the existing row containing the old value which usually is required for historic and reporting purposes. Type 3 SCD - This concept creates a new column with the new value in the existing record but also retains the original column containing the old value which usually is required for historic and reporting purposes.

upvoted 5 times

...