exam questions

Exam AWS Certified Cloud Practitioner CLF-C02 All Questions

View all questions & answers for the AWS Certified Cloud Practitioner CLF-C02 exam

Exam AWS Certified Cloud Practitioner CLF-C02 topic 1 question 240 discussion

A company wants to migrate its PostgreSQL database to AWS. The company does not use the database frequently.

Which AWS service or resource will meet these requirements with the LEAST management overhead?

  • A. PostgreSQL on Amazon EC2
  • B. Amazon RDS for PostgreSQL
  • C. Amazon Aurora PostgreSQL-Compatible Edition
  • D. Amazon Aurora Serverless
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
VikJo1978
Highly Voted 1 year, 4 months ago
Selected Answer: D
If cost is not a concern and you want the least management overhead, Amazon Aurora Serverless would be the best option. Amazon Aurora Serverless provides the highest level of automation and scalability as it is a serverless database solution. You don't have to worry about managing database instances, scaling, or maintenance. The database automatically scales up and down to meet your application's requirements, and you only pay for the resources you actually use. So, the correct answer in this case would be: D. Amazon Aurora Serverless
upvoted 8 times
...
its_tima
Most Recent 3 months, 2 weeks ago
Selected Answer: D
Amazon Aurora Serverless - automatically starts up, shuts down, and scales capacity up or down based on your application's needs, thus, reducing management overhead.* Amazon Aurora PostgreSQL-Compatible Edition - a simple and cost-effective to set up, operate, and scale your new and existing PostgreSQL deployments. Amazon RDS for PostgreSQL - deploy scalable PostgreSQL deployments in minutes with cost-efficient and resizable hardware capacity.
upvoted 1 times
...
Oezge
4 months, 1 week ago
Selected Answer: D
Amazon Aurora Serverless is a fully managed database service that automatically adjusts capacity based on the workload. It is specifically designed for use cases where the database is not used frequently or has variable workloads. With Aurora Serverless, you only pay for the database capacity that you use, and it automatically scales up and down as needed. This makes it a great fit for applications with unpredictable or infrequent usage.
upvoted 1 times
...
ShaiTay
5 months, 2 weeks ago
Selected Answer: D
D. Amazon Aurora Serverless - cost effective, automatic scaling, low management overhead
upvoted 1 times
...
moadabdou
11 months ago
Selected Answer: D
The correct answer is: D. Amazon Aurora Serverless Explanation: Amazon Aurora Serverless is the best choice for this company as it offers minimal resource management and automatically scales based on demand. With Aurora Serverless, there is no need to provision or manually manage database instances. Instead, Aurora Serverless adjusts automatically based on the incoming query volume. This significantly reduces administrative overhead for the company while providing a scalable solution for its database infrastructure.
upvoted 2 times
...
chalaka
1 year ago
Selected Answer: D
D. Amazon Aurora Serverless. Amazon Aurora Serverless is a fully managed relational database service that automatically scales compute capacity up or down based on the application's needs. It is ideal for workloads with unpredictable or intermittent usage patterns, as it automatically starts and stops database instances based on demand. This means the company doesn't need to provision or manage the database instance themselves, resulting in minimal management overhead. Additionally, Aurora Serverless offers the benefits of Aurora's high performance and durability, making it a suitable choice for migrating the PostgreSQL database with minimal management effort.
upvoted 2 times
...
517d694
1 year, 1 month ago
Selected Answer: D
The answer is D. Aurora Serverless can handle resource capacity more flexibly, thus being less overhead to manage . In Amazon RDS, a deployed database server is not scaled to a larger instance type unless its configuration is explicitly updated to a different size, which can result in up to five minutes of downtime. RDS does offer auto scaling for read replicas, but the process takes a few minutes to execute since it has to deploy additional RDS instances. Aurora Serverless' automatic scaling results in much faster deployment times, typically within 30 seconds.
upvoted 1 times
...
Hommedollars
1 year, 2 months ago
Selected Answer: B
Answer is B From ChatGPT: For a company that wants to migrate its PostgreSQL database to AWS with minimal management overhead, Amazon RDS (Relational Database Service) is a suitable solution. Amazon RDS takes care of routine database tasks such as backups, patch management, and scaling, allowing you to focus on your application instead of the underlying database infrastructure.
upvoted 3 times
...
stoy123
1 year, 2 months ago
Selected Answer: C
Sorry it's C: Amazon Aurora PostgreSQL: Pros: Fully managed service with automatic patching, backups, and replication. High availability and scalability. Pay-per-second billing minimizes costs for infrequent use. Supports homogeneous migrations from existing PostgreSQL databases. Cons: Might have higher base costs compared to other options for infrequent use. Less customization compared to self-managed options.
upvoted 1 times
...
BShelat
1 year, 3 months ago
Selected Answer: D
https://aws.amazon.com/blogs/database/best-practices-for-migrating-postgresql-databases-to-amazon-rds-and-amazon-aurora/
upvoted 2 times
...
petercorn
1 year, 4 months ago
Selected Answer: D
You're running an infrequently-used application, with peaks of 30 minutes to several hours a few times each day or several times per year, such as a human resources, budgeting, or operational reporting application. You no longer have to provision to peak capacity, which would require you to pay for resources you don't continuously use, or to average capacity, which would risk performance problems and a poor user experience. https://aws.amazon.com/rds/aurora/serverless/
upvoted 2 times
...
fguglia
1 year, 5 months ago
Selected Answer: B
For me the correct answer is B
upvoted 4 times
TreyQA
1 year, 5 months ago
Keyword being "Least Management Overhead"
upvoted 3 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago