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

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

List of questions

Question 81

Report
Export
Collapse

HOTSPOT

You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains a fact table named FactSales that has one billion rows. You run the following T-SQL statement.

CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales;

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.


Microsoft DP-600 image Question 81 90494 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 81 90494 10022024015944000
asked 02/10/2024
sailakshmi KM
41 questions

Question 82

Report
Export
Collapse

You have a Fabric tenant that contains customer churn data stored as Parquet files in OneLake. The data contains details about customer demographics and product usage.

You create a Fabric notebook to read the data into a Spark DataFrame. You then create column charts in the notebook that show the distribution of retained customers as compared to lost customers based on geography, the number of products purchased, age. and customer tenure.

Which type of analytics are you performing?

prescriptive
prescriptive
diagnostic
diagnostic
descriptive
descriptive
predictive
predictive
Suggested answer: C
asked 02/10/2024
David LeBlanc
21 questions

Question 83

Report
Export
Collapse

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 semantic model named Model1.

You discover that the following query performs slowly against Model1.

Microsoft DP-600 image Question 83 90496 10022024015944000000

You need to reduce the execution time of the query.

Solution: You replace line 4 by using the following code:

Microsoft DP-600 image Question 83 90496 10022024015944000000

Does this meet the goal?

Yes
Yes
No
No
Suggested answer: B
asked 02/10/2024
Henock Asmerom
40 questions

Question 84

Report
Export
Collapse

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 semantic model named Model1.

You discover that the following query performs slowly against Model1.

Microsoft DP-600 image Question 84 90497 10022024015944000000

You need to reduce the execution time of the query.

Solution: You replace line 4 by using the following code:

Microsoft DP-600 image Question 84 90497 10022024015944000000

Does this meet the goal?

Yes
Yes
No
No
Suggested answer: A
asked 02/10/2024
Dasaret Tillman
40 questions

Question 85

Report
Export
Collapse

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 semantic model named Model1.

You discover that the following query performs slowly against Model1.

Microsoft DP-600 image Question 85 90498 10022024015944000000

You need to reduce the execution time of the query.

Solution: You replace line 4 by using the following code:

Microsoft DP-600 image Question 85 90498 10022024015944000000

Does this meet the goal?

Yes
Yes
No
No
Suggested answer: B
asked 02/10/2024
xingrui li
36 questions

Question 86

Report
Export
Collapse

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?

Yes
Yes
No
No
Suggested answer: B
asked 02/10/2024
Guillermo Fontaine
47 questions

Question 87

Report
Export
Collapse

You need to recommend which type of fabric capacity SKU meets the data analytics requirements for the Research division. What should you recommend?

EM
EM
F
F
P
P
A
A
Suggested answer: B
asked 02/10/2024
Prakhar Sengar
33 questions

Question 88

Report
Export
Collapse

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?

Become a Premium Member for full access
  Unlock Premium Member

Question 89

Report
Export
Collapse

You have a Fabric workspace named Workspace1 and an Azure SQL database.

You plan to create a dataflow that will read data from the database, and then transform the data by performing an inner join. You need to ignore spaces in the values when performing the inner join The solution must minimize development effort. What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 90

Report
Export
Collapse

You have a Fabric tenant that contains a lakehouse named Lakehouse! Lakehouse1 contains a Delta table that has one million Parquet files.

You need to remove files that were NOT referenced by the table during the past 30 days. The solution must ensure that the transaction log remains consistent, and the ACID properties of the table are maintained

What should you do?

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

Related questions