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

Automated, Consistent, Isolated, Durable

Answer

Accurate, Concurrent, Integrated, Distributed

Answer

Asynchronous, Cached, Indexed, Distributed

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

To encrypt data stored in tables

Answer

To enforce referential integrity between tables

Answer

To compress data to reduce storage space

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

Granting permissions to individual users directly

Answer

Restricting access based on the time of day

Answer

Encrypting data based on a user's department

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

Hiding database tables from query optimizers

Answer

Encrypting data during network transmission

Answer

Compressing data to save storage space

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

To store user login history

Answer

To track query performance metrics

Answer

To store backup copies of database tables

Question 6

What does 'database replication' achieve?

Accepted Answer

Synchronizes data from a primary database to one or more secondary databases for availability and read scaling

Answer

Creates duplicate copies of database schemas in documentation

Answer

Compresses database tables to reduce storage

Answer

Validates database backup integrity