Microsoft Exam DP-600 Topic 1 Question 20 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 20
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Fabric tenant that contains a lakehouse named Lakehousel. Lakehousel contains a Delta table named Customer.

When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.

You need to identify whether maintenance tasks were performed on Customer.

Solution: You run the following Spark SQL statement:

DESCRIBE DETAIL customer

Does this meet the goal?

AYes

BNo

Show Suggested Answer

Suggested Answer: B

by Rosalind at Aug 24, 2024, 07:05 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Malika

3 months ago

Haha, I bet the answer is 'B) No' because the question specifically says 'you suspect that maintenance was NOT performed on the table'. Running DESCRIBE DETAIL isn't going to prove that maintenance wasn't done.

upvoted 0 times

Glory

2 months ago

B) No

upvoted 0 times

...

Arlie

2 months ago

A) Yes

upvoted 0 times

...

Cyndy

3 months ago

In that case, running the Spark SQL statement would help identify if maintenance tasks were performed.

upvoted 0 times

...

Sharika

3 months ago

But what if the maintenance tasks were not performed on Customer?

upvoted 0 times

...

Nathan

3 months ago

Hmm, I'm not sure if that's the best approach. Wouldn't it be better to check the table's stats or metadata directly instead of relying on a Spark SQL statement?

upvoted 0 times

Pete

2 months ago

You're right, checking the table's stats or metadata directly would probably be more reliable.

upvoted 0 times

...

In

3 months ago

I think running the Spark SQL statement might not be the best approach.

upvoted 0 times

...

Lindsay

3 months ago

The DESCRIBE DETAIL command should give you information about the table, including whether maintenance tasks were performed. That seems like a reasonable solution to me.

upvoted 0 times