单选题Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）A Visual ExplainB Activity MonitorC SQL Performance MonitorD DB2 Performance Monitor

题目
单选题
Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）
A

Visual Explain

B

Activity Monitor

C

SQL Performance Monitor

D

DB2 Performance Monitor

相似考题

1.Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5／OS database?()A.Visual ExplainB.Activity MonitorC.SQL Performance MonitorD.DB2 Performance Monitor

2.Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?（）A、Design AdvisorB、Visual ExplainC、Performance AdvisorD、Configuration Assistant

3.An administrator determines that performance has degraded for a WebSphere Commerce database.  Which of the following steps should be performed to correct this problem？（）A、Cleanup obsolete dataB、Clear the WebSphere Commerce cacheC、Enable WebSphere Commerce AcceleratorD、Reindex the database tablesE、Run Performance Monitor to monitor SQL statements

4.Which of the following tools can make recommendations for indexes and／or MQTs to improve the performance of DB2 applications?()A.Design AdvisorB.Visual ExplainC.Performance AdvisorD.Configuration Assistant

更多“单选题Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）A Visual ExplainB Activity MonitorC SQL Performance MonitorD DB2 Performance Monitor”相关问题

  • 第1题：

    Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）

    • A、Visual Explain
    • B、Activity Monitor
    • C、SQL Performance Monitor
    • D、DB2 Performance Monitor

    正确答案:C

  • 第2题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） 

    • A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 
    • B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 
    • C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 
    • D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 

    正确答案:B

  • 第3题：

    Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）

    • A、DB2 for i5/OS
    • B、DB2 Runtime Client
    • C、DB2 Connect Enterprise Edition
    • D、DB2 for i5/OS SQL Development Kit

    正确答案:A

  • 第4题：

    WebSphere Application Server supports performance data collection using the Performance Monitoring Infrastructure （PMI）.  Which tool supports PMI and would be best to analyze the WebSphere Commerce runtime EJB， JVM and thread pool stats？（）

    • A、WebSphere Commerce Analyzer
    • B、Tivoli Performance Viewer.
    • C、Tivoli Web Site Analyzer.
    • D、DB2 Intelligent Miner for Data.

    正确答案:B

  • 第5题：

    A Windows Azure application connects to a SQL Azure database.  Connections to the database are being dropped due to throttling.   You need to recommend an approach for identifying the root cause of the problem.   Which two actions should you recommend？（）

    • A、 Use Dynamic Management Views to analyze performance issues.
    • B、 Decrease the connection timeout in the database connection string.
    • C、 Make sure the application is closing database connections that are not needed.
    • D、 Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.

    正确答案:A,C

  • 第6题：

    You are a database administrator for your company. The company runs a popular database-driven Web site against a SQL Server 2005 computer named SQL2. You need to ensure a quick response time and appropriate audit trail in the event that SQL2 experiences excessive traffic due to denial-of-service （DoS） attacks. Which two actions should you perform？（）

    • A、Create a new performance alert to monitor the Current Bandwidth counter.
    • B、Create a new performance alert to monitor the Bytes Total/sec counter.
    • C、Configure the new performance alert to start a SQL Server Profiler trace.
    • D、Configure the new performance alert to start a Network Monitor capture.

    正确答案:B,D

  • 第7题：

    You have a computer that runs Windows 7. You need to identify the disk, memory, CPU, and networkresources that an application is currently using.  Which tool should you use?（）

    • A、Component Services
    • B、Performance Information and Tools
    • C、Reliability Monitor
    • D、Resource Monitor

    正确答案:D

  • 第8题：

    单选题
    You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003. A server named TestKing2 functions as an application server. Users in the TestKing marketing department use an application on TestKing2 to analyze data. The application produces a high volume of disk activity. You give access to 15 new users for the application on TestKing2. Users in the TestKing marketing department report unacceptable delays when they use the application during periods of peak activity. You use System Monitor to analyze the performance of TestKing2. You need to ensure that TestKing2 can support the new users. Which counter should you monitor?（）
    A

    The % Disk Time counter for the PhysicalDisk performance object

    B

    The Current Disk Queue Length counter for the PhysicalDisk performance object

    C

    The Free Megabytes counter for the LogicalDisk performance object

    D

    The Disk Transfers/sec counter for the LogicalDisk performance object


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

  • 第9题：

    单选题
    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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （）
    A

    You should use Dynamic Management Views 

    B

    You should use SQL Server Resource Governor 

    C

    You should use SQL Server Profiler 

    D

    You should use Windows System Monitor


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

  • 第10题：

    单选题
    A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）
    A

     Use the SQL Server Profiler to capture all SQL activities.

    B

     Use a Dynamic Management View to analyze performance.

    C

     Use the Database Engine Tuning Advisor to analyze the workload.

    D

     Use Microsoft SQL Server Management Studio to analyze the SQL logs.


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

  • 第11题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （）
    A

    You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 

    B

    You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 

    C

    You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 

    D

    You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 


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

  • 第12题：

    单选题
    Which statement is true about a DB2 user that is to be used as the database user for IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server？（）
    A

    The database user must be created using DB2 Control Center.

    B

    The database user must be created using the DB2 Command Line Processor.

    C

    The database user may be created using DB2 Control Center or DB2 Command Line Processor.

    D

    The database user must be created by IBM Tivoli Access Manager for Enterprise Single Sign-On V8.0.1 IMS Installer.


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

  • 第13题：

    A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）

    • A、 Use the SQL Server Profiler to capture all SQL activities.
    • B、 Use a Dynamic Management View to analyze performance.
    • C、 Use the Database Engine Tuning Advisor to analyze the workload.
    • D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.

    正确答案:B

  • 第14题：

    Which statement is true about a DB2 user that is to be used as the database user for IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server？（）

    • A、The database user must be created using DB2 Control Center.
    • B、The database user must be created using the DB2 Command Line Processor.
    • C、The database user may be created using DB2 Control Center or DB2 Command Line Processor.
    • D、The database user must be created by IBM Tivoli Access Manager for Enterprise Single Sign-On V8.0.1 IMS Installer.

    正确答案:C

  • 第15题：

    Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?（）

    • A、DB2 for z/OS
    • B、DB2 Run-Time Client for z/OS
    • C、DB2 Connect Enterprise Edition for z/OS
    • D、z/OS Application Connectivity to DB2 for z/OS and OS/390

    正确答案:A

  • 第16题：

    You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） 

    • A、Memory Advisor
    • B、Segment Advisor
    • C、SQL Tuning Advisor
    • D、SQL Access Advisor
    • E、Automatic Database Diagnostic Monitor （ADDM）

    正确答案:A

  • 第17题：

    You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003. A server named TestKing2 functions as an application server. Users in the TestKing marketing department use an application on TestKing2 to analyze data. The application produces a high volume of disk activity. You give access to 15 new users for the application on TestKing2. Users in the TestKing marketing department report unacceptable delays when they use the application during periods of peak activity. You use System Monitor to analyze the performance of TestKing2. You need to ensure that TestKing2 can support the new users. Which counter should you monitor?（）

    • A、The % Disk Time counter for the PhysicalDisk performance object
    • B、The Current Disk Queue Length counter for the PhysicalDisk performance object
    • C、The Free Megabytes counter for the LogicalDisk performance object
    • D、The Disk Transfers/sec counter for the LogicalDisk performance object

    正确答案:A

  • 第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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? （） 

    • A、You should use the Database Engine Tuning Advisor tool 
    • B、You should use the Windows System Monitor tool 
    • C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio 
    • D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio

    正确答案:D

  • 第19题：

    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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

    • A、You should use Dynamic Management Views 
    • B、You should use SQL Server Resource Governor 
    • C、You should use SQL Server Profiler 
    • D、You should use Windows System Monitor

    正确答案:A

  • 第20题：

    单选题
    You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     SQL Tuning Advisor

    D

     SQL Access Advisor

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第21题：

    单选题
    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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? （）
    A

    You should use the Database Engine Tuning Advisor tool 

    B

    You should use the Windows System Monitor tool 

    C

    You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio 

    D

    You should use the Activity Monitor tool in Microsoft SQL Server Management Studio


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

  • 第22题：

    多选题
    An administrator determines that performance has degraded for a WebSphere Commerce database.  Which of the following steps should be performed to correct this problem？（）
    A

    Cleanup obsolete data

    B

    Clear the WebSphere Commerce cache

    C

    Enable WebSphere Commerce Accelerator

    D

    Reindex the database tables

    E

    Run Performance Monitor to monitor SQL statements


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

  • 第23题：

    单选题
    Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）
    A

    DB2 for i5/OS

    B

    DB2 Runtime Client

    C

    DB2 Connect Enterprise Edition

    D

    DB2 for i5/OS SQL Development Kit


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

相关内容