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

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?

• Data pipeline
• Environment
• KQL queryset
• Dataflow Gen2

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 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 have a Fabric warehouse named DW1 that loads data by using a data pipeline named Pipeline1. Pipeline1 uses a Copy data activity with a dynamic SQL source. Pipeline1 is scheduled to run every 15 minutes.You discover that Pipeline1 keeps failing.You need to identify which SQL query was executed when the pipeline failed. What should you do?

• From Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON.
• From Monitoring hub, select the latest failed run of Pipeline1, and then view the input JSON.
• From Real-time hub, select Fabric events, and then review the details of Microsoft.Fabric.ItemReadFailed.
• From Real-time hub, select Fabric events, and then review the details of Microsoft. Fabric.ItemUpdateFailed.

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 have a Fabric notebook named Notebook1 that has been executing successfully for the last week.During the last run, Notebook1executed nine jobs. You need to view the jobs in a timeline chart.What should you use?

• Real-Time hub
• Monitoring hub
• the job history from the application run
• Spark History Server
• the run series from the details of the application run

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1. You plan to deploy Warehouse1 to a new workspace named Workspace2.As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort.What should you use?

• a database project
• a deployment pipeline
• a Python script
• a T-SQL script

You have a Fabric deployment pipeline that uses three workspaces named Dev, Test, and Prod. You need to deploy an eventhouse as part of the deployment process.What should you use to add the eventhouse to the deployment process?

• GitHub Actions
• a deployment pipeline
• an Azure DevOps pipeline

You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 reads data into a DataFrame from a table named Table1 and applies transformation logic. The data from the DataFrame is then written to a new Delta table named Table2 by using a merge operation.You need to consolidate the underlying Parquet files in Table1. Which command should you run?

• VACUUM
• BROADCAST
• OPTIMIZE
• CACHE

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:Orders Customer EmployeeThe 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 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.