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

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

List of questions

Question 61

Report
Export
Collapse

You have a Microsoft Power Bl report named Report1 that uses a Fabric semantic model.

Users discover that Report1 renders slowly.

You open Performance analyzer and identify that a visual named Orders By Date is the slowest to render. The duration breakdown for Orders By Date is shown in the following table.

Microsoft DP-600 image Question 61 90474 10022024015944000000

What will provide the greatest reduction in the rendering duration of Report1?

Change the visual type of Orders By Dale.
Change the visual type of Orders By Dale.
Enable automatic page refresh.
Enable automatic page refresh.
Optimize the DAX query of Orders By Date by using DAX Studio.
Optimize the DAX query of Orders By Date by using DAX Studio.
Reduce the number of visuals in Report1.
Reduce the number of visuals in Report1.
Suggested answer: C

Explanation:

Based on the duration breakdown provided, the major contributor to the rendering duration is categorized as 'Other,' which is significantly higher than DAX Query and Visual display times. This suggests that the issue is less likely with the DAX calculation or visual rendering times and more likely related to model performance or the complexity of the visual. However, of the options provided, optimizing the DAX query can be a crucial step, even if 'Other' factors are dominant. Using DAX Studio, you can analyze and optimize the DAX queries that power your visuals for performance improvements. Here's how you might proceed:

Open DAX Studio and connect it to your Power BI report.

Capture the DAX query generated by the Orders By Date visual.

Use the Performance Analyzer feature within DAX Studio to analyze the query.

Look for inefficiencies or long-running operations.

Optimize the DAX query by simplifying measures, removing unnecessary calculations, or improving iterator functions.

Test the optimized query to ensure it reduces the overall duration.

asked 02/10/2024
Mithun E
50 questions

Question 62

Report
Export
Collapse

You have a semantic model named Model 1. Model 1 contains five tables that all use Import mode. Model1 contains a dynamic row-level security (RLS) role named HR. The HR role filters employee data so that HR managers only see the data of the department to which they are assigned.

You publish Model1 to a Fabric tenant and configure RLS role membership. You share the model and related reports to users.

An HR manager reports that the data they see in a report is incomplete.

What should you do to validate the data seen by the HR Manager?

Ask the HR manager to open the report in Microsoft Power Bl Desktop.
Ask the HR manager to open the report in Microsoft Power Bl Desktop.
Select Test as role to view the data as the HR role.
Select Test as role to view the data as the HR role.
Select Test as role to view the report as the HR manager,
Select Test as role to view the report as the HR manager,
Filter the data in the report to match the intended logic of the filter for the HR department.
Filter the data in the report to match the intended logic of the filter for the HR department.
Suggested answer: B

Explanation:

To validate the data seen by the HR manager, you should use the 'Test as role' feature in Power BI service. This allows you to see the data exactly as it would appear for the HR role, considering the dynamic RLS setup. Here is how you would proceed:

Navigate to the Power BI service and locate Model1.

Access the dataset settings for Model1.

Find the security/RLS settings where you configured the roles.

Use the 'Test as role' feature to simulate the report viewing experience as the HR role.

Review the data and the filters applied to ensure that the RLS is functioning correctly.

If discrepancies are found, adjust the RLS expressions or the role membership as needed.

asked 02/10/2024
Nikolaos Alexiou
32 questions

Question 63

Report
Export
Collapse

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?

Microsoft Power Bl Desktop
Microsoft Power Bl Desktop
Tabular Editor
Tabular Editor
ALM Toolkit
ALM Toolkit
DAX Studio
DAX Studio
Suggested answer: B

Explanation:

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.

asked 02/10/2024
David Murinda
42 questions

Question 64

Report
Export
Collapse

DRAG DROP

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

Report1 is slow to render. You suspect that an inefficient DAX query is being executed.

You need to identify the slowest DAX query, and then review how long the query spends in the formula engine as compared to the storage engine.

Which five 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 64 90477 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 64 90477 10022024015944000
asked 02/10/2024
mariam alsallal
40 questions

Question 65

Report
Export
Collapse

HOTSPOT

You have a Microsoft Power Bl semantic model.

You plan to implement calculation groups.

You need to create a calculation item that will change the context from the selected date to month-to-date (MTD).

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

NOTE: Each correct selection is worth one point.


Microsoft DP-600 image Question 65 90478 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 65 90478 10022024015944000
asked 02/10/2024
Katrina Allangba
40 questions

Question 66

Report
Export
Collapse

DRAG DROP

