1. Правильнольно ли следующее утверждение?
авторThe index Tuning Wizard is used for analyzing and Tuning indexes.
It can't be used to make reports on specific queries.

А вообще весь вопрос выглядет так:

You are a database developer for an SQL Server 2000 database. You are planning to add new indexes, drop some indexes, and change other indexes to composite and covering indexes. For documentation purposes, you must create a report that shows the indexes used by queries before and after you make changes.


What should you do?

A. Execute each query in SQL Query Analyzer, and use the SHOWPLAN_TEXT option. Use the output for the report.
B. Execute each query in SQL Query Analyzer, and use the Show Execution Plan option. Use the output for the report
C. Run the Index Tuning Wizard against a Workload file. Use the output for the report
D. Execute the DBCC SHOW_STATISTICS statement. Use the output for the report

Ans:C
Testking said A

Можете пояснить, какой ответ правильный?

2.You are a database developer for Proseware,Inc. You are creating a database named Human Resources for the company. This database will contain all employee records and demographics information. The company has 2,000 employees and experiences a yearly turnover rate of about 2 percent. When employees leave the company, all of their records must be retained for auditing purposes. Employee demographics information changes at a yearly rate of about 9 percent. You do not need to maintain a history of demographics changes.



The scripts that will be used to create the indexes are shown below:



ALTER TABLE [dbo].[Employee] WITH NOCHECK ADD

CONSTRAINT [pk_Employee] PRIMARY KEY CLUSTERED

([EmployeeID])

WITH FILLFACTOR = 90

GO

ALTER TABLE [dbo].[EmployeeDemographics] WITH NOCHECK ADD

CONSTRAINT [dbo].[EmployeeDemographics] PRIMARY KEY CLUSTERED

([EmployeeID])

WITH FILLFACTOR = 90

GO



You want to conserve disk space and minimize the number of times that expansion of the database files needs to occur. All varchar columns are 50 percent full.



Which two parameters should you specify for the CREATE DATABASE statement? (Each correct answer presents part of the solution. Choose two)

A. SIZE = 1GB
B. SIZE = 1MB
C. SIZE= 2048KB
D. FILEGROWTH = 20
E. FILEGROWTH = 5%
F. FILEGROWTH = 0

Answers: C,E

Почему C,E? По моему B,E.
В тесткинге объясняют, что используется меньше чем 1 мегабайт, поэтому 2 вполне достаточно:)