Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  file group

Author  Topic  songqh Starting Member 9 Posts Posted - 2001-08-13 : 20:59:15 Question: The database for a check-processing application contains a record for each check that is processed. Each check has an associated image column that is accessed inly when the user requests a disply of the check. You plan to create the following files to the Check database. ========================================================= Logical Drive File name File type C Check0.mdf Primary data file D Check1.ndf Secondary data file D Check2.ndf Secondary data file E Check3.ndf Secondary data file F Check0.ldf Secondary data file ======================================================= Which step or set of steps should you use as strategy for placing tables and indexes? A. Specify the filegroup Default for Placement of all the tables and indexes. B. Add the filegroup Image to the Check database. Add check3.ndf to the filegroup Image. Place the Image column in the filegroup Image. Specify the filegroup Default for placement of all the tables and indexes. C. Add the filegroup Image to the Check database. Add check1.ndf,check2.ndf and check3.ndf to the filegroup Data. Place the Image column in the filegroup Image. Specify the filegroup Data for placement of all the tables and indexes. D. Add the filegroup Data1 to the Check database. which one is correct answer? why ?