You are implementing two dimension tables named Customers and Products in a Fabric warehouse.

You need to use slowly changing dimension (SCO) to manage the versioning of data. The solution must meet the requirements shown in the following table.

Microsoft DP-600 image Question 66 90479 10022024015944000000

Which type of SCD should you use for each table? To answer, drag the appropriate SCD types to the correct tables. Each SCD type 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 66 90479 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 66 90479 10022024015944000
asked 02/10/2024
Lascelles Johnson
38 questions

Question 67

Report
Export
Collapse

You have a Fabric tenant that contains a lakehouse. You plan to use a visual query to merge two tables.

You need to ensure that the query returns all the rows that are present in both tables. Which type of join should you use?

left outer
left outer
right anti
right anti
full outer
full outer
left anti
left anti
right outer
right outer
inner
inner
Suggested answer: C

Explanation:

When you need to return all rows that are present in both tables, you use a full outer join. This type of join combines the results of both left and right outer joins and returns all rows from both tables, with matching rows from both sides where available. If there is no match, the result is NULL on the side of the join where there is no match.

asked 02/10/2024
Nivenl Surnder
33 questions

Question 68

Report
Export
Collapse

HOTSPOT

You have a Fabric tenant that contains lakehouse named Lakehousel. Lakehousel contains a Delta table with eight columns. You receive new data that contains the same eight columns and two additional columns.

You create a Spark DataFrame and assign the DataFrame to a variable named df. The DataFrame contains the new data. You need to add the new data to the Delta table to meet the following requirements:

* Keep all the existing rows.

* Ensure that all the new data is added to the table.

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


Microsoft DP-600 image Question 68 90481 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 68 90481 10022024015944000
asked 02/10/2024
Daniel Schiller
29 questions

Question 69

Report
Export
Collapse

You have a Fabric tenant that contains a lakehouse named Lakehouse1.

You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse.

What should you configure? (5)

the semantic model settings
the semantic model settings
the Lakehouse1 settings
the Lakehouse1 settings
the workspace settings
the workspace settings
the SQL analytics endpoint settings
the SQL analytics endpoint settings
Suggested answer: A

Explanation:

To prevent new tables added to Lakehouse1 from being automatically added to the default semantic model, you should configure the semantic model settings. There should be an option within the settings of the semantic model to include or exclude new tables by default. By adjusting these settings, you can control the automatic inclusion of new tables.

asked 02/10/2024
Vincent Scotti
29 questions

Question 70

Report
Export
Collapse

You have a Fabric tenant that contains a warehouse.

You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD).

You need to recommend which columns to add to the table. The columns must NOT already exist in the source.

Which three types of columns should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

an effective end date and time
an effective end date and time
a foreign key
a foreign key
a surrogate key
a surrogate key
a natural key
a natural key
an effective start date and time
an effective start date and time
Suggested answer: A, C, E

Explanation:

For a Type 2 slowly changing dimension (SCD), you typically need to add the following types of columns that do not exist in the source system:

An effective start date and time (E): This column records the date and time from which the data in the row is effective.

An effective end date and time (A): This column indicates until when the data in the row was effective. It allows you to keep historical records for changes over time.

A surrogate key (C): A surrogate key is a unique identifier for each row in a table, which is necessary for Type 2 SCDs to differentiate between historical and current records.

asked 02/10/2024
Paul Bryant
30 questions
Total 118 questions
Go to page: of 12
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow! has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit. What can you identify about the pickupLongitude column?
You have a Microsoft Power Bl report named Report1 that uses a Fabric semantic model. Users discover that Report1 renders slowly. You open Performance analyzer and identify that a visual named Orders By Date is the slowest to render. The duration breakdown for Orders By Date is shown in the following table. What will provide the greatest reduction in the rendering duration of Report1?
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?
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?
You have a Fabric tenant that contains a semantic model. You need to prevent report creators from populating visuals by using implicit measures. What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?
You have a Fabric tenant that contains a warehouse. You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD). You need to recommend which columns to add to the table. The columns must NOT already exist in the source. Which three types of columns should you recommend? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
HOTSPOT You have a Fabric tenant that contains lakehouse named Lakehousel. Lakehousel contains a Delta table with eight columns. You receive new data that contains the same eight columns and two additional columns. You create a Spark DataFrame and assign the DataFrame to a variable named df. The DataFrame contains the new data. You need to add the new data to the Delta table to meet the following requirements: * Keep all the existing rows. * Ensure that all the new data is added to the table. How should you complete the code? To answer, select the appropriate options in the answer area.
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.