Есть в uCertify 2 идентичных на мой взгляд вопроса, но с разными ответами и объяснениями.

1.
Q. Vou are a developer of a database named Inventory. You have created four queries, which will run at the same time. To improve the performance, you design and create the indexes for the database tables. How will you ensure that you have created useful indexes?
A. Run the Index Tuning Wizard against a workload file that contains the queries used in the reports.
B. Run System Monitor, and use the SQLServer: Access Methods counter.
C. Execute the queries against the tables in SQL Query Analyzer, and use the SHOWPLAN_TEXT option.
D. Create a SQL Profiler trace, and use the Objects event classes.
Analysis. Answer option C is correct. To ensure that you have created useful indexes, run each query in SQL Query Analyzer with SET SHOWPLAN_TEXT option. SET SHOWPLAN_TEXT statements return only query or statement's execution plan information and do not execute the query or statement. The execution plan is very useful for understanding the performance characteristics of a query. Additionally, SQL Query Analyzer shows suggestions for additional indexes and statistics on nonmdexed columns that would improve the ability of the query optimizer to process a query efficiently.


2. Q. Vou work as a Database Developer for uCertify Inc. The company uses SQL Server database to maintain sales information. Vou are designing multiple reports, which will be running simultaneously. Vou write queries for each report and create indexes based on the requirements of the queries. What will you do to ensure that you have created useful indexes?
A. Run System Monitor and use the SQLServer: Access Methods counter.
B. Execute the queries against the tables in SQL Query Analyzer and use the SHOWPLAN_TEXT option.
C. Create a SQL Profiler trace and use the Objects event classes.
D. Run the Index Tuning Wizard against a workload file that contains the queries used in the reports.
Analysis. Answer option D is correct.
Vou should run the index Tuning Wizard against a workload file that contains the queries used in the reports to ensure that you have created useful indexes. The Index Tuning Wizard suggests an optimal set of indexes for a database based on the workload file. A workload file can include SQL scripts or a SQL Profiler trace. The Index Tuning Wizard analyzes the workload and recommends an index configuration that will improve the performance of the database. Vou can match the recommendation with existing set of indexes to determine that you have created useful indexes.
Answer options C and A are incorrect. Vou cannot determine a useful set of indexes by using SQL Profiler trace or System Monitor utility.
Answer option B is incorrect. Executing the queries in SQL Query Analyzer and using the SHOWPLAN_TEXT option will give you a plan for execution, but it will not suggest the index. Although you can conclude the effectiveness of the existing index by studying the query plan, you require good understanding of the SQL Server query plan. Moreover, using this option will not recommend an index configuration that will improve database performance. Hence, this is not a good choice.

Видит ли кто-нибудь между ними разницу? Какой ответ считать верным? Почему? Хочется услышать мнение профессионалов.

Спасибо.

2pkarklin
Полностью поддерживаю. Время одно. Свидетельствует об окончании какого-либо действия в прошлом. Т.е. индексы уже созданы.