Previous

Next

Knowledge check

Completed

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

Check your knowledge

1.

You work for a small start-up company. The company is developing a system that it hopes will be used by many large corporations across the world. They have yet to win their first customer. Which Azure Database for PostgreSQL server should they select?

Azure Arc-enabled PostgreSQL Hyperscale.

Flexible server.

Hyperscale Citus.

2.

Which of the following best describes the architecture of PostgreSQL?

Client/server.

Distributed.

Relational.

3.

You run a small number of very complex queries on your PostgreSQL database. Which server parameter should you consider tuning to improve performance?

work_mem

max_connection

Shared_buffers

4.

Which server process is responsible for initiating and shutting down the PostgreSQL processes?

Query optimizer.

Postmaster daemon.

PostgreSQL backend processes.

You must answer all questions before checking your work.

Continue