20+ practice questions focused on Configure and manage automation of tasks — one of the most tested topics on the Microsoft Azure Database Administrator Associate DP-300 exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Configure and manage automation of tasks PracticeYou manage an Azure SQL Database that supports a critical application. You need to automate the process of rebuilding indexes that have fragmentation above 30% on a weekly basis. The solution must use built-in database features and minimize performance impact. What should you do?
Explanation: Elastic Jobs in Azure SQL Database allow you to schedule T-SQL scripts across multiple databases. You can create a job that runs a script to identify indexes with fragmentation above 30% and rebuild them. This uses built-in database features (Elastic Jobs are part of Azure SQL Database) and minimizes performance impact by allowing you to schedule the job during off-peak hours. Option A is not available in Azure SQL Database (single database) as SQL Agent is only supported in Azure SQL Managed Instance. Option B uses Azure Automation, which is an external service and not a built-in database feature. Option C is incorrect because automatic tuning's 'Create index' option creates new indexes, not rebuilds existing ones, and 'Force plan' stabilizes query plans but does not address fragmentation.
A company uses Azure SQL Database for a critical application. They need to automate the process of exporting a database to a storage account every night, ensuring the export is consistent. The solution must minimize administrative overhead. What should they use?
Explanation: Azure Automation runbooks can execute PowerShell cmdlets like Export-AzureRmSqlDatabase (or the newer Export-AzSqlDatabase) to perform a consistent export of an Azure SQL Database to a storage account. By scheduling the runbook to run nightly, you automate the export with minimal administrative overhead, as the export operation uses database snapshots to ensure consistency without requiring complex orchestration.
A company uses Azure SQL Managed Instance. They want to automate backups to a storage account for long-term retention beyond the default 35 days. What should they use?
Explanation: It uses an Azure Automation runbook to schedule the Backup-SqlDatabase cmdlet with -CopyOnly, creating copy-only backups to a storage account. This provides long-term retention beyond the default 35 days by automating the backup process to Azure Blob Storage. While Azure SQL Managed Instance also supports native long-term retention policies via Azure CLI or PowerShell (Set-AzSqlInstanceDatabaseBackupLongTermRetentionPolicy), that approach is not listed among the options. Option D is the only option that offers automated backup to a storage account for retention beyond 35 days.
You are the database administrator for a large e-commerce company. The company uses Azure SQL Database for its product catalog, which is updated frequently during business hours. To maintain query performance, you have automated index maintenance using Elastic Database Jobs. The job runs every night at 2:00 AM and rebuilds indexes with a fill factor of 80. However, you notice that the job is taking longer than expected, often running until 6:00 AM, and sometimes it fails due to timeouts. You also observe that index fragmentation is still high after the job completes. The database is in the General Purpose service tier with 100 DTUs. Which action should you take to improve the situation?
Explanation: Reorganizing indexes is a less resource-intensive operation than rebuilding, which reduces the job duration and avoids timeouts. Additionally, using a lower degree of parallelism (MAXDOP) prevents excessive resource contention, which is critical for a General Purpose database with only 100 DTUs. Reorganizing also addresses fragmentation without the overhead of a full rebuild, making it more suitable for the limited resources and nightly maintenance window.
Refer to the exhibit. You run this KQL query in Azure Monitor Log Analytics for an Azure SQL Database. What type of events does the query return?
Explanation: Action_id_s == 'AUSC' corresponds to AUDIT_CHANGE events in SQL Server audit logs, which track modifications to audit configurations. Option A is wrong because 'AUSC' does not represent failed login events. Option B is wrong because 'AUSC' is not used for schema changes. Option D is wrong because 'AUSC' is not associated with data manipulation statements.
+15 more Configure and manage automation of tasks questions available
Practice all Configure and manage automation of tasks questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Configure and manage automation of tasks. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Configure and manage automation of tasks questions on the DP-300 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Configure and manage automation of tasks is tested as part of the Microsoft Azure Database Administrator Associate DP-300 blueprint. Practicing with targeted Configure and manage automation of tasks questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free DP-300 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Configure and manage automation of tasks is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Configure and manage automation of tasks practice session with instant scoring and detailed explanations.
Start Configure and manage automation of tasks Practice →