Knowledge check

Completed

Choose the best response for each of the following questions.

Check your knowledge

1.

A PostgreSQL database server at version 11.22 needs an online migration to Azure Database for PostgreSQL - Flexible Server running PostgreSQL version 14. Which tools or services can be used to perform this migration?

Azure Database for PostgreSQL Flexible Server Migration.

pg_dump and pg_restore.

Database Migration Service.

2.

An offline migration is being performed from an existing PostgreSQL server to Azure Database for PostgreSQL - Flexible Server. To transfer server-level roles from the source to the target, which combination of tools should be used?

pg_dumpall, psql, and Azure Database for PostgreSQL - Flexible Server Migration.

pg_dump and pg_restore.

psql and Database Migration Service.

3.

Before performing a database migration from a source PostgreSQL server to a target, it's necessary to assess whether there are any blockers. Which tool should be used for this assessment?

Database Migration Service.

pg_dumpall.

Azure Data Studio with Azure PostgreSQL migration extension.

You must answer all questions before checking your work.