AWS Services Hosting PostgreSQL

Answer Correct answer: B, C — Amazon Aurora and Amazon EC2 are the two services listed that can host PostgreSQL databases.

Which AWS services can host PostgreSQL databases? (Choose two.)

  1. Amazon S3
  2. Amazon Aurora Correct Answer
  3. Amazon EC2 Correct Answer
  4. Amazon OpenSearch Service
  5. Amazon Elastic File System (Amazon EFS)

Community Votes

BC
100%

100% of anonymous learners picked answer BC. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

Tests the ability to differentiate between storage-only services and those capable of running database engines, highlighting that PostgreSQL runs on both managed (Aurora) and unmanaged (EC2) infrastructure.

Identifies which AWS services support PostgreSQL databases, distinguishing between managed database offerings and general compute resources. Establishes that both Amazon Aurora and Amazon EC2 are valid platforms for hosting this specific relational database engine.

Candidates often incorrectly select Amazon S3 or EFS, confusing object/file storage with executable database environments, or overlook EC2's flexibility in hosting custom database instances.

Community Discussion (3 comments)

Nikmah 👍 1 Selected: BC
• PostgreSQL and MySQL are both supported as Aurora DB
ShaiTay 👍 1 Selected: BC
B. Amazon Aurora C. Amazon EC2
its_tima 👍 1
"Amazon EC2 (Elastic Compute Cloud) provides scalable computing power in the cloud, making it an excellent platform for hosting databases like PostgreSQL. While managed services like Amazon RDS or Aurora offer convenience, setting up PostgreSQL on EC2 gives you complete control over your database configuration."

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

Amazon Aurora is a managed relational database service that fully supports PostgreSQL as one of its primary engines, making it a correct choice. Amazon EC2 provides virtual servers where users have full administrative control, allowing them to install and run PostgreSQL manually, which also makes it a correct choice. While Amazon RDS is another common answer for PostgreSQL, it is not listed here; among the options, only Aurora and EC2 provide the necessary runtime environment.

Why the Other Options Are Wrong

Amazon S3 is an object storage service designed for storing data files, not for executing database software. Amazon OpenSearch Service is a search and analytics engine based on Elasticsearch, incompatible with PostgreSQL protocols. Amazon EFS is a file storage system for use with EC2 and Lambda, lacking the database engine capabilities required to host PostgreSQL.

Community Comment Notes

The community consensus strongly supports BC, with multiple users confirming that Aurora natively supports PostgreSQL. One user noted that while managed services like RDS offer convenience, "setting up PostgreSQL on EC2 gives you complete control over your database configuration," reinforcing EC2's validity as a hosting option.

Exam Strategy

When asked about hosting specific database engines, consider both managed services (like Aurora/RDS) and general-purpose compute (EC2). Eliminate storage-only services (S3, EFS) and specialized non-relational services (OpenSearch) immediately.

Frequently Asked Questions

Can I run PostgreSQL on Amazon S3?

No, S3 is object storage. It cannot execute database software or manage transactions.

Why isn't Amazon RDS an option here?

RDS does support PostgreSQL, but it was not provided as a selectable option in this specific question.

More CLF-C02 FAQ →

Related Analysis

Practice All CLF-C02 Questions

Access 120 questions with complete answers and detailed explanations.

View Full CLF-C02 Practice Test →

← Back to CLF-C02 Study Guide