AdvancedMicrosoft Azure Database Administrator Associate project · about 18 hours

Highly available, secure Azure SQL platform

Run the database with high availability, security, automation and a disaster recovery plan.

The real-world brief

A bank needs its customer database always on, secure and auditable.

What you will build

  • Replication or a high-availability setup
  • Roles, encryption and auditing
  • Automated maintenance
  • A tested fail-over and DR plan

Skills you will practise

High availabilitySecurityAutomationDisaster recovery

Tools

Azure SQL failover groupsMicrosoft Defender for SQLAzure AutomationMicrosoft Entra ID

Project tasks

The detailed steps, checklists and trainer review open in the SOTT student portal for enrolled students.

1High availability Steps in portal
2Secure Steps in portal
3Mask Steps in portal
4Automate Steps in portal
5Plan Steps in portal

How companies use Microsoft Azure Database Administrator Associate

E-commerce: Checkout that stays fast at sale time. Slow queries made checkout time out during sales. Indexes, query tuning and read replicas for reports. Checkout stayed fast through the biggest sale.

Banking: No data lost in an outage. Nobody had tested restoring the core database. Automated backups, point-in-time restore and regular restore drills. A restore drill met the agreed recovery time.

SaaS: Secure customer data. Every developer could read production data. Least-privilege roles, encryption, masking and auditing. Access is limited and audited.

Questions

Can I add the Highly available, secure Azure SQL platform project to my resume?

Yes. Once your trainer approves it, list it under Projects with the tools you used, one line on the problem it solves and a link to your repository and demo video.

How long does this project take?

About 18 hours of hands-on work, and it fits best after week 12 of the Microsoft Azure Database Administrator Associate course.

Where do I get the step-by-step tasks?

Enrolled students get every task with steps, "done when" checks, the submission form and a trainer review in the SOTT student portal.