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

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

List of questions

Question 21

Report
Export
Collapse

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 DS1 settings
the WS1 settings
the WS1 settings
the C1 settings
the C1 settings
the Tenant1 settings
the Tenant1 settings
Suggested answer: C

Explanation:

To ensure read-write access to DS1 is available by using the XMLA endpoint, the C1 settings (which refer to the capacity settings) should be modified first. XMLA endpoint configuration is a capacity feature, not specific to individual datasets or workspaces. Reference = The configuration of XMLA endpoints in Power BI capacities is detailed in the Power BI documentation on dataset management.

asked 02/10/2024
Premier Lane
36 questions

Question 22

Report
Export
Collapse

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 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, 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 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 Capacity settings, set XMLA Endpoint to Read Write
From the Tenant settings, set Users can create Fabric items to Enabled
From the Tenant settings, set Users can create Fabric items to Enabled
From the Tenant settings, enable Publish to Web
From the Tenant settings, enable Publish to Web
Suggested answer: A, C, D

Explanation:

For users to create and publish custom Direct Lake semantic models using external tools, following the principle of least privilege, the actions to be included are enabling XMLA Endpoints (A), editing data models in Power BI service (C), and setting XMLA Endpoint to Read-Write in the capacity settings (D). Reference = More information can be found in the Admin portal of the Power BI service documentation, detailing tenant and capacity settings.

asked 02/10/2024
jose fajardo
34 questions

Question 23

Report
Export
Collapse

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
PBIP
PBIX
PBIX
PBIT
PBIT
PBIDS
PBIDS
Suggested answer: B

Explanation:

When saving a semantic model to a file that can be edited using the Tabular Model Scripting Language (TMSL) extension for Visual Studio Code, the PBIX (Power BI Desktop) file format is the correct choice. The PBIX format contains the report, data model, and queries, and is the primary file format for editing in Power BI Desktop. Reference = Microsoft's documentation on Power BI file formats and Visual Studio Code provides further clarification on the usage of PBIX files.

asked 02/10/2024
Mikael Klingebrant
30 questions

Question 24

Report
Export
Collapse

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.


Microsoft DP-600 image Question 24 90437 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 24 90437 10022024015944000
asked 02/10/2024
Nardos Tadele
30 questions

Question 25

Report
Export
Collapse

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
Build permission to the production semantic models
Admin access to the deployment pipeline
Admin access to the deployment pipeline
Viewer access to the Development and Test workspaces
Viewer access to the Development and Test workspaces
Viewer access to the Production workspace
Viewer access to the Production workspace
Contributor access to the Development and Test workspaces
Contributor access to the Development and Test workspaces
Contributor access to the Production workspace
Contributor access to the Production workspace
Suggested answer: B, D, E

Explanation:

To meet the requirements, developers should have Admin access to the deployment pipeline (B), Contributor access to the Development and Test workspaces (E), and Viewer access to the Production workspace (D). This setup ensures they can perform necessary actions in development and test environments without having the ability to affect production. Reference = The Power BI documentation on workspace access levels and deployment pipelines provides guidelines on assigning appropriate permissions.

asked 02/10/2024
Freddy KUBIAK
49 questions

Question 26

Report
Export
Collapse

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
user-defined aggregations
automatic aggregation
automatic aggregation
query caching
query caching
OneLake integration
OneLake integration
Suggested answer: A, B

Explanation:

User-defined aggregations (A) and query caching (C) are two features that can help reduce query execution time. User-defined aggregations allow precalculation of large datasets, and query caching stores the results of queries temporarily to speed up future queries. Reference = Microsoft Power BI documentation on performance optimization offers in-depth knowledge on these features.

asked 02/10/2024
JULIAN SSEMALULU
21 questions

Question 27

Report
Export
Collapse

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.
Query folding is occurring.
Only refresh complete days is selected.
Only refresh complete days is selected.
XMLA Endpoint is set to Read Only.
XMLA Endpoint is set to Read Only.
Query folding is NOT occurring.
Query folding is NOT occurring.
The data type of the column used to partition the data has changed.
The data type of the column used to partition the data has changed.
Suggested answer: E

Explanation:

A possible cause for the failure is that query folding is NOT occurring (D). Query folding helps optimize refresh by pushing down the query logic to the source system, reducing the amount of data processed and transferred, hence conserving resources. Reference = The Power BI documentation on incremental refresh and query folding provides detailed information on this topic.

asked 02/10/2024
Quintin van Rooyen
44 questions

Question 28

Report
Export
Collapse

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 semantic model level, set Large dataset storage format to Off.
At the tenant level, set Create and use Metrics to Enabled.
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 semantic model level, set Large dataset storage format to On.
At the tenant level, set Data Activator to Enabled.
At the tenant level, set Data Activator to Enabled.
Suggested answer: C

Explanation:

To enable scale-out for a semantic model, you should first set Large dataset storage format to On (C) at the semantic model level. This configuration is necessary to handle larger datasets effectively in a scaled-out environment. Reference = Guidance on configuring large dataset storage formats for scale-out is available in the Power BI documentation.

asked 02/10/2024
Frans Gafane
33 questions

Question 29

Report
Export
Collapse

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
DirectQuery
Dual
Dual
Direct Lake
Direct Lake
Import
Import
Suggested answer: A

Explanation:

When users interact with a report built from a Direct Lake semantic model that uses row-level security (RLS), the DAX queries will operate in DirectQuery mode (A). This is because the model directly queries the underlying data source without importing data into Power BI. Reference = The Power BI documentation on DirectQuery provides detailed explanations of how RLS and DAX queries function in this mode.

asked 02/10/2024
Ashad Conley
38 questions

Question 30

Report
Export
Collapse

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 categories
Data view
Data view
Model view
Model view
DAX query view
DAX query view
Suggested answer: C

Explanation:

To create a diagram that contains only the Sales table and related tables, you should use the Model view (C) in Microsoft Power BI Desktop. This view allows you to visualize and manage the relationships between tables within your semantic model. Reference = Microsoft Power BI Desktop documentation outlines the functionalities available in Model view for managing semantic models.

asked 02/10/2024
EVA LITA
40 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.