Page: 1
/
21
Total 101 questions
Curious about Actual Microsoft Fabric Analytics Engineer Associate (DP-600) Exam Questions?
Here are sample Microsoft Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Exam questions from real exam. You can get more Microsoft Fabric Analytics Engineer Associate (DP-600) Exam premium practice questions at TestInsights.
Question 1
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?
Correct : A
Yes, the df.summary() method does meet the goal. This method is used to compute specified statistics for numeric and string columns. By default, it provides statistics such as count, mean, stddev, min, and max. Reference = The PySpark API documentation details the summary() function and the statistics it provides.
Start a Discussions
Submit Your Answer:
Question 2
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?
Correct : A
Yes, the DESCRIBE HISTORY statement does meet the goal. It provides information on the history of operations, including maintenance tasks, performed on a Delta table. Reference = The functionality of the DESCRIBE HISTORY statement can be verified in the Delta Lake documentation.
Start a Discussions
Submit Your Answer:
Question 3
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?
Correct : B
No, the REFRESH TABLE statement does not provide information on whether maintenance tasks were performed. It only updates the metadata of a table to reflect any changes on the data files. Reference = The use and effects of the REFRESH TABLE command are explained in the Spark SQL documentation.
Start a Discussions
Submit Your Answer:
Question 4
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?
Correct : B
No, the EXPLAIN TABLE statement does not identify whether maintenance tasks were performed on a table. It shows the execution plan for a query. Reference = The usage and output of the EXPLAIN command can be found in the Spark SQL documentation.
Start a Discussions
Submit Your Answer:
Question 5
You have a Fabric tenant that contains a semantic model. The model contains 15 tables.
You need to programmatically change each column that ends in the word Key to meet the following requirements:
* Hide the column.
* Set Nullable to False.
* Set Summarize By to None
* Set Available in MDX to False.
* Mark the column as a key column.
What should you use?
Correct : B
Tabular Editor is an advanced tool for editing Tabular models outside of Power BI Desktop that allows you to script out changes and apply them across multiple columns or tables. To accomplish the task programmatically, you would:
Open the model in Tabular Editor.
Create an Advanced Script using C# to iterate over all tables and their respective columns.
Within the script, check if the column name ends with 'Key'.
For columns that meet the condition, set the properties accordingly: IsHidden = true, IsNullable = false, SummarizeBy = None, IsAvailableInMDX = false.
Additionally, mark the column as a key column.
Save the changes and deploy them back to the Fabric tenant.
Start a Discussions
Submit Your Answer:
All Official Question Types