Microsoft TS:MS SQL Server 2008,Implementation and Maintenance 認定 70-432 試験問題:

1. You administer a SQL Server 2008 instance. The server hosts databases for several mission-critical applications.
You plan to use the Resource Governor to limit the effect of queries that are executed by Microsoft SQL Server Management Studio.
You need to ensure that that the following requirements are met:
- Queries initiated through SQL Server Management Studio do not exceed 20 percent of CPU utilization. - Queries initiated by the mission-critical applications are allowed to consume 100 percent of CPU utilization when required.
What should you do?

A) Alter the default resource pool and set the MAX_CPU_PERCENT option to 20.
Assign this resource pool to the workload group used by the mission-critical applications.
B) Create a new resource pool and set the MAX_CPU_PERCENT option to 20.
Assign this resource pool to the workload group used by SQL Server Management Studio.
C) Create a new resource pool and set the MAX_CPU_PERCENT option to 80.
Assign this resource pool to the workload group used by the mission-critical applications.
D) Alter the default resource pool and set the MAX_CPU_PERCENT option to 80.
Assign tins resource pool to the workload group used by SQL Server Management Studio.

2. You administer a Microsoft SQL Server 2008 R2 instance.
You need to attach a database named Northwind to the server.
Which Transact-SQL command should you use?

A) Option A
B) Option C
C) Option D
D) Option B

3. You maintain a SQL Server 2008 instance that contains a database named OrderEntry. The OrderEntry database contains a table named OrderDelivery.
You add a column named DeliveryPoint to the OrderDelivery table. The DeliveryPoint column is of the Geography data type. The OrderDelivery table does not contain indexes.
You need to create a spatial index on the DeliveryPoint column.
What should you do first?

A) Ensure that the DeliveryPoint column does not allow NULL values.
B) Create a clustered index for the OrderDelivery table.
C) Copy the OrderDelivery data to a temporary table and truncate the existing
OrderDelivery table.
D) Define a primary key for the OrderDelivery table.

4. You are mastering the company database. During the development, you find that Transact-SQL query below is running slowly:SELECT VideoTitle, UpcNum, RetailPrice, Release Date FROM Srvideo.VideoTitle WITH (INDEX(0)) WHERE ReleaseDate BETWEEN '20050401' AND '20050510' A clustered index exists on the VideoTitle column.
There is a nonclustered index on the ReleaseDate column which contains the UpcNum and RetailPrice columns. The result of the avg_fragmentation_in_percent is 30 percent, when you search the sys.dm_db_index_physical_stats dynamic management function (DMF) or the VideoTitle table,In order to find this method to solve this problem, which is the correct answer?

A) You should alter the query hint to force the optimizer to force a unclustered index seek.
B) You should Re-create the index on only the ReleaseDate column.
C) You should delete the query hint from the query.
D) You should reproduce the whole indexes on the VideoTitle table.

5. You administer a SQL Server 200S instance. A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked. Which tool should you use?

A) The Activity Monitor tool in Microsoft SQL Server Management Studio
B) The Windows System Monitor tool
C) The Database Engine Tuning Advisor tool
D) The Job Activity Monitor tool in Microsoft SQL Server Management Studio

質問と回答：