Azure Database for PostgreSQL - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ service_behavior

intermediate

Understanding Azure Database for PostgreSQL High Availability

Which of the following statements correctly describes how Azure Database for PostgreSQL provides high availability?

A It uses active-passive replication across multiple regions to ensure zero downtime.

B It automatically creates a standby server in the same region and switches to it during failures.

C It requires manual failover by the user to a backup server in a different region.

D It relies on client-side retry logic without any built-in failover mechanism.

💡 Hint

Think about how Azure manages failover within the same region to minimize downtime.

Azure Database for PostgreSQL creates a standby server in the same region for high availability. If the primary server fails, it automatically switches to the standby server to minimize downtime.

❓ Architecture

intermediate

Choosing the Right Deployment Option for Azure Database for PostgreSQL

You need a managed PostgreSQL database with flexible scaling and built-in high availability. Which Azure Database for PostgreSQL deployment option should you choose?

A Flexible Server deployment with zone redundant high availability and burstable compute.

B Hyperscale (Citus) deployment for single-node workloads without scaling.

C Single Server deployment with manual backups and no high availability.

D Managed Instance deployment with no support for PostgreSQL extensions.

💡 Hint

Consider which deployment supports both scaling and built-in high availability.

Flexible Server deployment supports zone redundant high availability and flexible compute scaling, making it suitable for workloads needing both features.

❓ security

advanced

Configuring Secure Access to Azure Database for PostgreSQL

You want to restrict access to your Azure Database for PostgreSQL server to only specific Azure Virtual Network subnets. Which feature should you configure?

A Disable firewall and rely on database user authentication only.

B Configure firewall rules to allow only the IP addresses of the subnets.

C Use Virtual Network Service Endpoints or Private Link to restrict access to specific subnets.

D Enable SSL enforcement and allow all IP addresses.

💡 Hint

Think about how Azure integrates network security with database access.

Virtual Network Service Endpoints or Private Link allow you to restrict database access to specific Azure Virtual Network subnets, enhancing security beyond IP firewall rules.

❓ Configuration

advanced

Configuring Backup Retention for Azure Database for PostgreSQL Flexible Server

You want to configure your Azure Database for PostgreSQL Flexible Server to retain backups for 14 days. Which configuration setting achieves this?

A Set the backup retention period to 35 days in the server properties.

B Enable geo-redundant backups with a 7-day retention period.

C Configure the server to perform manual backups every 14 days.

D Set the backup retention period to 14 days in the server properties.

💡 Hint

Look for the setting that directly controls backup retention duration.

The backup retention period setting in the server properties controls how long automated backups are kept. Setting it to 14 days retains backups for that duration.

✅ Best Practice

expert

Optimizing Cost and Performance for Azure Database for PostgreSQL

You have a production workload with variable traffic patterns on Azure Database for PostgreSQL Flexible Server. Which approach best balances cost and performance?

A Use Flexible Server with burstable compute tier and stop the server during low traffic periods.

B Use Hyperscale (Citus) deployment with multiple nodes regardless of workload size.

C Use a Single Server deployment with the highest compute tier always enabled.

D Use Flexible Server with a fixed compute tier and no auto-scaling or stopping.

💡 Hint

Consider how to save costs when workload demand changes over time.

Flexible Server supports burstable compute tiers and can be stopped during idle periods, reducing costs while maintaining performance during peak times.

Practice

1. What is the main benefit of using Azure Database for PostgreSQL?

easy

A. It only supports PostgreSQL version 9.6.

B. It requires manual installation of PostgreSQL on virtual machines.

C. It is only available for on-premises servers.

D. It manages database setup, scaling, and maintenance automatically.

Solution

1. Step 1: Understand Azure Database for PostgreSQL service

   This service is managed by Azure, which means it handles setup, scaling, and maintenance for you.

2. Step 2: Compare options

   Limited version support, manual installation on VMs, and on-premises availability do not match the managed nature of this cloud service.

3. Final Answer:

   It manages database setup, scaling, and maintenance automatically. -> Option D

4. Quick Check:

   Managed service = automatic management [OK]

Hint: Managed means Azure handles setup and scaling for you [OK]

Common Mistakes:

• Thinking you must install PostgreSQL manually
• Assuming only old versions are supported
• Confusing cloud service with on-premises

2. Which Azure CLI command correctly creates a new PostgreSQL server named myserver in resource group mygroup?

