Q75 — AWS SAA-C03 Ch.12

Question 75 of 100 | ← Chapter 12

Q875. A large company wants to provide its globally located developers separate, limited size, managed PostgreSQL databases for development purposes. The databases will be low volume. The developers need the databases only when they are actively working.Which solution will meet these requirements MOST cost-effectively?

• A. Give the developers the ability to launch separate Amazon Aurora instances. Set up a process to shut down Aurora instances at the end of the workday and to start Aurora instances at the beginning of the next workday.
• B. Develop an AWS Service Catalog product that enforces size restrictions for launching Amazon Aurora instances. Give the developers access to launch the product when they need a development database.
• C. Create an Amazon Aurora Serverless cluster. Develop an AWS Service Catalog product to launch databases in the cluster with the default capacity settings. Grant the developers access to the product. ✓
• D. Monitor AWS Trusted Advisor checks for idle Amazon RDS databases. Create a process to terminate identified idle RDS databases.

Correct Answer: C. Create an Amazon Aurora Serverless cluster. Develop an AWS Service Catalog product to launch databases in the cluster with the default capacity settings. Grant the developers access to the product.

Explanation

To provide separate, limited size, managed PostgreSQL databases for globally located developers in a cost-effective manner, the recommended solution is:C. Create an Amazon Aurora Serverless cluster. Develop an AWS Service Catalog product to launch databases in the cluster with the default capacity settings. Grant the developers access to the product.Here's why:Option A suggests giving developers the ability to launch separate Amazon Aurora instances and setting up a process to shut down and start instances based on workday schedules. While this option provides separate databases for developers, it requires manual intervention to manage the database lifecycle. It may not be the most cost-effective solution as the instances need to be running even when developers are not actively using them.Option B suggests developing an AWS Service Catalog product that enforces size restrictions for launching Amazon Aurora instances. While this option provides size restrictions and controlled access through a service catalog, it still requires dedicated instances to be running for each developer, resulting in potential underutilization and higher costs.Option D suggests monitoring AWS Trusted Advisor checks for idle Amazon RDS databases and creating a process to terminate identified idle databases. While this option addresses idle databases, it doesn't provide separate, limited size databases for individual developers when they are actively working. It focuses on cost optimization rather than providing dedicated resources for development purposes.Option C recommends creating an Amazon Aurora Serverless cluster and developing an AWS Service Catalog product to launch databases in the cluster with default capacity settings. Amazon Aurora Serverless is a cost-effective option for low-volume workloads as it automatically scales the database capacity based on demand. Developers can launch databases as needed through the service catalog, and the default capacity settings ensure efficient utilization of resources. When developers are not actively working, the cluster can scale down to minimize costs.In summary, the most cost-effective solution for providing separate, limited size, managed PostgreSQL databases for globally located developers is to create an Amazon Aurora Serverless cluster (Option C) and develop an AWS Service Catalog product to launch databases in the cluster. This approach ensures efficient resource utilization, on-demand access for developers, and cost savings for low-volume development workloads.