You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance should be managed by you. 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.