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

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

List of questions

Question 51

Report
Export
Collapse

You have a Microsoft Power Bl semantic model.

You need to identify any surrogate key columns in the model that have the Summarize By property set to a value other than to None. The solution must minimize effort.

What should you use?

DAX Formatter in DAX Studio
DAX Formatter in DAX Studio
Model view in Microsoft Power Bl Desktop
Model view in Microsoft Power Bl Desktop
Model explorer in Microsoft Power Bl Desktop
Model explorer in Microsoft Power Bl Desktop
Best Practice Analyzer in Tabular Editor
Best Practice Analyzer in Tabular Editor
Suggested answer: D

Explanation:

To identify surrogate key columns with the 'Summarize By' property set to a value other than 'None,' the Best Practice Analyzer in Tabular Editor is the most efficient tool. The Best Practice Analyzer can analyze the entire model and provide a report on all columns that do not meet a specified best practice, such as having the 'Summarize By' property set correctly for surrogate key columns. Here's how you would proceed:

Open your Power BI model in Tabular Editor.

Go to the Advanced Scripting window.

Write or use an existing script that checks the 'Summarize By' property of each column.

Execute the script to get a report on the surrogate key columns that do not have their 'Summarize By' property set to 'None'.

You can then review and adjust the properties of the columns directly within the Tabular Editor.

asked 02/10/2024
marius trif
47 questions

Question 52

Report
Export
Collapse

DRAG DROP

You create a semantic model by using Microsoft Power Bl Desktop. The model contains one security role named SalesRegionManager and the following tables:

* Sales

* SalesRegion

* Sales Ad dress

You need to modify the model to ensure that users assigned the SalesRegionManager role cannot see a column named Address in Sales Address.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.


Microsoft DP-600 image Question 52 90465 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 52 90465 10022024015944000
asked 02/10/2024
Chakour BOURAIMA
33 questions

Question 53

Report
Export
Collapse

You have a Microsoft Power Bl semantic model that contains measures. The measures use multiple calculate functions and a filter function.

You are evaluating the performance of the measures.

In which use case will replacing the filter function with the keepfilters function reduce execution time?

when the filter function uses a nested calculate function
when the filter function uses a nested calculate function
when the filter function references a column from a single table that uses Import mode
when the filter function references a column from a single table that uses Import mode
when the filter function references columns from multiple tables
when the filter function references columns from multiple tables
when the filter function references a measure
when the filter function references a measure
Suggested answer: A

Explanation:

The KEEPFILTERS function modifies the way filters are applied in calculations done through the CALCULATE function. It can be particularly beneficial to replace the FILTER function with KEEPFILTERS when the filter context is being overridden by nested CALCULATE functions, which may remove filters that are being applied on a column. This can potentially reduce execution time because KEEPFILTERS maintains the existing filter context and allows the nested CALCULATE functions to be evaluated more efficiently.

asked 02/10/2024
Gbolahan Olukole
29 questions

Question 54

Report
Export
Collapse

HOTSPOT

You have a Fabric tenant that contains a lakehouse.

You are using a Fabric notebook to save a large DataFrame by using the following code.

Microsoft DP-600 image Question 54 90467 10022024015944000000

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 54 90467 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 54 90467 10022024015944000
asked 02/10/2024
Jonas Junker
42 questions

Question 55

Report
Export
Collapse

HOTSPOT

You have a Fabric workspace that uses the default Spark starter pool and runtime version 1,2.

You plan to read a CSV file named Sales.raw.csv in a lakehouse, select columns, and save the data as a Delta table to the managed area of the lakehouse. Sales_raw.csv contains 12 columns.

You have the following code.

Microsoft DP-600 image Question 55 90468 10022024015944000000

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 55 90468 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 55 90468 10022024015944000
asked 02/10/2024
Jean-Bosco Muganza
38 questions

Question 56

Report
Export
Collapse

DRAG DROP

You are creating a dataflow in Fabric to ingest data from an Azure SQL database by using a T-SQL statement.

You need to ensure that any foldable Power Query transformation steps are processed by the Microsoft SQL Server engine.

How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value 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 56 90469 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 56 90469 10022024015944000
asked 02/10/2024
Valerio Lorenzani
38 questions

Question 57

Report
Export
Collapse

DRAG DROP

You have a Fabric tenant that contains a lakehouse named Lakehouse1

Readings from 100 loT devices are appended to a Delta table in Lakehouse1. Each set of readings is approximately 25 KB. Approximately 10 GB of data is received daily.

All the table and SparkSession settings are set to the default.

You discover that queries are slow to execute. In addition, the lakehouse storage contains data and log files that are no longer used.

You need to remove the files that are no longer used and combine small files into larger files with a target size of 1 GB per file.

What should you do? To answer, drag the appropriate actions to the correct requirements. Each action 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 57 90470 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 57 90470 10022024015944000
asked 02/10/2024
Ervin Loong
45 questions

Question 58

Report
Export
Collapse

HOTSPOT

You have a Fabric workspace named Workspace1 and an Azure Data Lake Storage Gen2 account named storage'!. Workspace1 contains a lakehouse named Lakehouse1.

You need to create a shortcut to storage1 in Lakehouse1.

Which connection and endpoint should you specify? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft DP-600 image Question 58 90471 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 58 90471 10022024015944000
asked 02/10/2024
Dele Olagoroye
31 questions

Question 59

Report
Export
Collapse

HOTSPOT

You have a Microsoft Power B1 report and a semantic model that uses Direct Lake mode. From Power Si Desktop, you open Performance analyzer as shown in the following exhibit.

Microsoft DP-600 image Question 59 90472 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 59 90472 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 59 90472 10022024015944000
asked 02/10/2024
Ralitsa Yankova
50 questions

Question 60

Report
Export
Collapse

HOTSPOT

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Nyctaxi_raw. Nyctaxi_raw contains the following columns.

Microsoft DP-600 image Question 60 90473 10022024015944000000

You create a Fabric notebook and attach it to lakehouse1.

You need to use PySpark code to transform the data. The solution must meet the following requirements:

* Add a column named pickupDate that will contain only the date portion of pickupDateTime.

* Filter the DataFrame to include only rows where fareAmount is a positive number that is less than 100.

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 60 90473 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 60 90473 10022024015944000
asked 02/10/2024
Evgeniy Lyashonkov
34 questions
Total 118 questions
Go to page: of 12
Search

Related questions