CDP Database Administration and Security 3

Question 1

What is a database audit trail used for in a regulated environment?

Accepted Answer

Logging who accessed or modified data, when, and what changes were made for compliance and security investigations

Answer

A database audit trail logs all access and modification events—who, what, and when—to support regulatory compliance, security investigations, and accountability.

Question 2

What is 'connection pooling' in database applications?

Accepted Answer

Reusing a pool of pre-established database connections to reduce the overhead of creating new connections for each request

Answer

Connection pooling maintains a pool of reusable database connections, avoiding the costly overhead of establishing a new connection for each application request.

Question 3

In database recovery, what is the difference between a 'full backup' and a 'differential backup'?

Accepted Answer

A full backup copies all data; a differential backup copies only data changed since the last full backup

Answer

A full backup captures all database data, while a differential backup captures only data that has changed since the most recent full backup, reducing backup time and storage.

Question 4

What is the CAP theorem in distributed database systems?

Accepted Answer

A theorem stating that a distributed system can guarantee at most two of three properties: Consistency, Availability, and Partition Tolerance

Answer

The CAP theorem states that in a distributed system, you can only simultaneously guarantee two of three properties: Consistency, Availability, and Partition Tolerance.

Question 5

What is database normalization's Third Normal Form (3NF) requirement?

Accepted Answer

No transitive dependencies — non-key attributes must depend only on the primary key, not on other non-key attributes

Answer

3NF requires that non-key attributes depend only on the primary key (not on other non-key attributes), eliminating transitive dependencies that cause update anomalies.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Database Administration and Security 3