DBS-C01 Database Security Practice Question
A company is using Amazon Redshift for data warehousing. The security team requires that all data be encrypted at rest using a customer-managed AWS KMS key. Additionally, the team wants to ensure that the key must be used only for this specific Redshift cluster. Which configuration should be applied?
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
✓
Create a new KMS key with a key policy that grants access only to the Redshift cluster's IAM role.
To enforce encryption at rest with a customer-managed AWS KMS key and restrict key usage to a specific Redshift cluster, you create a new KMS key and configure its key policy to grant encrypt/decrypt permissions only to the IAM role associated with the Redshift cluster. This ensures the key is only used by that cluster. Option A is incorrect because associating a key with a subnet group does not limit usage to the cluster; key policies control access. Option C is incorrect because the default AWS managed key is not customer-managed. Option D is incorrect because CloudHSM keys are not directly used with Redshift; KMS is the required service for integration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Create a new KMS key and associate it with the Redshift cluster's subnet group.
Why it's wrong here
Subnet group does not affect encryption key association.
- ✓
Create a new KMS key with a key policy that grants access only to the Redshift cluster's IAM role.
Why this is correct
KMS key can be restricted to a specific role used by Redshift.
- ✗
Use the default AWS managed KMS key for Redshift.
Why it's wrong here
Not customer-managed.
- ✗
Use an HSM-backed key from CloudHSM.
Why it's wrong here
Redshift does not support CloudHSM for encryption.
Visual reference
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
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.