Courseiva
Management and OperationseasyMultiple SelectObjective-mapped

DBS-C01 Management and Operations Practice Question

Which TWO of the following are valid methods to secure data at rest for an Amazon RDS for MySQL DB instance?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Enable encryption at rest using AWS KMS.

(encryption at rest using AWS KMS) is correct because Amazon RDS for MySQL supports encryption at rest using AWS KMS, which encrypts the underlying storage and automated backups. Option C is incorrect because there is no '--enable-encryption' flag in the AWS CLI; the correct parameter to enable encryption during instance creation is '--storage-encrypted'. Therefore, option C does not represent a valid method. Option A is incorrect because SSL/TLS secures data in transit, not at rest. Option D is incorrect because Transparent Data Encryption (TDE) is not supported for MySQL on RDS; it is available for Oracle and SQL Server. Option E is incorrect because Amazon RDS encryption is applied at the storage level, not the table level.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Enable SSL/TLS for connections to the DB instance.

    Why it's wrong here

    SSL secures data in transit, not at rest.

  • Enable encryption at rest using AWS KMS.

    Why this is correct

    RDS supports encryption at rest using KMS.

  • Use the '--enable-encryption' flag when creating the DB instance.

    Why it's wrong here

    The '--enable-encryption' flag does not exist in the AWS CLI. The correct flag is '--storage-encrypted'.

  • Implement Transparent Data Encryption (TDE) using Oracle-compatible settings.

    Why it's wrong here

    TDE is not available for RDS MySQL.

  • Use Amazon RDS encryption at the table level using the ENCRYPT option.

    Why it's wrong here

    RDS encryption is at the storage level, not table level.

Quick reference

AWS S3 Storage Class Comparison

Storage ClassMin DurationRetrievalUse Case
S3 StandardNoneImmediateFrequently accessed data
S3 Standard-IA30 daysImmediateInfrequent access, rapid retrieval
S3 One Zone-IA30 daysImmediateNon-critical infrequent data
S3 Intelligent-TieringNoneImmediate–hoursUnknown or changing access patterns
S3 Glacier Instant90 daysMillisecondsArchive with instant retrieval
S3 Glacier Flexible90 daysMinutes–hoursArchive, flexible retrieval
S3 Glacier Deep Archive180 daysHoursLong-term compliance archive

About these practice questions

One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.