Microsoft Implementing Analytics Solutions Using Microsoft Fabric DP-600 Exam Practice Test

Page: 1 / 14
Total 140 questions
Question 1

You have a Fabric warehouse that contains a table named SalesOrderDetail. SalesOrderDetail contains three columns named OrderQty, ProductID and SalesOrderlD. SalesOrderDetail contains one row per combination of SalesOrderlD and ProductID.

You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.

Which T-SQL statement should you run?

A)

B)

C)

D)



Answer : C


Question 2

You have a Fabric warehouse named Warehousel that contains a table named Table! Tablel contains customer data.

You need to implement row-level security (RLS) for Tablel. The solution must ensure that users can see only their respective data.

Which two objects should you create? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.



Answer : A, C


Question 3

You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements. What should you do?



Answer : B


Question 4

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1.

You are creating a new data pipeline.

You plan to copy external data to Table1. The schema of the external data changes regularly.

You need the copy operation to meet the following requirements:

* Replace Table1 with the schema of the external data.

* Replace all the data in Table1 with the rows in the external data.

You add a Copy data activity to the pipeline. What should you do for the Copy data activity?



Answer : B

For the Copy data activity, from the Destination tab, setting Table action to Overwrite (B) will ensure that Table1 is replaced with the schema and rows of the external data, meeting the requirements of replacing both the schema and data of the destination table. Reference = Information about Copy data activity and table actions in Azure Data Factory, which can be applied to data pipelines in Fabric, is available in the Azure Data Factory documentation.


Question 5

You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data.

You need to identify the min and max values for each column in the query results.

Which three Data view options should you select? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.



Answer : B, D, E


Question 6

You have a Fabric tenant that contains a Microsoft Power Bl report.

You are exploring a new semantic model.

You need to display the following column statistics:

* Count

* Average

* Null count

* Distinct count

* Standard deviation

Which Power Query function should you run?



Answer : B

The Table.Profile function in Power Query is used to generate column statistics such as count, average, null count, distinct count, and standard deviation. You can use this function as follows:

Invoke the Power Query Editor.

Apply the Table.Profile function to your table.

The result will be a table where each row represents a column from the original table, and each column in the result represents a different statistic such as those listed in the requirement.


Question 7

You have a Fabric notebook that has the Python code and output shown in the following exhibit.

Which type of analytics are you performing?



Answer : B

The Python code and output shown in the exhibit display a histogram, which is a representation of the distribution of data. This kind of analysis is descriptive analytics, which is used to describe or summarize the features of a dataset. Descriptive analytics answers the question of 'what has happened' by providing insight into past data through tools such as mean, median, mode, standard deviation, and graphical representations like histograms.


Page:    1 / 14   
Total 140 questions