StationX
Start free

Browse › Relational Databases on Azure

Can You Automate Database Maintenance Tasks?

Advanced

Part of Relational Databases on Azure Topic: Azure

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this challenge, you will automate maintenance tasks for a SQL Server database.

  1. Create a Recovery Services vault by using the Azure portal
  2. Restore a SQL Server database on an Azure virtual machine
  3. Configure Azure Backup for the SQL Server database
  4. Create a SQL Server Agent job to perform a data integrity check by using Database Command Console (DBCC) commands

Note: Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.