Knowledge check

3 minutes

Choose the best response for each of the following questions.

Check your knowledge

What is the purpose of pgBouncer?

When pgBouncer is enabled, it stops connections from being reused.

When pgBouncer is enabled, it ensures connections are reused.

When pgBouncer is enabled, it prevents more users connecting than the server can handle.

For best performance on Azure Database for PostgreSQL, how should you manage connection handling?

Process-based connection handling.

Connection pooling.

Set max_connections to the minimum possible value.

You want to benchmark the performance of your database after making some changes to server parameters. Which client tool is best suited to your needs?

Azure Data Studio.

the pgbench tool.

the psql tool.

You must answer all questions before checking your work.

Knowledge check

Check your knowledge

Feedback