Boost the priority of batch jobs.
Schedule batch runs to reduce contention with OLTP.
Schedule OS maintenance such that it includes frequent application of PTFs.
Perform incremental backups of transaction processing and full backups of batch processing.
第1题:
A corporation wants help in reducing backup costs. By proposing a library with LTO-5 drives,which one of the following would be the BEST reason to choose LTO-5 over LTO-4?()
第2题:
A user can no longer launch their word processing program. The program worked fine yesterday.Which of the following options could BEST be used to fix the word processing program?()
第3题:
Which of the following requirements is NOT mentioned in successfully dealing with large volume and variety of transactions?
A.A large number of skillful staff and expertise.
B.Effective internal control system.
C.Complex accounting system.
D.Widespread use of electronic data processing.
第4题:
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?()
第5题:
A system administrator is monitoring a system that has recently shown a decrease in performance.The administrator suspects that the system may be low on memory and may be paging excessively.Which of the following commands is best to identify a possible paging problem?()
第6题:
A user reports that their system is starting to run slower, especially when opening large local files. The system has sufficient RAM for the users applications, but the hard drive seems to have higher than normal activity when opening large files. Which of the following would be the BEST tool to diagnose and troubleshoot this problem? ()
第7题:
When a system has both online transaction processing as well as large batch processing, which of the following common procedures will best help to improve system performance?()
第8题:
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.
第9题:
A retail customer has an 8-core Power 740 server with 2 partitions. Production has 4 dedicated cores and the test partition has 2 dedicated cores. Both partitions run during the day without problems. At night, batch processing is exceeding the run window. Which solution addresses this problem without requiring additional hardware?()
第10题:
There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations?()