CDP Database Administration and Security 2

Question 1

What is SQL injection and why is it a database security concern?

Accepted Answer

An attack where malicious SQL code is inserted into input fields to manipulate or access unauthorized database data

Answer

SQL injection occurs when attackers insert malicious SQL code through user input fields, potentially allowing them to read, modify, or delete database data without authorization.

Question 2

What is database partitioning and what problem does it solve?

Accepted Answer

Dividing a large table into smaller, more manageable segments to improve query performance and manageability

Answer

Partitioning divides large tables into smaller segments (by range, hash, or list) so queries can scan only relevant partitions, improving performance and manageability.

Question 3

In the context of NoSQL databases, what does 'eventual consistency' mean?

Accepted Answer

Data updates will propagate to all replicas eventually, but replicas may temporarily serve stale data

Answer

Eventual consistency means that after an update, all replicas will eventually receive it and be consistent, but in the short term, different nodes may return slightly different values.

Question 4

What is 'transparent data encryption' (TDE) in databases?

Accepted Answer

Encrypting the entire database storage files at rest so data is protected if storage media is stolen

Answer

TDE encrypts database storage files at rest, protecting data if physical storage media is stolen or accessed without authorization, transparently to applications.

Question 5

What is the difference between a clustered and non-clustered index in SQL databases?

Accepted Answer

A clustered index determines the physical sort order of table rows; a non-clustered index is a separate structure pointing to data rows

Answer

A clustered index determines the physical order rows are stored in the table (only one per table), while non-clustered indexes are separate lookup structures pointing back to the data rows.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Database Administration and Security 2