可学答题网 > 问答 > MCTS(70-431)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You use a SQL Ser


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?()

  • AStore 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.
  • BStore 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.
  • CStore 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.
  • DStore 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.
参考答案
参考解析:
分类:MCTS(70-431)题库
相关推荐

1、若a=5,b=3,c=4,逻辑表达式!(a+b)&;&;!c的值

若a=5,b=3,c=4,逻辑表达式!(a+b)&;&;!c的值为()A0B-1C1D2

2、You administer a SQL&e

You administer a SQL Server 2008 instance. You plan to design the security requirements for&ens...

3、You administer a SQL&e

You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has e...

4、You manage a SQL 

You manage a SQL Server 2005 database that contains a table with many indexes. You notice&...

5、You use a Windows&ensp

You use a Windows 2000 Professional portable computer both at the office and at home. In&e...

6、● 假设A、B为布尔变量,对于逻辑表达式( A && B )

● 假设A、B为布尔变量,对于逻辑表达式( A && B ),至少需要(63) 个测试用例才能完成MCDC覆盖。(63)A4B3C2D1