The workload requirement for a Web server running in Micro-Partitioned p5-550 has increased 300 percent over the past six months. The initial partition definitions assigned 0.5 processing units and one virtual processor to the Web server partition. Three

题目

The workload requirement for a Web server running in Micro-Partitioned p5-550 has increased 300 percent over the past six months. The initial partition definitions assigned 0.5 processing units and one virtual processor to the Web server partition. Three months previously， an additional 0.5 CPU was added to the Web server partition. When the technical specialist attempted to allocate a further 0.5 CPU to this partition， no additional performance was achieved. Which of the following actions would most likely resolve the problem？（）

  • A、Add another virtual Ethernet.
  • B、Change the partition to be uncapped.
  • C、Change the number of virtual processors to 2.
  • D、Increase the amount of memory assigned to the partition by 300 percent.
相似考题

1.You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?()A. the SQL text SQLB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN)

2.Which two statements about workload capture and replay operations are true?()A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

3.Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B. Run the Automatic Workload Repository Monitor (ADDM).C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

4.What is the outcome of this block of code?()A. It creates a task and workload, and executes the task.B. It creates a task and workload but does not execute the task.C. It produces an error because a template has not been created.D. It produces an error because the SQL Tuning Set has not been created.

更多“The workload requirem”相关问题

  • 第1题：

    Which command starts Workload Manager?()

    A.wlmrun

    B.wlmstart

    C.wlmcntrl

    D.wlmstartup


    参考答案：C

  • 第2题：

    Companycom is converting an application over to a p5 595 server with LPARs and has underestimated the processor requirements. The system has COD processors, but the customer does not know how to size the workload. What course of action would help identify the processor requirement?（）

    • A、Activate the Trial COD for the processors and run a test to verify outcome
    • B、Activate the On/Off COD for the processors and run a test to verify outcome
    • C、Use rmss to simulate the processor workload and run a test to verify outcome
    • D、Use rmps to simulate the processor workload and run a test to verify outcome

    正确答案:A

  • 第3题：

    What are two circumstances for which it may be advisable to use the  silent uninstallation method instead of an interactive method？（）

    • A、 The Administrator is unable to successfully export DISPLAY to a  remote server.
    • B、 IBM Tivoli Workload Scheduler is installed on a server for which  there is no console access.
    • C、 DNS is not working properly and the server cannot be accessed  remotely to run the uninstallation script.
    • D、 TCP on the server on which IBM Tivoli Workload Scheduler is  installed is configured for half-duplex rather than full-duplex.
    • E、 The remote IBM Tivoli Workload Scheduler server is multi-homed， thus  the return connection to IBM Tivoli Workload Scheduler cannot be  established thereby requiring the use of the silent  uninstaller.

    正确答案:A,B

  • 第4题：

    Which command starts Workload Manager？（）

    • A、wlmrun
    • B、wlmstart
    • C、wlmcntrl
    • D、wlmstartup

    正确答案:C

  • 第5题：

    Which of the following virtualization options are unique to AIX and PowerVM compared to other UNIX based offerings？（）

    • A、Software virtualization through PowerVM and hardware virtualization through IBM Systems Director.
    • B、Hardware virtualization through Workload Partitions （WPARS） and software virtualization through PowerVM.
    • C、Software virtualization through Workload Partitions （WPARS） and hardware virtualization through PowerVM.
    • D、Hardware virtualization through Workload Partitions （WPARS） and software virtualization through IBM Systems Director.

    正确答案:C

  • 第6题：

    Which two prerequisites are needed for performing workload capture and replay？（）

    • A、Close all sessions performing queries using database links
    • B、running the database in shared server mode
    • C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
    • D、setting up the directory to capture the workload

    正确答案:C,D

  • 第7题：

    You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

    • A、the SQL text SQL
    • B、the execution plan
    • C、the execution context
    • D、the execution frequency
    • E、the system change number (SCN)

    正确答案:A,C,D

  • 第8题：

    单选题
    The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）
    A

    by using the SQL access advisor

    B

    by using the Automatic Workload Repository report

    C

    by running the Automatic Database Diagnostic Monitor （ADDM）

    D

    by using the Automatic Workload Repository Compare Period report

    E

    by analyzing the output of the V$ACTIVE_SESSION_HISTORY view


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

  • 第9题：

    单选题
    What is the location for the application server scripts？ （）
    A

     wastools directory in IBM Tivoli Workload Scheduler bin directory

    B

     wastools directory in IBM Tivoli Workload Automation home directory

    C

     appserver directory in IBM Tivoli Workload Scheduler parent  directory

    D

     appserver directory in IBM Tivoli Workload Automation home directory


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

  • 第10题：

    多选题
    Which two prerequisites are needed for performing workload capture and replay？（）
    A

    Close all sessions performing queries using database links

    B

    running the database in shared server mode

    C

    The database on which the workload is replayed has to be a restore of the original database to a specific SCN

    D

    setting up the directory to capture the workload


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

  • 第11题：

    单选题
    Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload：   1） Preprocess the captured workload.  2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients.  4） Restore the test database to the point when the capture started.  5） Remap connections.   Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）
    A

     1，4，5，3 （2 is not required.）

    B

     1，4，3，5 （2 is not required.）

    C

     1，2，4，5 （3 is not required.）

    D

     2，1，5，3，4 

    E

     1，2，4，5，3


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

  • 第12题：

    单选题
    A system administrator has a pSeries p5-520 2-way with AIX 5L V5.2 with a peak utilization of 50%. There is a request to add a new Web server for a small department. Which of the following solutions is the best fit for this environment？（）
    A

    Create a dedicated LPAR for the existing workload and a Micro-Partition for the Web server. 

    B

    Create a dedicated LPAR for the existing workload and a dedicated LPAR for the Web server.

    C

    Create a Micro-Partition for the existing workload and a dedicated LPAR for the Web server.

    D

    Create a Micro-Partition for the existing workload and a Micro-Partition for the Web server.


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

  • 第13题：

    What is the purpose of configuring Workload Manager on a server used for development and QA？（）  

    • A、To experiment with shared processor pools
    • B、To isolate physical hardware between workloads
    • C、To control resource utilization on an application-by-application basis
    • D、To leverage Workload Partition Manager for performance trending and analysis

    正确答案:C

  • 第14题：

    The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）

    • A、by using the SQL access advisor
    • B、by using the Automatic Workload Repository report
    • C、by running the Automatic Database Diagnostic Monitor （ADDM）
    • D、by using the Automatic Workload Repository Compare Period report
    • E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

    正确答案:D

  • 第15题：

    A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

    • A、db2advis -d proddb -i workload.sql -P  
    • B、db2advis -d proddb -i workload.sql -partitioning  
    • C、db2advis -d proddb -i workload.sql -m P  
    • D、db2advis -d proddb -i workload.sql -m ALL 

    正确答案:C

  • 第16题：

    What is the location for the application server scripts？ （）

    • A、 wastools directory in IBM Tivoli Workload Scheduler bin directory
    • B、 wastools directory in IBM Tivoli Workload Automation home directory
    • C、 appserver directory in IBM Tivoli Workload Scheduler parent  directory
    • D、 appserver directory in IBM Tivoli Workload Automation home directory

    正确答案:B

  • 第17题：

    Which of the following interfaces is required to implement Workload Partition Mobility? （）

    • A、 Workload Partitions Manager for AIX
    • B、 Hardware Management Console （HMC） GUI
    • C、 Integrated Virtualization Manager （IVM）
    • D、 Advanced System Management Interface （ASMI）

    正确答案:A

  • 第18题：

    The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

    • A、 LOG_BUFFER
    • B、 DB_CACHE_SIZE
    • C、 JAVA_POOL_SIZE
    • D、 LARGE_POOL_SIZE
    • E、 SHARED_POOL_SIZE
    • F、 STREAMS_POOL_SIZE

    正确答案:A,F

  • 第19题：

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

    • 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.

    正确答案:B

  • 第20题：

    单选题
    What is the purpose of configuring Workload Manager on a server used for development and QA?（）
    A

    To experiment with shared processor pools

    B

    To isolate physical hardware between workloads

    C

    To control resource utilization on an application-by-application basis

    D

    To leverage Workload Partition Manager for performance trending and analysis


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

  • 第21题：

    多选题
    What are two circumstances for which it may be advisable to use the  silent uninstallation method instead of an interactive method？（）
    A

    The Administrator is unable to successfully export DISPLAY to a  remote server.

    B

    IBM Tivoli Workload Scheduler is installed on a server for which  there is no console access.

    C

    DNS is not working properly and the server cannot be accessed  remotely to run the uninstallation script.

    D

    TCP on the server on which IBM Tivoli Workload Scheduler is  installed is configured for half-duplex rather than full-duplex.

    E

    The remote IBM Tivoli Workload Scheduler server is multi-homed， thus  the return connection to IBM Tivoli Workload Scheduler cannot be  established thereby requiring the use of the silent  uninstaller.


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

  • 第22题：

    多选题
    You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）
    A

    the SQL text

    B

    the execution plan

    C

    the execution context

    D

    the execution frequency

    E

    the system change number （SCN）


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

  • 第23题：

    单选题
    Which of the following interfaces is required to implement Workload Partition Mobility? （）
    A

     Workload Partitions Manager for AIX

    B

     Hardware Management Console （HMC） GUI

    C

     Integrated Virtualization Manager （IVM）

    D

     Advanced System Management Interface （ASMI）


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

  • 第24题：

    多选题
    Which two statements about workload capture and replay operations are true?（）
    A

    The clients must be created manually on the test machines to perform more realistic testing.

    B

    Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

    C

    Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

    D

    The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.


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

相关内容