DP-300 Configure and manage automation of tasks Practice Question
Which TWO actions are required to automate the export of an Azure SQL Database to a BACPAC file on a monthly basis? (Choose two.)
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 Azure Automation or a scheduled Azure Function to call the Export-AzSqlDatabase cmdlet.
To automate the export of an Azure SQL Database to a BACPAC file on a monthly basis, you need a storage location for the file and an automation method. Option B is correct because Azure Automation or an Azure Function can trigger the Export-AzSqlDatabase cmdlet or REST API to perform the export on a schedule. Option E is correct because an Azure Storage account with a container is required to store the resulting BACPAC file. Option A is incorrect because LTR policy is for automated backups, not export to BACPAC. Option C is incorrect because a SQL Server on Azure VM is not needed; the export is initiated directly against the Azure SQL Database logical server. Option D is incorrect because SSIS is an ETL tool that is not necessary for a simple export operation; the export can be done via PowerShell, CLI, or REST API without SSIS.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Configure long-term retention (LTR) policy for the database.
Why it's wrong here
LTR retains backups, but does not export a BACPAC; it's a different feature.
- ✓
Use Azure Automation or a scheduled Azure Function to call the Export-AzSqlDatabase cmdlet.
Why this is correct
Automation is needed to run the export on a recurring schedule.
- ✗
Deploy a SQL Server on Azure VM to run the export command.
Why it's wrong here
The export can be triggered from Azure SQL Database directly without a VM.
- ✗
Install SQL Server Integration Services (SSIS) on a virtual machine.
Why it's wrong here
SSIS is not required; the export is a built-in Azure SQL Database feature.
- ✓
Create an Azure Storage account with a container to store the BACPAC file.
Why this is correct
The BACPAC is exported to an Azure Storage blob container.
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.
Key term
SQL Server on Azure VM
SQL Server on Azure VM is a cloud service that lets you run Microsoft SQL Server software inside a virtual machine in Microsoft Azure, giving you full control over the database environment just like you would have on your own physical server.
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.