DS0-001 Database Planning And Deployment Practice Question
You are deploying a database to a cloud environment and need to ensure that data at rest is encrypted according to organizational security policy. Which deployment configuration ensures transparent encryption of the database files?
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
✓
Implementing Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) provides encryption for the entire database file at the storage level, which is a standard deployment requirement for cloud databases.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Implementing Transparent Data Encryption (TDE)
Why this is correct
TDE encrypts the database, log files, and backups at rest without requiring application code changes.
- ✗
Applying column-level encryption
Why it's wrong here
Column-level encryption is more granular and complex than the database-wide protection provided by TDE.
- ✗
Using a Virtual Private Cloud (VPC) endpoint
Why it's wrong here
VPC endpoints secure network connectivity, not the storage-level encryption of database files.
- ✗
Enabling SSL/TLS on the connection string
Why it's wrong here
SSL/TLS encrypts data in transit, not data at rest.
About these practice questions
This DS0-001 question is part of Courseiva's 216-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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official CompTIA exam blueprint
This DS0-001 practice question is part of Courseiva's free CompTIA 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 DS0-001 exam.