【单选题】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 al...
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.
【单选题】You need to make structural changes to the cube. You also need to ensure that appropriate aggregations are created after the changes are made. What should you do?()
A.
Record a weeks user activity by using SQL Profiler. Apply structural changes. Replay the activity and then run the Usage Based Optimization Wizard.
B.
Apply structural changes. Run the Database Engine Tuning Advisor.
C.
Apply structural changes. Run the Usage Based Optimization Wizard.
D.
Record a weeks user activity by using SQL Profiler. Apply structural changes. Run the Database Engine Tuning Advisor.
【判断题】轻型燃气轮机,又称航机改型燃气轮机:以航空涡轮发动机为基础发展而来;转速通常为8000∼30000RPM,一般需设减速装置驱动离心压缩机。Light gas turbine, also known as aircraft variant gas turbine: based on the development of aviation turbine engine; Speed is usuall...