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.
Option A (Use Post Create Command when provisioning the DB) is incorrect because post-create commands are for custom scripts, not optimal for handling concurrent connections.
Option B (Create a new Database Parameters profile) is incorrect because while it can tune settings, it’s less efficient than HA for scaling concurrency.
Option C (Edit the API equivalent shell script) is incorrect as it’s a manual and error-prone method compared to HA provisioning.
Option D is correct because a PostgreSQL HA instance natively supports high concurrency and availability.
Note: The typo "PostqreSQL" is assumed to mean "PostgreSQL."
References
Nutanix Database Service (NDB) User Guide, Chapter 4: Managing Database Engines, Section: Provisioning HA Instances
Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Blueprint, Section 4: Manage Database Engines
