A new web application performs up to 200 concurrent connections to a PostgreSQL database. An administrator needs to configure the system to provision those DB servers. Which action would easily help…

The correct answer is D. Provision a PostqreSQL HA Instance. A new web application with up to 200 concurrent connections to a PostgreSQL database requires a robust and scalable configuration. Provisioning a PostgreSQL HA (High Availability) instance in NDB is the most effective action to achieve this goal. An HA instance leverages…

Manage Database Environments

Question

A new web application performs up to 200 concurrent connections to a PostgreSQL database. An administrator needs to configure the system to provision those DB servers. Which action would easily help the administrator achieving this goal?

Options

AUse Post Create Command when provisioning the DB.
BCreate a new Database Parameters profile.
CEdit the API equivalent shell script to apply the setting.
DProvision a PostqreSQL HA Instance.

How the community answered

(31 responses)

A
16% (5)
B
3% (1)
C
10% (3)
D
71% (22)

Explanation

A new web application with up to 200 concurrent connections to a PostgreSQL database requires a robust and scalable configuration. Provisioning a PostgreSQL HA (High Availability) instance in NDB is the most effective action to achieve this goal. An HA instance leverages replication (e.g., streaming replication) to distribute load and ensure availability, accommodating high concurrency by allowing multiple nodes to handle traffic. This approach simplifies configuration compared to manual scripting or parameter adjustments.

Topics

#PostgreSQL#HA instance#concurrent connections#database provisioning

Community Discussion

No community discussion yet for this question.

Full NCP-DB-6.10 Practice