70-448 · Question #62
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…
The correct answer is D. You should perform the backup of the master database. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. There is a SQL Server 2008 instance. Now you are in charge of SQL Server 2008 Integration Services (SSIS) on this instance. Now you get an order from your company, according to the company requirement, a failure recovery plan has to be created for packages that are deployed to a SQL Server. As the IT support, you have to accomplish this task. So what action should be performed?
Options
- AYou should perform the backup of the model database
- BYou should perform the backup of the MSDB database.
- CYou should perform the backup of the tempdb databse
- DYou should perform the backup of the master database
How the community answered
(32 responses)- A16% (5)
- B6% (2)
- C3% (1)
- D75% (24)
Community Discussion
No community discussion yet for this question.