Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Microsoft DP-600 - Implementing Analytics Solutions Using Microsoft Fabric

Page: 2 / 3
Total 137 questions

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?

A.

DAX Formatter in DAX Studio

B.

Model view in Microsoft Power Bl Desktop

C.

Model explorer in Microsoft Power Bl Desktop

D.

Best Practice Analyzer in Tabular Editor

You have a Microsoft Power B1 Premium Per User (PPU) workspace that contains a semantic model.

You have an Azure App Service app named App1 that modifies row-level security (RLS) for the model by using the XMLA endpoint. App1 requires users to sign in by using their Microsoft Entra credentials to access the XMLA endpoint. You need to configure App1 to use a service account to access the model. What should you do first?

A.

Add a managed identity to the workspace.

B.

Add a managed identity to App1.

C.

Upgrade the workspace to Premium capacity.

D.

Modify the XMLA Endpoint setting.

You have a Fabric tenant that contains a warehouse.

Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse.

What should you use to identify whether throttling is occurring?

A.

the Capacity settings

B.

the Monitoring hub

C.

dynamic management views (DMVs)

D.

the Microsoft Fabric Capacity Metrics app

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)

A.

the semantic model settings

B.

the Lakehouse1 settings

C.

the workspace settings

D.

the SQL analytics endpoint settings

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.

Which type of data store should you recommend in the AnalyticsPOC workspace?

A.

a data lake

B.

a warehouse

C.

a lakehouse

D.

an external Hive metaStore

You need to create a DAX measure to calculate the average overall satisfaction score.

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

NOTE: Each correct selection is worth one point.

You need to resolve the issue with the pricing group classification.

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.

You need to recommend a solution to prepare the tenant for the PoC.

Which two actions should you recommend performing from the Fabric Admin portal? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

A.

Enable the Users can try Microsoft Fabric paid features option for specific security groups.

B.

Enable the Allow Azure Active Directory guest users to access Microsoft Fabric option for specific security groups.

C.

Enable the Users can create Fabric items option and exclude specific security groups.

D.

Enable the Users can try Microsoft Fabric paid features option for the entire organization.

E.

Enable the Users can create Fabric items option for specific security groups.

You to need assign permissions for the data store in the AnalyticsPOC workspace. The solution must meet the security requirements.

Which additional permissions should you assign when you share the data store? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.