DP-300 Configure and manage automation of tasks Practice Question
You need to automate the process of refreshing a development copy of an Azure SQL Database from a production backup every night. The production database is in the West US region, and the dev database is in East US. What is the most cost-effective method?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the Restore-AzSqlDatabase PowerShell cmdlet to restore the production database to the dev server using a point-in-time backup from the same day.
Azure SQL Database supports point-in-time restore (PITR) to a different server and region. Restore-AzSqlDatabase can automate this process using a production backup from the same day, which is cost-effective as it only uses existing backups without additional replication costs. Options A and C involve manual steps or extra services, while option B is for active geo-replication, which incurs ongoing costs and is not designed for nightly refresh.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Export the production database to a BACPAC file, store it in Azure Blob Storage, and import it to dev using a Data Factory pipeline.
Why it's wrong here
BACPAC export/import is slower and more expensive for large databases.
- ✗
Configure active geo-replication between production and dev, then initiate a planned failover each night.
Why it's wrong here
Geo-replication is for continuous replication, not nightly refresh, and incurs ongoing costs.
- ✗
Use Azure Data Studio to export the database as a script and run it on the dev server.
Why it's wrong here
Not automated and not practical for large databases.
- ✓
Use the Restore-AzSqlDatabase PowerShell cmdlet to restore the production database to the dev server using a point-in-time backup from the same day.
Why this is correct
Point-in-time restore is cost-effective and can be automated.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.