Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You need to mirror data from an existing Azure SQL Database to Microsoft Fabric. Before you can create the mirror, which requirement must the source Azure SQL Database meet?
Upgrade the database to the General Purpose or a higher service tier so that Change Data Capture is available.
Remove any active geo-replication links from the database before you start the initial snapshot.
Create an Azure Storage account in the same region to hold the database change feed.
Move the database out of its elastic pool so that mirroring can obtain an exclusive lock during synchronization.
Microsoft Fabric mirroring captures inserts, updates, and deletes by enabling Change Data Capture (CDC) on the source Azure SQL Database. CDC is supported only in the General Purpose, Business Critical, and Hyperscale service tiers. Databases that run in the Basic or Standard (S0-S12) tiers do not offer CDC, so you must first move the database to at least the General Purpose tier. No separate Azure Storage account, elastic-pool change, or geo-replication modification is required for mirroring.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Change Data Capture (CDC)?
Open an interactive chat with Bash
Why does Microsoft Fabric mirroring require General Purpose or higher service tiers?
Open an interactive chat with Bash
How is data synchronized using CDC in Microsoft Fabric?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Ingest and transform data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .