单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）A to prevent the creation of an excessive number of scheduler job classesB to allow the Automated M

题目
单选题
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）
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

相似考题

1.Which tasks are run automatically as part of the Automated Maintenance Task by default?()A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor

2.Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.)A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor

3.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 belongsB. Increasing the job‘s relative priority within the Job class to which it belongsC. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler windowD. Moving the job to an existing higher priority scheduler window with the same schedule and durationE. Increasing the value of the JOB_QUEUE_PROCESSES parameterF. Increasing the priority of the scheduler window to which the job belongs

4.The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()A. to prevent the creation of an excessive number of scheduler job classesB. to allow the Automated Maintenance Tasks to use system resources without any restrictionC. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）A to prevent the creation of an excessive number of scheduler job classesB to allow the Automated M”相关问题

  • 第1题：

    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.


    正确答案：A
    解析：Explanation: Transfers can be defined and stored in a DTS package, which can then be run from a command line using the dtsrun utility (DTSRUN.EXE). CmdExec job steps are operating system commands or executable programs ending with .bat, .cmd, .com, or .exe. In this scenario we create a job consisting of a single cmdexec job step which runs the DTS package using the dtsrun utility.

    Incorrect answers:
    B: Only one job, not two, has to be created at the OLTP database server.

    C: If the Task Scheduler is running as the local system account it wouldn’t be able to access the remote OLAP database server.

    D: The DTS export package should be run at the OLTP database server, not at the OLAP database server. The DTS package is exported from the OLTP server to the OLAP server.

  • 第2题：

    Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)

    • A、Segment Advisor
    • B、SQL Access Advisor
    • C、Optimizer statistics gathering
    • D、Automatic SQL Tuning Advisor
    • E、Automatic Database Diagnostics Monitor

    正确答案:A,C,D

  • 第3题：

    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）

    • 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

    正确答案:D

  • 第4题：

    Which tasks are run automatically as part of the Automated Maintenance Task by default？（） 

    • A、 Segment Advisor
    • B、 SQL Access Advisor
    • C、 Optimizer statistics gathering
    • D、 Automatic SQL Tuning Advisor
    • E、 Automatic Database Diagnostics Monitor

    正确答案:A,C,D

  • 第5题：

    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

    正确答案:B,C

  • 第6题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）

    • A、You should create a job which is assigned to the Database Maintenance category
    • B、You should create an Alert which will run another to delete the maintenance job.
    • C、You should create a job. You schedule the job to run only once.
    • D、You should create a job. The job uses the Automatically delete job option

    正确答案:D

  • 第7题：

    多选题
    Which tasks are run automatically as part of the Automated Maintenance Task by default?（）
    A

    Segment Advisor

    B

    SQL Access Advisor

    C

    Optimizer statistics gathering

    D

    Automatic SQL Tuning Advisor

    E

    Automatic Database Diagnostics Monitor


    正确答案： B,C
    解析： 暂无解析

  • 第8题：

    多选题
    Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)
    A

    Segment Advisor

    B

    SQL Access Advisor

    C

    Optimizer statistics gathering

    D

    Automatic SQL Tuning Advisor

    E

    Automatic Database Diagnostics Monitor


    正确答案： D,C
    解析： 暂无解析

  • 第9题：

    单选题
    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）
    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


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）
    A

    The statistics collection continues until all objects are processed.

    B

    The job is terminated and the statistics collected are restored to a time before the job started.

    C

    This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.

    D

    The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）
    A

    For the SQL Server Agent, you should enable a fail-safe operator 

    B

    You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 

    C

    You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 

    D

    You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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？（）
    A

     Window

    B

     Program

    C

     Job_Class

    D

     Window group


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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?（）

    • A、Ask the plant maintenance manager about the company's history, competition, and market value.
    • B、Ask the plant maintenance manager about their background, education, and professional experience.
    • C、Ask the plant maintenance manager about current systems in use, issues with the system,and key areas where the manager wants to see improvements.  
    • D、Ask the plant maintenance manager about the number of employees, union representation, and how IBM Maximo Asset Management can represent employees and their skill sets.

    正确答案:C

  • 第14题：

    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？（）  

    • A、 Window
    • B、 Program
    • C、 Job_Class
    • D、 Window group

    正确答案:A

  • 第15题：

    Which two statements are true with respect to the maintenance window？（） .

    • A、 A DBA can enable or disable an individual task in all maintenance windows.
    • B、 A DBA cannot change the duration of the maintenance window after it is created.
    • C、 In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.
    • D、 A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window

    正确答案:A,D

  • 第16题：

    Which two statements are true with respect to the maintenance window? （）

    • A、A DBA can enable or disable an individual task in all maintenance windows.
    • B、A DBA cannot change the duration of the maintenance window after it is created.
    • C、In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
    • D、A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

    正确答案:A,D

  • 第17题：

    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects.  Which statement is true in this scenario（）

    • A、The statistics collection continues until all objects are processed.
    • B、The job is terminated and the statistics collected are restored to a time before the job started.
    • C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
    • D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.

    正确答案:D

  • 第18题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）

    • A、For the SQL Server Agent, you should enable a fail-safe operator 
    • B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 
    • C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 
    • D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

    正确答案:D

  • 第19题：

    单选题
    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects.  Which statement is true in this scenario（）
    A

    The statistics collection continues until all objects are processed.

    B

    The job is terminated and the statistics collected are restored to a time before the job started.

    C

    This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.

    D

    The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）
    A

    You should create a job which is assigned to the Database Maintenance category

    B

    You should create an Alert which will run another to delete the maintenance job.

    C

    You should create a job. You schedule the job to run only once.

    D

    You should create a job. The job uses the Automatically delete job option


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this？（）
    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


    正确答案： A
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements are true with respect to the maintenance window？（） .
    A

    A DBA can enable or disable an individual task in all maintenance windows.

    B

    A DBA cannot change the duration of the maintenance window after it is created.

    C

    In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.

    D

    A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window


    正确答案： B,A
    解析： 暂无解析

  • 第23题：

    多选题
    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


    正确答案： D,A
    解析： 暂无解析

  • 第24题：

    单选题
    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?（）
    A

    Ask the plant maintenance manager about the company's history, competition, and market value.

    B

    Ask the plant maintenance manager about their background, education, and professional experience.

    C

    Ask the plant maintenance manager about current systems in use, issues with the system,and key areas where the manager wants to see improvements.  

    D

    Ask the plant maintenance manager about the number of employees, union representation, and how IBM Maximo Asset Management can represent employees and their skill sets.


    正确答案： A
    解析： 暂无解析

相关内容