Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Microsoft Exam DP-203 Topic 1 Question 103 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 103
Topic #: 1

[All DP-203 Questions]

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

Maxima

2 months ago

I'm just glad the question didn't ask us to use the MERGE statement to do the hokey pokey. That would have been a real brain-twister!

upvoted 0 times

Ming

25 days ago

C) MERGE

upvoted 0 times

...

Hoa

1 months ago

B) UPDATE

upvoted 0 times

...

Nidia

1 months ago

C) MERGE

upvoted 0 times

...

...

Harris

2 months ago

MERGE? Really? I was thinking CREATE would be the best way to create a new table. Oh wait, this is an update scenario. MERGE it is!

upvoted 0 times

Kenneth

30 days ago

User3: CREATE would be for creating a new table, but in this case, MERGE is the way to go for updating Table1.

upvoted 0 times

...

Micaela

1 months ago

User2: I agree, MERGE is the best option for updating a Type 2 slowly changing dimension table.

upvoted 0 times

...

Gregoria

1 months ago

User1: MERGE is the correct operation to apply updates from a source table to Table1.

upvoted 0 times

...

...

Izetta

2 months ago

Hmm, I was also considering UPDATE, but MERGE is definitely the more robust and comprehensive solution for this problem.

upvoted 0 times

...

Thaddeus

2 months ago

I agree, MERGE is the way to go. It's designed specifically for this kind of data integration use case.

upvoted 0 times

Emile

17 days ago

Let's go ahead and use MERGE to apply the updates to Table1.

upvoted 0 times

...

Magdalene

21 days ago

MERGE is definitely the way to go for updating Type 2 SCD tables.

upvoted 0 times

...

Janella

1 months ago

I agree, MERGE is the best option for this scenario.

upvoted 0 times

...

Lorita

1 months ago

I think we should use MERGE for updating Table1.

upvoted 0 times

...

...

Sabrina

2 months ago

The MERGE operation seems like the obvious choice here to update the Type 2 SCD table. It can handle both insert and update scenarios seamlessly.

upvoted 0 times

...

Felix

3 months 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

3 months ago

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

upvoted 0 times

...

Rikki

3 months ago

I think the answer is C) MERGE.

upvoted 0 times

...