Free Implementing Data Engineering Solutions Using Microsoft Fabric Exam DP-700 Exam Practice Test

You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives.You plan to implement row-level security (RLS).You need to ensure that the sales representatives can see only their respective data. Which warehouse object do you require to implement RLS?

• ISTORED PROCEDURE
• CONSTRAINT
• SCHEMA
• FUNCTION

You have a Fabric workspace named Workspace1 that contains a warehouse named DW1 and a data pipeline named Pipeline1.You plan to add a user named User3 to Workspace1.You need to ensure that User3 can perform the following actions:View all the items in Workspace1. Update the tables in DW1.The solution must follow the principle of least privilege.You already assigned the appropriate object-level permissions to DW1. Which workspace role should you assign to User3?

• Admin
• Member
• Viewer
• Contributor

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 Workspace

• 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.

You need to populate the MAR1 data in the bronze layer.Which two types of activities should you include in the pipeline? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

• ForEach
• Copy data
• WebHook
• Stored procedure

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures.You discover that the daily data load takes longer than expected.You need to monitor Warehouse1 to identify the names of users that are actively running queries. Which view should you use?

• sys.dm_exec_connections
• sys.dm_exec_requests
• queryinsights.long_running_queries
• queryinsights.frequently_run_queries
• sys.dm_exec_sessions

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

• Create a Dataflow Gen2 dataflow.
• Create a shortcut.
• Enable external data sharing.
• Create a data pipeline.

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?

• only data added to new databases that are added to the eventhouse
• only the existing data in the eventhouse
• no data
• both new data and existing data in the eventhouse
• only new data added to the eventhouse

You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse.You need to remove files that are older than seven days and are no longer in use. Which command should you run?

• VACUUM
• COMPUTE
• OPTIMIZE
• CLONE

You have five Fabric workspaces.You are monitoring the execution of items by using Monitoring hub. You need to identify in which workspace a specific item runs.Which column should you view in Monitoring hub?

• Start time
• Capacity
• Activity name
• Submitter
• Item type
• Job type
• Location

You have a Fabric workspace that contains a lakehouse named Lakehouse1.In an external data source, you have data files that are 500 GB each. A new file is added every day. You need to ingest the data into Lakehouse1 without applying any transformations. The solution must meet the following requirementsTrigger the process when a new file is added. Provide the highest throughput.Which type of item should you use to ingest the data?

• Event stream
• Dataflow Gen2
• Streaming dataset
• Data pipeline