Microsoft DP-600 Exam Practice Test Instant Access

Question 1

You have a Fabric tenant that contains a workspace named Workspace"!. You plan to deploy a semantic model named Model 1 by using the XMLA endpoint.

You need to optimize the deployment of Model!. The solution must minimize how long it takes to deploy Modell. What should you do in Workspace1?

ASelect Small semantic model storage format.

BSelect Users can edit data models in the Power Bl service.

CSelect Large semantic model storage format

DSet Enable Cache for Shortcuts to On.

Answer : C

Question 2

You have a Fabric workspace named Workspacel that contains a lakehouse named Lakehousel. Lakehousel contains a table named Tablel. Table 1 contains the following data.

You need to perform the following actions:

* Load the data from Table! into a star schema.

* Create a product dimension table named DimProduct and a fact table named FactSales.

Which three columns should you include in DimProduct?

AProductColor, ProductID, and ProductName.

BProductName, SalesAmount, andTransactionlD

CDate, ProductID, andTransactionlD.

DProductID, ProductName, and SalesAmount

Answer : A

Question 3

You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data.

You need to identify the min and max values for each column in the query results.

Which three Data view options should you select? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

AShow column quality details

BShow column profile in details pane

CEnable details pane

DShow column value distribution

EEnable column profile

Answer : B, D, E

Question 4

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?

ATable. FuzzyGroup

BTable.Profile

CTable.View

DTable.Schema

Answer : B

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.

Question 5

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?

APBIP

BPBIT

CPBIX

DPBIDS

Answer : C

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.

Question 6

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses Pro license mode and contains a semantic model named Model1. You need to ensure that Modell supports XMLA connections. Which setting should you modify?

AEnable Cache for Shortcuts

BLicense mode

CEnforce strict access control for all data connection types

DUsers can edit data models in the Power B1 service

Answer : B

Question 7

You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode.

You suspect that some DAX queries load unnecessary columns into memory.

You need to identify the frequently used columns that are loaded into memory.

What are two ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct answer is worth one point.

AUse the Analyze in Excel feature.

BUse the Vertipaq Analyzer tool.

CQuery the $system.discovered_STORAGE_TABLE_COLUMN-iN_SEGMeNTS dynamic management view (DMV).

DQuery the discover_hehory6Rant dynamic management view (DMV).

Answer : B, C

The Vertipaq Analyzer tool (B) and querying the $system.discovered_STORAGE_TABLE_COLUMNS_IN_SEGMENTS dynamic management view (DMV) (C) can help identify which columns are frequently loaded into memory. Both methods provide insights into the storage and retrieval aspects of the semantic model. Reference = The Power BI documentation on Vertipaq Analyzer and DMV queries offers detailed guidance on how to use these tools for performance analysis.

Microsoft DP-600 Implementing Analytics Solutions Using Microsoft Fabric Exam Practice Test