Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You need a Microsoft Fabric pipeline to load data daily from an Azure SQL Database table into a Delta table in a Lakehouse. The source has an integer LastModifiedVersion column that increases on each change. The load must copy only rows modified since the previous run and merge them into the Delta table, inserting new rows and updating matches. Which design meets the requirements with the least custom code?

  • A stored procedure activity that calls a SQL stored procedure to read changed rows and write them into the Lakehouse by using a PolyBase external table

  • A single Copy activity that uses LastModifiedVersion as a watermark column and the Upsert update method when writing to the Lakehouse Delta table

  • A pipeline that creates a shortcut to the source table and lets reports read the data directly through the shortcut

  • A pipeline that copies the full source table into a staging Lakehouse folder and then runs a Spark notebook with a MERGE INTO statement

Microsoft Fabric Data Engineer Associate DP-700
Ingest and transform data
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