easy

A. az postgres server new --name myserver --resource-group mygroup --admin-user admin --admin-password Pass@123

B. az postgres create server --resource-group mygroup --name myserver --admin-user admin --admin-password Pass@123

C. az postgres server create --name myserver --resource-group mygroup --location eastus --admin-user admin --admin-password Pass@123

D. az create postgres server --name myserver --resource-group mygroup --admin-user admin --admin-password Pass@123

Solution

1. Step 1: Identify correct Azure CLI syntax

   The correct command to create a PostgreSQL server uses az postgres server create with required parameters.

2. Step 2: Check options for syntax errors

   Other options use incorrect command structures, order, or omit required parameters like location, making them invalid.

3. Final Answer:

   az postgres server create --name myserver --resource-group mygroup --location eastus --admin-user admin --admin-password Pass@123 -> Option C

4. Quick Check:

   Correct CLI command = az postgres server create --name myserver --resource-group mygroup --location eastus --admin-user admin --admin-password Pass@123 [OK]

Hint: Use 'az postgres server create' to make a new server [OK]

Common Mistakes:

• Mixing command order or keywords
• Using 'az create' instead of 'az postgres server create'
• Omitting required parameters like location

3. Given this Azure CLI command:

az postgres server show --name myserver --resource-group mygroup

What output should you expect?

medium

A. Details of the PostgreSQL server named 'myserver' in 'mygroup'.

B. Creates a new PostgreSQL server named 'myserver'.

C. Deletes the PostgreSQL server named 'myserver'.

D. Lists all PostgreSQL servers in the subscription.

Solution

1. Step 1: Understand the 'az postgres server show' command

   This command retrieves and displays details about a specific PostgreSQL server.

2. Step 2: Compare with other options

   Creating, deleting, or listing all servers require different commands. This 'show' command displays details of the specific server.

3. Final Answer:

   Details of the PostgreSQL server named 'myserver' in 'mygroup'. -> Option A

4. Quick Check:

   'show' command = server details [OK]

Hint: 'show' means display info about one server [OK]

Common Mistakes:

• Confusing 'show' with 'create' or 'delete'
• Expecting a list of all servers
• Not specifying resource group or server name

4. You run this command to create a PostgreSQL server but get an error:

az postgres server create --name myserver --resource-group mygroup --admin-user admin --admin-password Pass123

What is the likely cause?

medium

A. The admin user name 'admin' is not allowed.

B. The admin password does not meet Azure's complexity requirements.

C. The server name 'myserver' is already in use.

D. The resource group 'mygroup' does not exist.

Solution

1. Step 1: Check password complexity rules

   Azure requires strong passwords with uppercase, lowercase, numbers, and symbols. 'Pass123' lacks symbols.

2. Step 2: Evaluate other options

   Resource group existence or server name conflicts cause different errors. 'admin' is allowed as admin user.

3. Final Answer:

   The admin password does not meet Azure's complexity requirements. -> Option B

4. Quick Check:

   Password complexity error = The admin password does not meet Azure's complexity requirements. [OK]

Hint: Check password has uppercase, lowercase, number, symbol [OK]

Common Mistakes:

• Ignoring password complexity rules
• Assuming resource group or name errors without checking
• Thinking 'admin' username is invalid

5. You want to enable high availability for your Azure Database for PostgreSQL server. Which configuration should you choose?

hard

A. Create a server with the 'Zone-redundant HA' option enabled.

B. Use a single server with no replicas.

C. Manually set up replication between two separate servers.

D. Deploy PostgreSQL on a VM and configure failover clustering.

Solution

1. Step 1: Understand Azure's built-in high availability options

   Azure Database for PostgreSQL offers a 'Zone-redundant HA' option that automatically replicates data across availability zones.

2. Step 2: Evaluate other options

   A single server with no replicas lacks HA. Manual replication between separate servers requires manual setup and is not recommended. Deploying on a VM with failover clustering is outside the managed service scope.

3. Final Answer:

   Create a server with the 'Zone-redundant HA' option enabled. -> Option A

4. Quick Check:

   Zone-redundant HA = automatic high availability [OK]

Hint: Use zone-redundant HA for built-in high availability [OK]

Common Mistakes:

• Choosing single server without HA
• Trying manual replication instead of managed HA
• Using VMs instead of managed service for HA