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

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

List of questions

Question 71

Report
Export
Collapse

You have a Fabric tenant.

You are creating a Fabric Data Factory pipeline.

You have a stored procedure that returns the number of active customers and their average sales for the current month.

You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.

Which type of activity should you add?

Stored procedure
Stored procedure
Get metadata
Get metadata
Lookup
Lookup
Copy data
Copy data
Suggested answer: C

Explanation:

In a Fabric Data Factory pipeline, to execute a stored procedure and make the returned values available for downstream activities, the Lookup activity is used. This activity can retrieve a dataset from a data store and pass it on for further processing. Here's how you would use the Lookup activity in this context:

Add a Lookup activity to your pipeline.

Configure the Lookup activity to use the stored procedure by providing the necessary SQL statement or stored procedure name.

In the settings, specify that the activity should use the stored procedure mode.

Once the stored procedure executes, the Lookup activity will capture the results and make them available in the pipeline's memory.

Downstream activities can then reference the output of the Lookup activity.

asked 02/10/2024
Pichai Chaipoon
43 questions

Question 72

Report
Export
Collapse

DRAG DROP

You are implementing a medallion architecture in a single Fabric workspace.

You have a lakehouse that contains the 8ronze and Silver layers and a warehouse that contains the Gold layer.

You create the items required to populate the layers as shown in the following table.

Microsoft DP-600 image Question 72 90485 10022024015944000000

You need to ensure that the layers are populated daily in sequential order such that Silver is populated only after Bronze is complete, and Gold is populated only after Silver is complete. The solution must minimize development effort and complexity.

What should you use to execute each set of items? To answer, drag the appropriate options to the correct items. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content

NOTE: Each correct selection is worth one point.


Microsoft DP-600 image Question 72 90485 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 72 90485 10022024015944000
asked 02/10/2024
Sebastian van de Zweerde
43 questions

Question 73

Report
Export
Collapse

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

Microsoft DP-600 image Question 73 90486 10022024015944000000

Microsoft DP-600 image Question 73 90486 10022024015944000000

Which type of analytics are you performing?

predictive
predictive
descriptive
descriptive
prescriptive
prescriptive
diagnostic
diagnostic
Suggested answer: B

Explanation:

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.

asked 02/10/2024
Haythem KEfi
32 questions

Question 74

Report
Export
Collapse

You have an Azure Repos Git repository named Repo1 and a Fabric-enabled Microsoft Power Bl Premium capacity. The capacity contains two workspaces named Workspace! and Workspace2. Git integration is enabled at the workspace level.

You plan to use Microsoft Power Bl Desktop and Workspace! to make version-controlled changes to a semantic model stored in Repo1. The changes will be built and deployed lo Workspace2 by using Azure Pipelines.

You need to ensure that report and semantic model definitions are saved as individual text files in a folder hierarchy. The solution must minimize development and maintenance effort.

In which file format should you save the changes?

PBIP
PBIP
PBIT
PBIT
PBIX
PBIX
PBIDS
PBIDS
Suggested answer: C

Explanation:

When working with Power BI Desktop and Git integration for version control, report and semantic model definitions should be saved in the PBIX format. PBIX is the Power BI Desktop file format that contains definitions for reports, data models, and queries, and it can be easily saved and tracked in a version-controlled environment. The solution should minimize development and maintenance effort, and saving in PBIX format allows for the easiest transition from development to deployment, especially when using Azure Pipelines for CI/CD (continuous integration/continuous deployment) practices.

asked 02/10/2024
Wislon Pereira
36 questions

Question 75

Report
Export
Collapse

You have a Microsoft Fabric tenant that contains a dataflow.

You are exploring a new semantic model.

From Power Query, you need to view column information as shown in the following exhibit.

Microsoft DP-600 image Question 75 90488 10022024015944000000

Which three Data view options should you select? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Enable column profile
Enable column profile
Show column quality details
Show column quality details
Show column profile in details pane
Show column profile in details pane
Enable details pane
Enable details pane
Show column value distribution
Show column value distribution
Suggested answer: A, B, E

Explanation:

To view column information like the one shown in the exhibit in Power Query, you need to select the options that enable profiling and display quality and distribution details. These are: A. Enable column profile - This option turns on profiling for each column, showing statistics such as distinct and unique values. B. Show column quality details - It displays the column quality bar on top of each column showing the percentage of valid, error, and empty values. E. Show column value distribution - It enables the histogram display of value distribution for each column, which visualizes how often each value occurs.

asked 02/10/2024
Ken Wilson
40 questions

Question 76

Report
Export
Collapse

HOTSPOT

You have a Fabric warehouse that contains a table named Sales.Products. Sales.Products contains the following columns.

Microsoft DP-600 image Question 76 90489 10022024015944000000

You need to write a T-SQL query that will return the following columns.

Microsoft DP-600 image Question 76 90489 10022024015944000000

How should you complete the code? To answer, select the appropriate options in the answer area.


Microsoft DP-600 image Question 76 90489 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 76 90489 10022024015944000
asked 02/10/2024
Suneth Jayalath
33 questions

Question 77

Report
Export
Collapse

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?

Table. FuzzyGroup
Table. FuzzyGroup
Table.Profile
Table.Profile
Table.View
Table.View
Table.Schema
Table.Schema
Suggested answer: B

Explanation:

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.

asked 02/10/2024
Sandesh Somaiah
39 questions

Question 78

Report
Export
Collapse

HOTSPOT

You have a Fabric warehouse that contains a table named Sales.Orders. Sales.Orders contains the following columns.

Microsoft DP-600 image Question 78 90491 10022024015944000000

You need to write a T-SQL query that will return the following columns.

Microsoft DP-600 image Question 78 90491 10022024015944000000

How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft DP-600 image Question 78 90491 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 78 90491 10022024015944000
asked 02/10/2024
David Miller
32 questions

Question 79

Report
Export
Collapse

HOTSPOT

You have the source data model shown in the following exhibit.

Microsoft DP-600 image Question 79 90492 10022024015944000000

The primary keys of the tables are indicated by a key symbol beside the columns involved in each key.

You need to create a dimensional data model that will enable the analysis of order items by date, product, and customer.

What should you include in the solution? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft DP-600 image Question 79 90492 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 79 90492 10022024015944000
asked 02/10/2024
Haakon Schjelderup
53 questions

Question 80

Report
Export
Collapse

HOTSPOT

You have a Fabric tenant that contains two lakehouses.

You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is shown in the following exhibit.

Microsoft DP-600 image Question 80 90493 10022024015944000000

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.


Microsoft DP-600 image Question 80 90493 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 80 90493 10022024015944000
asked 02/10/2024
GUY XAVIER DONGMO FAPONG
39 questions
Total 118 questions
Go to page: of 12
Search

Related questions