CDP Database Administration and Security

Question 1

What does ACID stand for in the context of database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID (Atomicity, Consistency, Isolation, Durability) are the four properties that guarantee reliable database transactions even in the event of errors or system failures.

Question 2

What is the purpose of database indexing?

Accepted Answer

To speed up data retrieval by creating a separate data structure that allows faster lookups

Answer

Database indexes create a separate, sorted data structure (like a book's index) that allows the database engine to find rows quickly without scanning the entire table.

Question 3

What is 'role-based access control' (RBAC) in database security?

Accepted Answer

Assigning permissions to roles and then assigning users to appropriate roles to manage access efficiently

Answer

RBAC assigns permissions to roles (e.g., read-only analyst, data editor) and then assigns users to those roles, simplifying access management at scale.

Question 4

What is 'data masking' used for in database environments?

Accepted Answer

Replacing sensitive data with realistic but fictitious values to protect privacy in non-production environments

Answer

Data masking replaces sensitive production data (like SSNs or credit card numbers) with realistic but fake values for use in development, testing, and analytics environments.

Question 5

What is the purpose of a database transaction log?

Accepted Answer

To record all changes made to the database, enabling recovery and replication

Answer

The transaction log records every modification to the database, enabling point-in-time recovery, undo/redo operations, and replication to secondary servers.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Database Administration and Security