网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 ExplainB.Activity MonitorC.SQL Performance MonitorD.DB2 Performance Monitor
考题
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 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
考题
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
考题
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
考题
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.
考题
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.
考题
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.
考题
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/OSB、DB2 Runtime ClientC、DB2 Connect Enterprise EditionD、DB2 for i5/OS SQL Development Kit
考题
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/OSB、DB2 Run-Time Client for z/OSC、DB2 Connect Enterprise Edition for z/OSD、z/OS Application Connectivity to DB2 for z/OS and OS/390
考题
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 AnalyzerB、Tivoli Performance Viewer.C、Tivoli Web Site Analyzer.D、DB2 Intelligent Miner for Data.
考题
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 AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor （ADDM）
考题
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.
考题
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 objectB、The Current Disk Queue Length counter for the PhysicalDisk performance objectC、The Free Megabytes counter for the LogicalDisk performance objectD、The Disk Transfers/sec counter for the LogicalDisk performance object
考题
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.
考题
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
考题
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 ServicesB、Performance Information and ToolsC、Reliability MonitorD、Resource Monitor
考题
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
考题
单选题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 objectB
The Current Disk Queue Length counter for the PhysicalDisk performance objectC
The Free Megabytes counter for the LogicalDisk performance objectD
The Disk Transfers/sec counter for the LogicalDisk performance object
考题
单选题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 AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题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
考题
单选题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
考题
单选题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.
考题
多选题An administrator determines that performance has degraded for a WebSphere Commerce database. Which of the following steps should be performed to correct this problem？（）ACleanup obsolete dataBClear the WebSphere Commerce cacheCEnable WebSphere Commerce AcceleratorDReindex the database tablesERun Performance Monitor to monitor SQL statements
考题
单选题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.
考题
单选题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/OSB
DB2 Runtime ClientC
DB2 Connect Enterprise EditionD
DB2 for i5/OS SQL Development Kit
考题
单选题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.
热门标签
最新试卷