Microsoft Exam DP-203 Topic 1 Question 103 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 103
Topic #: 1

You have an Azure Databricks workspace that contains a Delta Lake dimension table named Tablet. Table1 is a Type 2 slowly changing dimension (SCD) table. You need to apply updates from a source table to Table1. Which Apache Spark SQL operation should you use?

ACREATE

BUPDATE

CMERGE

DALTER

Show Suggested Answer

Suggested Answer: A, B

by Melissia at Sep 17, 2024, 06:44 AM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Felix

3 days ago

I'm not sure, but I think MERGE makes sense because it allows you to insert, update, or delete records based on a condition.

upvoted 0 times

...

Lakeesha

6 days ago

I agree with Rikki, MERGE is the correct operation for updating Type 2 SCD tables.

upvoted 0 times

...

Rikki

9 days ago

I think the answer is C) MERGE.

upvoted 0 times

...