Question 386 of 919
DP-300 BACPAC Practice Question
You are a database administrator for an e-learning platform that uses Azure SQL Database with the General Purpose tier. The database stores course content and user progress. You need to automate the process of exporting the database schema (without data) to a BACPAC file every week for version control. The BACPAC file must be stored in an Azure Blob Storage container with a retention policy of 30 days. The automation must use Azure native services and should not require manual intervention. What should you do?
⚠ Common exam trap
Candidates may incorrectly assume that the New-AzSqlDatabaseExport cmdlet has a -SchemaOnly parameter, but it does not exist. The correct approach is to use SqlPackage.exe with /p:ExtractAllTableData=False inside a runbook.
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
✓
Create an Azure Automation runbook with PowerShell that uses SqlPackage.exe with /p:ExtractAllTableData=False to export the schema-only BACPAC to a Blob Storage container. Schedule the runbook to run weekly.
Azure Automation runbooks can execute PowerShell scripts that use the SqlPackage.exe utility to export a schema-only BACPAC file. The command 'SqlPackage.exe /Action:Export /SourceServerName:<server> /SourceDatabaseName:<database> /TargetFile:<bacpac> /p:ExtractAllTableData=False' creates a BACPAC containing only the schema. The runbook can be scheduled weekly using an Azure Automation schedule. Option A is incorrect because Azure Data Factory's Copy activity is designed for data movement, not schema exports. Option B is incorrect because Elastic Database Jobs runs T-SQL scripts and cannot produce BACPAC files. Option D is incorrect because SQL Agent is not available in Azure SQL Database.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Azure Data Factory with a Copy activity to export the database schema to a BACPAC file in Blob Storage.
Why it's wrong here
Incorrect. Azure Data Factory's Copy activity is designed for moving data between sources and sinks, not for creating BACPAC files of database schema.
- ✗
Use Elastic Database Jobs to run a T-SQL script that uses the BACKUP DATABASE command to a URL.
Why it's wrong here
Incorrect. Elastic Database Jobs can run T-SQL scripts against multiple databases but cannot export BACPAC files.
- ✓
Create an Azure Automation runbook with PowerShell that uses SqlPackage.exe with /p:ExtractAllTableData=False to export the schema-only BACPAC to a Blob Storage container. Schedule the runbook to run weekly.
Why this is correct
Correct. An Azure Automation runbook can invoke SqlPackage.exe with the /p:ExtractAllTableData=False option to create a schema-only BACPAC, and the runbook can be scheduled weekly.
- ✗
Create a SQL Agent job on the database to run SqlPackage.exe.
Why it's wrong here
Incorrect. SQL Agent is not available in Azure SQL Database; it is only available in SQL Server on-premises or on Azure VMs.
Quick reference
Azure Blob Storage Tier Comparison
| Tier | Storage Cost | Retrieval Cost | Latency | Use Case |
|---|---|---|---|---|
| Hot | Highest | Lowest | Immediate | Active data, frequent reads |
| Cool | Lower | Higher | Immediate | Data accessed < once / month |
| Cold | Lower still | Higher | Immediate | Data accessed < once / quarter |
| Archive | Lowest | Highest + rehydration delay | Hours | Long-term compliance retention |
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 21, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.