ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 1 question 12 discussion

Actual exam question from Microsoft's DP-203
Question #: 12
Topic #: 1
[All DP-203 Questions]

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 Hide Answer
Suggested Answer: D 🗳️
by bc5468521 at May 27, 2021, 4:18 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
rashjan
Highly Voted 3 years, 4 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 3 years, 11 months ago
Answer D; Temporal table is better than SCD2, but it is not supported in Synpase yet
upvoted 82 times
Preben
3 years, 10 months 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
3 years, 10 months 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, 9 months ago
https://docs.microsoft.com/en-us/azure/azure-sql/temporal-tables Answer : A Temporal Tables
upvoted 2 times
berserksap
3 years, 6 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, 1 month ago
though this not something relative to this question. temproal tables looks alike to delta table.
upvoted 1 times
...
GodfreyMbizo
2 years, 3 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, 9 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 5 months, 1 week ago
Selected Answer: D
Correct Answer: D
upvoted 1 times
...
mavdplas
5 months, 1 week ago
Selected Answer: D
Answer: D
upvoted 1 times
...
GBA30
6 months, 1 week ago
Selected Answer: D
Answer is D
upvoted 1 times
...
dakku987
1 year, 4 months ago
Selected Answer: D
scd 2 maintain the iasactive current time end time like this in table
upvoted 2 times
...
Bail
1 year, 5 months ago
Selected Answer: D
It's D
upvoted 2 times
...
hassexat
1 year, 7 months ago
D Because is the way as you can get historical data for the employee
upvoted 1 times
...
kkk5566
1 year, 8 months ago
Selected Answer: D
correct
upvoted 2 times
...
Deeksha1234
1 year, 10 months ago
D is correct
upvoted 1 times
...
steveo123
2 years ago
Selected Answer: D
D is correct.
upvoted 2 times
...
haidebelognime
2 years, 2 months ago
Selected Answer: D
it is D 100%, stop messing around with answers like "temporal table"
upvoted 5 times
...
bubby248
2 years, 2 months ago
SCD type 2 which has latest boolean flag to retreive
upvoted 1 times
...
vigilante89
2 years, 4 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
...
Fernando_Caemerer
2 years, 4 months ago
Selected Answer: D
Answer D
upvoted 1 times
...
OldSchool
2 years, 5 months ago
Selected Answer: D
SCD 2 - D
upvoted 1 times
...
Deeksha1234
2 years, 8 months ago
correct D
upvoted 2 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago