Previous

Next

Knowledge check

Completed

Choose the best response for each of the questions below. Then select Check your answers.

Check your knowledge

1.

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

General Purpose

Burstable

Memory optimized

2.

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.

3.

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 doing this?

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.

Continue