to prevent the creation of an excessive number of scheduler job classes
to allow the Automated Maintenance Tasks to use system resources without any restriction
to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
第1题:
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor
第2题:
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.
You want the package to execute automatically each evening at 8:00 P.M. What should you do?
A.Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B.Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
C.Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D.Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
第3题:
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor
第4题:
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()
第5题:
Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.)
第6题:
You notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a scheduler job class and window.Which two actions would reduce the job‘s elapsed time?()
A. Increasing the priority of the job class to which the job belongs
B. Increasing the job‘s relative priority within the Job class to which it belongs
C. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler window
D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
F. Increasing the priority of the scheduler window to which the job belongs
第7题:
A customer's plant maintenance manager invites a solution advisor to discuss Enterprise Asset Management in general and how it might help the maintenance group work more effectively and efficiently. What should the solution advisor do in the first meeting with the plant maintenance manager?()
第8题:
A. to prevent the creation of an excessive number of scheduler job classes
B. to allow the Automated Maintenance Tasks to use system resources without any restriction
C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
第9题:
Your system performs heavy transaction processing between 8:00 A.M. and 5:00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans?()
第10题:
Which two statements are true with respect to the maintenance window?() .