ExamPark
Course menuCLF-C02

Exams / CLF-C02 / Databases and migration / Question 2

CLF-C02 practice question: Databases and migration (2 of 2)

Cloud Technology and Services A free question from our original CLF-C02 practice exam. Try it, then open the answer to see why each option is right or wrong.

Last verified against current AWS documentation ·How we write our questions

A software vendor's application needs a database engine version that Amazon RDS does not offer.

A monitoring agent must also be installed on the database server's operating system. The company wants full control of the server, so it will not use a managed database service.

Which option meets these requirements?

Choose one answer.

  1. A. Amazon RDS, using the closest available engine version
  2. B. Amazon Aurora, a managed database with MySQL- and PostgreSQL-compatible engines
  3. C. Amazon DynamoDB, which needs no database server
  4. D. Install the database engine on Amazon EC2 instances the company manages
Show the answer and explanation

Answer: D

  • A. Wrong: Amazon RDS does not offer the required version, so a nearby version fails the first requirement. RDS also manages the host and does not let customers install their own software on its operating system.
  • B. Wrong: Aurora is a managed service, so the company cannot install its own software on the database server or control the server. It fails the requirement for full control. Learn more: Amazon Aurora (opens in a new tab)
  • C. Wrong: DynamoDB is a key-value and document database, not a relational engine, so it cannot run the vendor's database software. It also gives no operating system access for the agent.
  • D. Right: An EC2 instance gives the company access to the operating system, so it can install the agent and choose the engine version. The company then handles patching and backups itself, which it has accepted. Learn more: Amazon EC2 (opens in a new tab)

Explanation

Amazon EC2 gives the company control of the operating system, so it can install the agent and run the engine version it needs. RDS lacks the version and does not allow custom operating system software, Aurora is managed with no server access, and DynamoDB is not a relational engine.

Study

Keep practicing

Answer questions with a score at the end, or practice just this topic with the explanation after each one. No sign-up needed.

Take the free CLF-C02 practice examPractice Databases and migrationAll Databases and migration questions

Want more on Databases and migration? The 5 full-length practice sets have 10 more Databases and migration questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets