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

A method to insert bulk data efficiently into databases

Answer

A technique for optimizing SQL queries

Answer

A database replication method

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

Splitting a database into multiple files for backup purposes

Answer

Creating separate databases for each user

Answer

Encrypting parts of a database with different keys

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

The database will eventually be shut down for maintenance

Answer

The database schema will eventually be normalized

Answer

All queries will eventually be optimized automatically

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

Encrypting only specific sensitive columns in a table

Answer

Encrypting data during transmission over the network

Answer

Making encryption keys visible to database administrators

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

Clustered indexes are faster; non-clustered are more secure

Answer

Clustered indexes are used for strings; non-clustered for numbers

Answer

A table can have unlimited clustered indexes but only one non-clustered

Question 6

What is 'principle of least privilege' in database access control?

Accepted Answer

Granting users only the minimum permissions required to perform their job functions

Answer

Granting all users read access to all tables

Answer

Restricting database access to only privileged administrators

Answer

Granting permissions for the least-used database objects