What problem do Azure relational database services solve?
Running databases in the cloud without heavy admin work.
This allows businesses to focus on development rather than infrastructure management.
What are the main benefits of Azure database services?
- Less admin
- High availability
- Security
- Scalability
These benefits enhance operational efficiency and reliability.
What does “fully managed” mean in Azure databases?
Microsoft handles patching, backups, and infrastructure.
This reduces the operational burden on users.
What is Azure SQL?
A family of Microsoft SQL Server–based database services.
It includes various deployment options tailored for different needs.
Name the main Azure SQL service options.
- SQL on VM
- SQL Managed Instance
- SQL Database
- SQL Edge
Each option serves different use cases and management preferences.
What is SQL Server on Azure Virtual Machines?
SQL Server installed on a VM you fully control.
This option provides flexibility and control over the environment.
What service model is SQL Server on VM?
IaaS (Infrastructure as a Service).
Users manage the operating system and SQL Server instance.
When should you use SQL Server on a VM?
Lift-and-shift migrations with minimal changes.
Ideal for moving existing applications to the cloud.
What control do you have with SQL Server on VM?
- Full control of OS
- SQL Server
- Security
- Backups
This allows for customized configurations and management.
What is the main downside of SQL Server on VM?
You still manage everything yourself.
This can increase the operational workload.
What is Azure SQL Managed Instance?
A PaaS SQL Server with near 100% on-prem compatibility.
It simplifies migration while retaining most features.
What does “near 100% compatibility” mean?
Most SQL Server features work without changes.
This facilitates easier transitions from on-premises to cloud.
Can SQL Managed Instance host multiple databases?
Yes, like an on-prem SQL Server instance.
This supports diverse application needs.
What admin tasks are automated in Managed Instance?
- Backups
- Patching
- Monitoring
- High availability
Automation reduces the administrative burden.
When should you choose SQL Managed Instance?
When you need advanced SQL features without VM admin.
This option balances control and management ease.
What is Azure SQL Database?
A fully managed, cloud-native SQL database.
It is designed for modern cloud applications.
Who manages the server in Azure SQL Database?
Microsoft manages everything.
This allows users to focus on application development.
What deployment options does Azure SQL Database have?
- Single Database
- Elastic Pool
These options cater to different application needs and usage patterns.
What is a Single Database best for?
New cloud apps with predictable usage.
This option is efficient for applications with stable workloads.
What problem does Elastic Pool solve?
Databases with changing workloads sharing resources.
This optimizes resource allocation and cost.
What is Azure SQL Edge used for?
IoT and time-series data at the edge.
It is specialized for edge computing scenarios.
Why is Azure SQL Edge not common for business apps?
It’s specialised for IoT, not general workloads.
This limits its applicability in traditional business environments.
Why does Azure support MySQL, MariaDB, and PostgreSQL?
To move existing open-source databases to the cloud easily.
This enhances flexibility for developers.
What is Azure Database for MySQL?
A fully managed MySQL service in Azure.
It simplifies management and scaling for MySQL databases.
-
Core Data Concepts30
-
Data Roles and Services30
-
Fundamental relational data concepts34
-
Explore relational database services in Azure30
-
Explore Azure Storage for non-relational data30
-
Explore fundamentals of Azure Cosmos DB30
-
Explore fundamentals of large scale analytics30
-
Explore fundamentals of real time analytics30
