70-450 · Question #89
You are a professional level SQL Sever 2008 Database Administrator. A new database will be deployed to the instance. Regular inserts and updates should be subjected by the database. There will be…
The correct answer is A. You should utilize a single log file and multiple filegroups to create the database. In order to be able to backup filegroups with different schedules, the easiest way is to create multiple lilegroups and only one log file. Putting the read-only data in a separate read-only filegroup will increase the performance of the database. Read-only filegroups do not…
Question
You are a professional level SQL Sever 2008 Database Administrator. A new database will be deployed to the instance. Regular inserts and updates should be subjected by the database. There will be multiple schemas on the database. A great number of read-only reference data should be contained by one of the schemas. The physical database structure should be designed for optimal backup performance. Which action should you perform?
Options
- AYou should utilize a single log file and multiple filegroups to create the database.
- BYou should utilize a single data file and a single log file to create the database.
- CYou should utilize a single data file and multiple log files to create the database.
- DYou should utilize a single log file and a filegroup that has multiple data files to create the
How the community answered
(18 responses)- A83% (15)
- B11% (2)
- D6% (1)
Explanation
In order to be able to backup filegroups with different schedules, the easiest way is to create multiple lilegroups and only one log file. Putting the read-only data in a separate read-only filegroup will increase the performance of the database. Read-only filegroups do not suffer from contention or locking issues.
Topics
Community Discussion
No community discussion yet for this question.