DBS-C01 · Question #335
A company recently created a snapshot of an Amazon RDS for PostgreSQL DB instance that hosts a production database. The company created a new DB instance from the snapshot to test a new application fe
The correct answer is D. Login to the database by using the PostgreSQL administration tool. Issue the VACUUM. VACUUM is effective to improve the query performance and to reduce the latency.
Question
A company recently created a snapshot of an Amazon RDS for PostgreSQL DB instance that hosts a production database. The company created a new DB instance from the snapshot to test a new application feature while providing isolation from the production database. During testing of the new application feature, the company noticed that read latency on the new database was higher than normal. A database specialist needs to resolve the latency issue. Which solution will meet these requirements with the MOST operational efficiency?
Options
- ALog in to the database by using the PostgreSQL administration tool. Issue a SELECT * command
- BCreate a new parameter group and set the max_connections parameter to 100. Assign the
- CEdit the default parameter group for the matching PostgreSQL engine. Set the max_connections
- DLogin to the database by using the PostgreSQL administration tool. Issue the VACUUM
How the community answered
(38 responses)- A3% (1)
- B13% (5)
- C5% (2)
- D79% (30)
Explanation
VACUUM is effective to improve the query performance and to reduce the latency.
Topics
Community Discussion
No community discussion yet for this question.