Study guide for the Applied Skills assessment lab: Configure and migrate to Azure Database for PostgreSQL

Purpose of this document

This study guide provides a summary of the topics covered in the assessment lab, along with additional resources to help you prepare. Note that the learning path on the credential details page may include more modules than the "Tasks performed" to provide a cohesive learning experience.

Tasks at a glance

Migrate a database to Azure Database for PostgreSQL

• Deploy a server

• Create a database

• Migrate a local database to Azure Database for PostgreSQL

  Supporting module (s):

  • Migrate to Azure Database for PostgreSQL flexible server

Configure high availability, replication, and disaster recovery

• Configure high availability

• Configure cross-region replication

• Configure disaster recovery

  Supporting module (s):

  • Understand write-ahead logging

Configure and optimize database performance

• Run a workload

• Configure wait statistics

• Configure Query Store

• Create indexes

• Identify poorly performing queries

• Optimize query performance

  Supporting module (s):

  • Tune queries in Azure Database for PostgreSQL

  • Understand PostgreSQL query processing

Configure identity and access

• Configure server connectivity

• Configure Microsoft Entra authentication

• Isolate network traffic by using Private Link

• Manage firewall rules

  Supporting module (s):

  • Secure Azure Database for PostgreSQL