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

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

Add to Whishlist

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

Become a Premium Member for full access
  Unlock Premium Member

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.


Become a Premium Member for full access
  Unlock Premium Member

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.

Become a Premium Member for full access
  Unlock Premium Member

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.

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member
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.