IKM - International Knowledge Measurement Database Administration Concepts Questions and Answers

Question 1

A database administrator is tasked with creating a backup strategy for a critical financial database.
The business has specified a Recovery Point Objective (RPO) of 15 minutes and a Recovery Time Objective (RTO) of 2 hours.
To meet the RPO, which of the following backup methods is MOST crucial to implement frequently?

Accepted Answer

Transaction log backups

Answer

Full weekly backups

Answer

Differential daily backups

Answer

Offline cold backups

Question 2

A database is experiencing slow query performance, specifically on queries involving `WHERE` clauses on non-primary key columns. Which of the following database objects should be created to MOST effectively improve the performance of these queries?

Accepted Answer

An index

Answer

A view

Answer

A stored procedure

Answer

A trigger

Question 3

As part of a security audit, a Database Administrator is reviewing access control policies. Which of the following practices best adheres to the principle of least privilege?

Accepted Answer

Creating a specific role with only `SELECT` permissions on required views for an analytics team.

Answer

Assigning all developers the DBA role in the development environment.

Answer

Granting a reporting user account `SELECT`, `INSERT`, and `DELETE` permissions on all tables.

Answer

Using a single shared user account for all application services to connect to the database.

Question 4

A company's database contains a single 'Projects' table with columns for ProjectID, ProjectName, EmployeeID, EmployeeName, and EmployeeDepartment. This design leads to the employee's name and department being repeated for every project they are assigned to. This is an example of a violation of which database normalization form?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Fourth Normal Form (4NF)

Question 5

Which of the ACID properties of a database transaction ensures that once a transaction has been committed, it will remain so, even in the event of a power loss or system crash?

Accepted Answer

Durability

Answer

Atomicity

Answer

Consistency

Answer

Isolation

Question 6

Which of the following is a core responsibility of a Database Administrator (DBA) related to ensuring data availability?

Accepted Answer

Developing and regularly testing a backup and recovery strategy.

Answer

Writing application-layer business logic.

Answer

Designing the user interface for client applications.

Answer

Performing end-user acceptance testing.