Home / Microsoft / DP-600

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

Question list

List of questions

Question 21

(0)

You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dawset named DS1. You need to ensure read-write access to DS1 is available by

Question 22

(0)

You have a Fabric tenant that contains a workspace named Workspace^ Workspacel is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability to create and pub

Question 23

(0)

You are creating a semantic model in Microsoft Power Bl Desktop. You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Microsoft Visual Stud

Question 24

(0)

HOTSPOT You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains three schemas named schemaA, schemaB. and schemaC You need to ensure that a user named User1 can tr

Question 25

(0)

You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements: * Ensure that the developers can deploy items to the workspaces for Developme

Question 26

(0)

You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows. You have a Microsoft Power Bl report named Report1 that uses the m

Question 27

(0)

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power Bl semantic model named Modell that uses the CSV files as a data source. Yo

Question 28

(0)

You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale-out for a semantic model. What should you do first?

Question 29

(0)

You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS). You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse. When use

Question 30

(0)

You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales. You need to create a diagram of the

Related questions

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?

HOTSPOT Which workspace rote assignments should you recommend for ResearchReviewersGroupl and ResearchReviewersGroupZ? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

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?

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.

HOTSPOT You need to design a semantic model for the customer satisfaction report. Which data source authentication method and mode should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

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?

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.

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?

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 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?

Question 21

You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dawset named DS1. You need to ensure read-write access to DS1 is available by using the XMLA endpoint. What should be modified first?

the DS1 settings

the WS1 settings

the C1 settings

the Tenant1 settings

Show Answer Comment (0)

Question 22

You have a Fabric tenant that contains a workspace named Workspace^ Workspacel is assigned to a Fabric capacity.

You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of least privilege.

Which three actions in the Fabric Admin portal should you include in the recommendation? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises datasets to Enabled

From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled

From the Tenant settings, select Users can edit data models in the Power Bl service.

From the Capacity settings, set XMLA Endpoint to Read Write

From the Tenant settings, set Users can create Fabric items to Enabled

From the Tenant settings, enable Publish to Web

Show Answer Comment (0)

Question 23

You are creating a semantic model in Microsoft Power Bl Desktop.

You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Microsoft Visual Studio Code.

You need to save the semantic model to a file.

Which file format should you use?

PBIP

PBIX

PBIT

PBIDS

Show Answer Comment (0)

Question 24

HOTSPOT

You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains three schemas named schemaA, schemaB. and schemaC

You need to ensure that a user named User1 can truncate tables in schemaA only.

How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 25

You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements:

* Ensure that the developers can deploy items to the workspaces for Development and Test.

* Prevent the developers from deploying items to the workspace for Production.

* Follow the principle of least privilege.

Which three levels of access should you assign to the developers? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Build permission to the production semantic models

Admin access to the deployment pipeline

Viewer access to the Development and Test workspaces

Viewer access to the Production workspace

Contributor access to the Development and Test workspaces

Contributor access to the Production workspace

Show Answer Comment (0)

Question 26

You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows.

You have a Microsoft Power Bl report named Report1 that uses the model. Report! contains visuals on multiple pages.

You need to reduce the query execution time for the visuals on all the pages.

What are two features that you can use? Each correct answer presents a complete solution.

NOTE: Each correct answer is worth one point.

user-defined aggregations

automatic aggregation

query caching

OneLake integration

Show Answer Comment (0)

Question 27

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily.

You create a Microsoft Power Bl semantic model named Modell that uses the CSV files as a data source. You configure incremental refresh for Model 1 and publish the model to a Premium capacity in the Fabric tenant.

When you initiate a refresh of Model1, the refresh fails after running out of resources.

What is a possible cause of the failure?

Query folding is occurring.

Only refresh complete days is selected.

XMLA Endpoint is set to Read Only.

Query folding is NOT occurring.

The data type of the column used to partition the data has changed.

Show Answer Comment (0)

Question 28

You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale-out for a semantic model. What should you do first?

At the semantic model level, set Large dataset storage format to Off.

At the tenant level, set Create and use Metrics to Enabled.

At the semantic model level, set Large dataset storage format to On.

At the tenant level, set Data Activator to Enabled.

Show Answer Comment (0)

Question 29

You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS). You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse. When users interact with a report built from the model, which mode will be used by the DAX queries?

DirectQuery

Dual

Direct Lake

Import

Show Answer Comment (0)

Question 30

You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales. You need to create a diagram of the model. The diagram must contain only the Sales table and related tables. What should you use from Microsoft Power Bl Desktop?

data categories

Data view

Model view

DAX query view

Show Answer Comment (0)

Total 102 questions

1 2 3 4 5

Go to page: of 11