Azure Database for MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Azure Database for MySQL?

Azure Database for MySQL is a managed cloud service that lets you run MySQL databases without managing the underlying hardware or software. It handles backups, scaling, and security for you.

beginner

How does Azure Database for MySQL handle backups?

It automatically creates backups of your database daily and keeps them for up to 35 days. You can restore your database to any point within that retention period.

intermediate

What are the deployment options for Azure Database for MySQL?

The primary deployment option is Flexible Server (Single Server is deprecated). Flexible Server offers more control over maintenance windows and high availability options.

beginner

Why is scaling important in Azure Database for MySQL?

Scaling lets you adjust the compute power and storage size of your database to match your workload. This helps keep your app fast and cost-effective as demand changes.

intermediate

What security features does Azure Database for MySQL provide?

It includes data encryption at rest and in transit, firewall rules to control access, and integration with Azure Active Directory for identity management.

Which of the following is a deployment option for Azure Database for MySQL?

A Virtual Machine Server

B Container Server

C Dedicated Server

D Flexible Server

Azure Database for MySQL's primary deployment option is Flexible Server (Single Server is deprecated). Virtual Machines or Containers are not deployment types for this service.

How long does Azure Database for MySQL keep automatic backups by default?

A 7 days

B 14 days

C 35 days

D 90 days

Azure Database for MySQL retains automatic backups for 7 days by default, configurable up to 35 days.

What does scaling compute power in Azure Database for MySQL affect?

A The speed of queries and connections

B The size of the database files

C The number of users allowed

D The backup retention period

Scaling compute power improves the speed and capacity for processing queries and connections.

Which security feature is NOT provided by Azure Database for MySQL?

A Automatic virus scanning

B Firewall rules

C Azure Active Directory integration

D Data encryption at rest

Azure Database for MySQL does not provide automatic virus scanning as a built-in feature.

What is the main benefit of using a managed database service like Azure Database for MySQL?

A You manage all hardware and software updates

B The cloud provider handles maintenance, backups, and scaling

C You only pay a flat monthly fee regardless of usage

D You can only use it with Microsoft applications

Managed services handle maintenance, backups, and scaling so you can focus on your application.

Explain how Azure Database for MySQL helps you manage database backups and recovery.

Think about how the service protects your data without extra work.

Describe the difference between Single Server and Flexible Server deployment options in Azure Database for MySQL.

Consider control and availability features.