(Ex:350-001):

1.You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.
You need to identify which of the servers, in its current configuration, can support additional databases. You need to ensure that your solution fulfills the company's security requirements while allowing for future database growth requirements.
Which server and database combination can be used?
A. SQL3 with the OnlineReadOnly and HR databases
B. SQL4 with the TravelOnline and Storefront databases
C. SQL2 with the Storefront and TravelOnline databases
D. SQL2 with the Storefront and HR databases
Answer: D

3. You need to review the current storage system and decide on the best configuration for the tempdb database on SQL1 to improve tempdb performance. Your solution must ensure that company requirements and policies are fulfilled.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Create a RAID-1 set, and move tempdb to this drive set.
B. Create a RAID-0 set, and move tempdb to this drive set.
C. Set the starting size of tempdb to 3 GB.
D. Create a RAID-0 set, and move tempdb and the user database with the largest index to this drive set.
E. Disable automatic file growth on tempdb.
Answer: C AND A

4. You need to improve the speed of backups on SQL1. Management has approved the purchase of additional hard disks for this server.
What should you do?
A. Configure the hard disks as a RAID-0 array, and store the backups on this new array.
B. Configure the hard disks as a RAID-5 array, and store the backups on this new array.
C. Configure the hard disks as a RAID-10 array, and store the backups on this new array.
D. Configure the hard disks as a spanned volume, and store the backups on this new volume.
E. Use the hard disks to extend the volume that currently holds SQL Server backups.
Answer: A

5. You need to migrate the DeliveryVans, AirlinePreferences, and SeasonalContractors databases into the data center.
What should you do?
A. Install a separate instance of SQL Server 2005 for each of the databases on a single server.
B. Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
C. Import the data from each of the databases into a single database in an instance of SQL Server 2005.
D. Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.
Answer: B

6. You need to design a strategy for identifying the number of instances that any one SQL Server 2005 computer will support.
What should you do?
A. Specify that each server must have one instance for each customer.
B. Specify that each server must each have only one instance.
C. Specify that each server must have one instance for each database that is hosted on that server.
D. Specify that each server must have one instance for each customer who has one or more databases that are hosted on that server.
Answer: D

7. You need to improve the performance of the tempdb database on SQL1.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Move tempdb onto a faster disk volume.
B. Increase the initial size of tempdb to 1.5 GB.
C. Increase the size of the data files in the Tracking database.
D. Decrease the file growth increment for tempdb to 25 MB.
E. Use more local temporary tables and fewer global temporary tables in the Tracking database.
Answer: B AND A

8. You need to identify the combinations of the Windows operating system and SQL Server 2005 version that will be the most appropriate for the new R&D configuration, which will include the Research, Parts, and Engineering databases.
Which two combinations will be the most appropriate? (Each correct answer presents a complete solution. Choose two.)
A. Windows Server 2003 Enterprise Edition with SQL Server 2005 Enterprise Edition
B. Windows Server 2003 Datacenter Edition with SQL Server 2005 Enterprise Edition
C. Windows Server 2003 Standard Edition with SQL Server 2005 Enterprise Edition
D. Windows Server 2003 Enterprise Edition with SQL Server 2005 Standard Edition
Answer: B AND A

2. You plan to create a unique nonclustered index on the CustomerID, LastName, and FirstName columns of the CustomerData.Customers table in the CRM database. To aid in estimating the space requirements for the index, you identify the following variables:
You need to identify the most significant additional variable that will increase the estimated index size.
Which additional variable should you identify?
A. current number of rows
B. null bitmap
C. fill factor
D. automatically generated uniqueifier value
Answer: C