You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible.
What should you do？（）

单项选择题You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do？（）

A.Create CHECK constraints on the tables.
B.Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
C.Create the view， specifying the WITH SCHEMABINDING option.
D.Create the view， specifying the WITH CHECK option.

多项选择题TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）

A.ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders
B.DROP TRIGGER trg InsertOrders
C.DISABLE TRIGGER trg InsertOrders ON Orders
D.ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

多项选择题You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50，000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal？（）

A.Place a nonclustered index on the date column.
B.Add a unique clustered index on the date column.
C.Map each partition to a filegroup， with each filegroup accessing a different physical drive.
D.Create a partitioning scheme that partitions the data by date.

单项选择题TestKing.com uses SQL Server 2005. Users report with increasing frequency that they receive deadlock error messages in an order processing application.   You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do？（）

A.Trace the Lock：Timeout event by using SQL Server Profiler.
B.Observe the SQLServer：Locks - Number of Deadlocks/sec counter by using System Monitor.
C.Trace the Lock：Deadlock event by using SQL Server Profiler.
D.Trace the Lock：Deadlock Chain event by using SQL Server Profiler.

单项选择题You use a SQL Server 2005 database named DB1， which is located on a server named SQL1. DB1 is in use 24 hours a day， 7 days a week. A recent copy of DB1 exists on a second server named SQLtest that also runs SQL Server 2005. You detect a high number of full scans on SQL1 and conclude that additional indexes in DB1 are needed. A workload file that is suitable for Database Engine Tuning Advisor （DTA） already exists.   You need to analyze the workload file by using DTA. You must ensure maximum performance on SQL1 during analysis. You must also ensure availability during the implementation of any recommendations suggested by the DTA. What should you do？（）

A.Store the workload file on SQL1. Start DTA on SQLtest and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box， select the Generate only online recommendations check box.
B.Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box,select the generate only online recommendations check box.
C.Store the workload file on SQL1. Start DTA on SQL1 and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box，select the All recommendations are offline check box.
D.Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest.Specify all workload and tuning options as necessary.In the Advanced Tuning Options dialog box,select the All recommendations are offline check box.