You need to ensure that usage of the data in the Amazon S3 bucket meets the technical requirements.What should you do?

Create a shortcut and ensure that caching is disabled for the workspace.

Create a workspace identity and enable high concurrency for the notebooks.

Create a shortcut and ensure that caching is disabled for the workspace.

Create a workspace identity and use the identity in a data pipeline.

Create a shortcut and ensure that caching is enabled for the workspace.

You need to implement the solution for the book reviews.Which should you do?

Create a Dataflow Gen2 dataflow.

You need to resolve the sales data issue. The solution must minimize the amount of data transferred.What should you do?

Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month.

Spilt the dataflow into two dataflows.

Configure scheduled refresh for the dataflow.

Configure incremental refresh for the dataflow. Set Store rows from the past to 1 Month.

Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Year.

Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month.

You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.DW1 contains a single fact table that has grown from 200million rows to 500million rows during the past year.You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.Users report that the performance of some of the reports has degraded over time and some visuals show errors.You need to resolve the performance issues. The solution must meet the following requirements:Provide the best query performance.Minimize operational costs.Which should you do?

Increase the capacity. C Enable V-Order

Modify the surrogate keys to use a different data type.

You have a Fabric workspace named Workspace1 that contains a notebook named Notebook1.In Workspace1, you create a new notebook named Notebook2.You need to ensure that you can attach Notebook2 to the same Apache Spark session as Notebook1.What should you do?

Enable high concurrency for notebooks.

Enable dynamic allocation for the Spark pool.

Increase the number of executors.

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:OrdersCustomerEmployeeThe Employee table contains Personally Identifiable Information (PII).A data engineer is building a workflow that requires writing data to the Customer table, however, the user does NOT have the elevated permissions required to view the contents of the Employee table.You need to ensure that the data engineer can write data to the Customer table without reading data from the Employee table.Which three actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Share Lakehouse1 with the data engineer.

Assign the data engineer the Contributor role for Workspace1.

Migrate the Employee table from Lakehouse1 to Lakehouse2.

Share Lakehouse1 with the data engineer.

Assign the data engineer the Contributor role for Workspace2.

Assign the data engineer the Viewer role for Workspace2.

Assign the data engineer the Contributor role for Workspace1.

Migrate the Employee table from Lakehouse1 to Lakehouse2.

Create a new workspace named Workspace2 that contains a new lakehouse named Lakehouse2.

Assign the data engineer the Viewer role for Workspace1.

You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.Users report that from OneLake file explorer, they cannot see the data from the eventhouse.You enable OneLake availability for the eventhouse.What will be copied to OneLake?

both new data and existing data in the eventhouse

only data added to new databases that are added to the eventhouse

only the existing data in the eventhouse

both new data and existing data in the eventhouse

only new data added to the eventhouse

You have a Fabric workspace named Workspace1.You plan to integrate Workspace1 with Azure DevOps.You will use a Fabric deployment pipeline named deployPipeline1 to deploy items from Workspace1 to higher environment workspaces as part of a medallion architecture. You will run deployPipeline1 by using an API call from an Azure DevOps pipeline.You need to configure API authentication between Azure DevOps and Fabric.Which type of authentication should you use?

Microsoft Entra username and password

You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.A user named User1 wants to use SQL to analyze the data in Lakehouse1.You need to configure access for User1. The solution must meet the following requirements:What should you do?

Assign User1 the Viewer role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.

Share Lakehouse1 with User1 directly and select Read all SQL endpoint data.

Assign User1 the Viewer role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.

Share Lakehouse1 with User1 directly and select Build reports on the default semantic model.

Assign User1 the Member role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.

You have two Fabric workspaces named Workspace1 and Workspace2.You have a Fabric deployment pipeline named deployPipeline1 that deploys items from Workspace1 to Workspace2. DeployPipeline1 contains all the items in Workspace1.You recently modified the items in Workspaces1.The workspaces currently contain the items shown in the following table. Items in Workspace1 that have the same name as items in Workspace2 are currently paired.You need to ensure that the items in Workspace1 overwrite the corresponding items in Workspace2. The solution must minimize effort.What should you do?

Run deployPipeline1 without modifying the items in Workspace2.

Delete all the items in Workspace2, and then run deployPipeline1.

Rename each item in Workspace2 to have the same name as the items in Workspace1.

Back up the items in Workspace2, and then run deployPipeline1.

Run deployPipeline1 without modifying the items in Workspace2.

You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1.You have a deployment pipeline named deployPipeline1 that deploys Workspace1 to Workspace2.You restructure Workspace1 by adding a folder named Folder1 and moving Pipeline1 to Folder1.You use deployPipeline1 to deploy Workspace1 to Workspace2.What occurs to Workspace2?

Folder1 is created, Pipeline1 moves to Folder1, and Lakehouse1 is deployed.

Only Pipeline1 and Lakehouse1 are deployed.

Folder1 is created, and Pipeline1 and Lakehouse1 move to Folder1.

Only Folder1 is created and Pipeline1 moves to Folder1.

You have a Fabric workspace that contains a warehouse named DW1. DW1 is loaded by using a notebook named Notebook1.You need to identify which version of Delta was used when Notebook1 was executed.What should you use?

the Microsoft Fabric Capacity Metrics app

You have a Fabric workspace that contains a semantic model named Model1.You need to dynamically execute and monitor the refresh progress of Model1.What should you use?

dynamic management views in Microsoft SQL Server Management Studio

dynamic management views in Azure Data Studio

Microsoft DP-700 Practice Test 1 - Free Online Exam Prep & Questions

Question 1 / 40

You need to ensure that the data analysts can access the gold layer lakehouse.

What should you do?

Add the DataAnalyst group to the Viewer role for WorkspaceA.

Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.

Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.

Share the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.

Show Case Study

Comment (0)

Microsoft DP-700 Practice Test 1

Question

Microsoft DP-700 Practice Tests

Practice Tests