You are the administrator of your company network. And you’re in charge of SQL Server 2008 instance. You intend to deploy a new database to the instance. The data will have lots of schemas and will be subject to frequent inserts and updates. One schema will contain plenty of reference data. In order to optimize backup performance, you have to design the physical database structure. So what should you do?
A.
You should use a single data file and a single log file to develop the database.
B.
You should use a single log file and multiple filegroups to develop the database.
C.
You should use a single data file and multiple log files to develop the database.
D.
You should use a single log file and a filegroup which has multiple data files to develop a the database.