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?
A.
You should utilize a single log file and multiple filegroups to create the database.
B.
You should utilize a single data file and a single log file to create the database.
C.
You should utilize a single data file and multiple log files to create the database.
D.
You should utilize a single log file and a filegroup that has multiple data files to create the
database.