A Database Server Is Configured with the Database Files Residing

question 442

Multiple Choice

A database server is configured with the database files residing on a separate partition to meet vendor recommendations. The following schedule is used for system backup: Full backup Saturday at 12:00 a.m. Differential backup daily Sunday through Friday at 12:00 a.m. Database backups daily at 12:00 a.m. New data is loaded into the database on Monday night, and OS patches are installed on Tuesday night. On Wednesday, it is discovered that the data loaded into the database on Monday is corrupted, and the database needs to be restored from Sunday's backup. Which of the following backup types would BEST allow restoration of the database without affecting the OS patches installed on Tuesday?

• A) Restore the differential backup from Tuesday
• B) Restore the server from Saturday's full backup
• C) Restore the server from Tuesday's snapshot
• D) Restore the database backup from Monday

---

Definitions:

Social Lives

The part of a person's time spent engaging in interpersonal relationships with friends and acquaintances outside of work and family commitments.

Visible

Easily seen or noticed; apparent to the senses or mind.

Political Function

The role an entity or process serves within the arena of politics, often related to governance, decision-making, or influence.

Blake and Mouton

Creators of the Managerial Grid Model, which emphasizes two dimensions of leadership style: concern for people and concern for production, used for understanding and categorizing management or leadership styles.