Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You build a Microsoft Fabric pipeline that copies new rows from an Azure SQL Database table into a destination table in a Fabric lakehouse. The Azure SQL linked service authenticates by using the workspace's managed identity. When you trigger the pipeline, the Copy activity fails immediately and returns error code SqlErrorNumber 262 with the message "Permission denied in database 'Sales' to object 'Orders'." What should you do to resolve the failure so that the pipeline can complete successfully?

  • Grant the workspace's managed identity INSERT permission on dbo.Orders in the Sales database.

  • Grant the workspace's managed identity SELECT permission on dbo.Orders or add it to the db_datareader role in the Sales database.

  • Enable staged copy with auto-create table in the Copy activity settings.

  • Replace the lakehouse sink with a Data Lake Storage Gen2 linked service.

Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize an analytics solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot