ExamGecko
Home / Microsoft / DP-600 / List of questions
Ask Question

Microsoft DP-600 Practice Test - Questions Answers, Page 5

Add to Whishlist

List of questions

Question 41

Report Export Collapse

You have a Fabric tenant that contains a warehouse.

Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse.

What should you use to identify whether throttling is occurring?

Become a Premium Member for full access
  Unlock Premium Member

Question 42

Report Export Collapse

You have a Fabric tenant that contains a warehouse.

A user discovers that a report that usually takes two minutes to render has been running for 45 minutes and has still not rendered.

You need to identify what is preventing the report query from completing.

Which dynamic management view (DMV) should you use?

Become a Premium Member for full access
  Unlock Premium Member

Question 43

Report Export Collapse

You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD).

Which two actions should you include in the process? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

Become a Premium Member for full access
  Unlock Premium Member

Question 44

Report Export Collapse

You are analyzing customer purchases in a Fabric notebook by using PySpanc You have the following DataFrames:

Microsoft DP-600 image Question 44 90457 10022024015944000000

You need to join the DataFrames on the customer_id column. The solution must minimize data shuffling. You write the following code.

Microsoft DP-600 image Question 44 90457 10022024015944000000

Which code should you run to populate the results DataFrame?

A)

Microsoft DP-600 image Question 44 90457 10022024015944000000

B)

Microsoft DP-600 image Question 44 90457 10022024015944000000

C)

Microsoft DP-600 image Question 44 90457 10022024015944000000

D)

Microsoft DP-600 image Question 44 90457 10022024015944000000

Become a Premium Member for full access
  Unlock Premium Member

Question 45

Report Export Collapse

You have a Fabric tenant that contains a new semantic model in OneLake.

You use a Fabric notebook to read the data into a Spark DataFrame.

You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.

Solution: You use the following PySpark expression:

df.explain()

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 46

Report Export Collapse

You have a Fabric tenant that contains a new semantic model in OneLake.

You use a Fabric notebook to read the data into a Spark DataFrame.

You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.

Solution: You use the following PySpark expression:

df.show()

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 47

Report Export Collapse

You have a Fabric tenant that contains a new semantic model in OneLake.

You use a Fabric notebook to read the data into a Spark DataFrame.

You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.

Solution: You use the following PySpark expression:

df .sumary ()

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 48

Report Export Collapse

You have a Fabric tenant that contains a takehouse named lakehouse1. Lakehouse1 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 HISTORY customer

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 49

Report Export Collapse

You have a Fabric tenant tha1 contains a takehouse named Lakehouse1. Lakehouse1 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:

REFRESH TABLE customer

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 50

Report Export Collapse

You have a Fabric tenant tha1 contains a takehouse named Lakehouse1. Lakehouse1 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:

EXPLAIN TABLE customer

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member
Total 118 questions
Go to page: of 12
Search

Related questions