Azure Database for PostgreSQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Azure Database for PostgreSQL?

Azure Database for PostgreSQL is a managed cloud database service that lets you run PostgreSQL databases without managing the underlying hardware or software.

intermediate

Name two deployment options available in Azure Database for PostgreSQL.

Single Server and Flexible Server are two deployment options. Single Server is fully managed with built-in high availability. Flexible Server offers more control over maintenance windows and scaling.

intermediate

How does Azure Database for PostgreSQL ensure data security?

It uses encryption at rest and in transit, network security with virtual networks, and role-based access control to protect your data.

advanced

What is the benefit of using Flexible Server over Single Server in Azure Database for PostgreSQL?

Flexible Server allows you to customize maintenance windows, pause and resume the server, and choose zone redundant high availability for better control and cost savings.

intermediate

Explain how backups work in Azure Database for PostgreSQL.

Azure automatically takes backups of your PostgreSQL database and retains them for a configurable retention period. You can restore your database to any point within that period.

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

A Elastic Pool

B App Service

C Blob Storage

D Flexible Server

Flexible Server is a deployment option for Azure Database for PostgreSQL. Elastic Pool and App Service are unrelated services.

What feature helps protect data in Azure Database for PostgreSQL during transfer?

A Load balancing

B Auto-scaling

C Encryption in transit

D Caching

Encryption in transit protects data as it moves between your application and the database.

How long can you retain backups in Azure Database for PostgreSQL by default?

A 35 days

B 7 days

C 90 days

D 365 days

By default, Azure Database for PostgreSQL retains backups for 7 days, but this can be configured up to 35 days.

Which Azure Database for PostgreSQL option allows pausing the server to save costs?

A Flexible Server

B Managed Instance

C Hyperscale

D Single Server

Flexible Server supports pausing and resuming the server, which helps save costs during idle times.

What is a key benefit of using a managed database service like Azure Database for PostgreSQL?

A No need to manage hardware or software updates

B Requires manual backups

C You must configure network security yourself

D No automatic scaling options

Managed services handle hardware and software maintenance for you, reducing your workload.

Describe the main features and benefits of Azure Database for PostgreSQL.

Think about what makes it easy and safe to run PostgreSQL in the cloud.

Explain the differences between Single Server and Flexible Server deployment options in Azure Database for PostgreSQL.

Consider control, availability, and cost management.