- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Cloud
Configure, Secure, and Monitor an Azure SQL Database Instance
In this lab, you’ll practice instance-level management capabilities for an Azure SQL Database. When you’re finished, you’ll have practical knowledge on configuring, securing, monitoring and restoring backups needed to support you on the DP-300 exam.
Lab Info
Table of Contents
-
Challenge
Create and Configure Azure SQL Database Resources
- Use the Azure Portal to create an Azure SQL Database Resource
-
Challenge
Configure Security on Azure SQL
- Configure SQL Authentication on Azure SQL and access controls
-
Challenge
Configure Advanced Security Features
- Implement auditing on Azure SQL, and monitor access to flag unauthorized traffic
- Configure Threat Protection on Azure SQL to use it as an extra layer of security for database resources
-
Challenge
Troubleshoot Performance Bottlenecks
- Monitor Query Performance using the Query Store, to identify slow queries that might be slowing down database performance
-
Challenge
Understanding Backups and Restores
- Restore backups using the Azure Portal to correct data corruption issues
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.