IBM
C2090-558 · Question #104
Click the Exhibit button. An administrator created a table using the SQL statement shown in the exhibit to perform a load operation every day at 11:00 AM. What is the best way to optimize a backup…
The correct answer is B. a level-0 backup soon after the load operation. See the full explanation below for the reasoning.
Question
Click the Exhibit button. An administrator created a table using the SQL statement shown in the exhibit to perform a load operation every day at 11:00 AM. What is the best way to optimize a backup strategy to recover the client table in case of a failure?
Exhibit
Options
- Aa level-1 backup at 6:00 AM everyday
- Ba level-0 backup soon after the load operation
- Ca level-1 backup on Sunday and continuous log backup
- Da level-2 backup at 6:00 AM every day and continuous log backup
How the community answered
(23 responses)- A13% (3)
- B78% (18)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.