Microsoft
70-432 · Question #82
You are the administrator of a SQL Server 2008 instance with a database named Finance. The Finance database currently contains 100 GB of data. On an average, 1 GB of data is modified or inserted…
The correct answer is B. Perform a full database backup once daily. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named Finance. The Finance database currently contains 100 GB of data. On an average, 1 GB of data is modified or inserted daily.The recovery model of the Finance database is set to Simple. Business requirements specify that data loss of more than two hours worth of transactions during business hours is unacceptable. You need to select a backup strategy that uses the least amount of disk space by adhering to the business requirements. What should you do?
Options
- APerform a full database backup once daily.
- BPerform a full database backup once daily.
- CPerform a full database backup once daily.
- DPerform a full database backup once every week.
How the community answered
(28 responses)- A11% (3)
- B71% (20)
- C4% (1)
- D14% (4)
Community Discussion
No community discussion yet for this question.