You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.
You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.
The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.
Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)
On drive D, create a data file in the PRIMARY filegroup.
On drive E, create a data file in the SECONDARY filegroup.
On each drive, create a data file in the PRIMARY filegroup.
On drive E, create a data file in the PRIMARY filegroup.
On the SECONDARY filegroup, create all other tables and their indexes.