HP2-T16 · Question #96

What happens during a normal backup? (Select two)

The correct answer is C. The archive bit is reset to 0. D. The transaction log is cleared. Industry Standard Architecture - Student Guide 2 - Page 298: Normal backup - Backs up files and resets the archive bit. The archive bit is used to determine if the file has been backed up or not. A normal backup backs up database files and then the transaction log files. It…

Common IT Terminology, Standards, and Best Practices

Question

Options

AThe archive bit is set to 1.
BThe archive bit is left alone.
CThe archive bit is reset to 0.
DThe transaction log is cleared.
EThe transaction log is left alone.

How the community answered

(33 responses)

A
6% (2)
B
3% (1)
C
76% (25)
E
15% (5)

Explanation

Industry Standard Architecture - Student Guide 2 - Page 298: Normal backup - Backs up files and resets the archive bit. The archive bit is used to determine if the file has been backed up or not. A normal backup backs up database files and then the transaction log files. It then deletes the transaction log files from the directory. You can have circular logging disabled because your backup software deletes the log files. Therefore, if you are performing regular backups, you will not have a problem with log files filling your drive.

Topics

#normal backup#archive bit#transaction log#backup types

Community Discussion

No community discussion yet for this question.

Full HP2-T16 Practice