Knowledge check

3 minutes

Choose the best response for each of the following questions.

Check your knowledge

Your company maintains a database system that has only light use but holds mission critical information. You're asked to ensure that every possible step is taken to ensure business continuity for all known disasters. Which compute tier should you select for your Azure Database for PostgreSQL flexible server?

General Purpose.

Burstable.

Memory optimized.

Your company maintains a busy shopping application. You want to provide near-time reporting, without affecting performance on the Azure Database for PostgreSQL server. Which option would best suit your needs?

Configure High Availability on your Azure Database for PostgreSQL server and use the replicated copy for reporting.

Configure zone redundant High Availability on your Azure Database for PostgreSQL server and use the replicated copy for reporting.

Create a second Azure Database for PostgreSQL server and configure it as a subscriber. Configure your existing server as a publisher.

Your company uses Azure Database for PostgreSQL flexible server to maintain its stock system. You want to use the contents of the write-ahead log (WAL) for auditing purposes. What is the best way of performing this task?

Copy the log from pg_wal directory.

Install the pglogical extension and use logical streaming replication.

Configure zone redundant high availability.

You must answer all questions before checking your work.

Knowledge check

Check your knowledge

Feedback