多选题You are designing a performance monitoring plan for the database that supports APP1. You need to monitor only necessary indicators. Which indicator or indicators should you include in the baseline?（）Aresponse times for frequently used queriesBdatabase backup and restore completion timesCdisk I/ODCPU utilizationEnetwork packet sizeFSOAP requests failed
多选题
You are designing a performance monitoring plan for the database that supports APP1. You need to monitor only necessary indicators. Which indicator or indicators should you include in the baseline?（）
A
response times for frequently used queries
B
database backup and restore completion times
C
disk I/O
D
CPU utilization
E
network packet size
F
SOAP requests failed
参考解析
解析：
暂无解析
相关考题：
( )is the process of managing procurement relationships , monitoring contract performance, and making changes and corrections as appropriate,and closing out contracts. A、Control ProcurementsB、Conduct ProcurementsC、plan Procurements managementD、Procurements strategy
()is the process of managing procurement relationships,monitoring contract performance,and making?changes and corrections as appropriate,and closing out contracts.A.Control ProcurementsB.Conduct ProcurementsC.Plan Procurement managementD.Procurement strategy
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.
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database（）A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data
An administrator is attempting to use the Tivoli Performance Viewer to see the average response time for a WebSphere Commerce command， which of the following must be done in order to be successful？（）A、Enable performance monitoring of the WebSphere Application Server through the WebSphere Application Server Administrative ConsoleB、Enable performance monitoring of the WebSphere Commerce application through the WebSphere Commerce Administration ConsoleC、Install and configure Tivoli Performance Viewer on a separate machine and configure it to connect to the Application Server.D、Install and configure DB2 Intelligent Miner for Data to support the appropriate closed-loop analytics
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 are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A、 Use the bcp utility.B、 Use the dta utility.C、 Use the SQL Server Import and Export Wizard.D、 Attach each SQL Server database to SQL Azure.
You have an Exchange Server 2010 organization. The organization contains a global security group named Group1. You plan to deploy a monitoring solution for the Exchange servers in your organization. You need to recommend a solution that allows members of Group1 to monitor the performance ofExchange Server 2010 servers. Your solution must prevent members of Group1 from modifying the configurations of the ExchangesServer 2010 organization. What should you include in the solution？（）A、Delegation of Control WizardB、Federation TrustsC、Reliability MonitorD、Role Based Access Control （RBAC）
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.
You have an Exchange Server 2010 organization. You plan to deploy a monitoring solution for Exchange Server 2010. You need to recommend a solution to track the usage of ActiveSync clients and to analyze usage trends. What should you include in the solution？（）A、Internet Information Server log filesB、Exchange Server Mail Flow TroubleshooterC、Exchange Server Performance TroubleshooterD、Microsoft System Center Configuration Manager
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. After a regular test, you find that performance degradation is experienced by an instance for the three reasons: Excessive CPU usage, Server processes paging and Deadlocks. A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues. And detailed deadlock information should be contained in the provided data. You should utilize the least amount of administrative effort to finish the task. Which tool will you utilize to finish the task?（） A、To finish the task, you should utilize Resource Governor. B、To finish the task, you should utilize Database Engine Tuning Advisor.C、To finish the task, you should utilize Extended Events. D、To finish the task, you should utilize Performance Monitor (SYSMON).
You are one of the network administrators for All network servers run Windows Server 2003. TestKing operates a total of four offices. The office where you work has 15 servers. You are responsible for supporting and maintaining all of these servers. You need to design a monitoring plan that will achieve the following goals: 1. Track all performance changes on the servers. 2. Record performance data to anticipate the need for future upgrades. What should you do?（）A、On each server in your office, use Performance Logs and Alerts to create a baseline log. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.B、From a monitoring computer, use Performance Logs and Alerts to create a baseline log for each server in your office. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.C、On each server in your office, use Performance Logs and Alerts to create threshold-based alerts. Configure the alerts to send a message to your monitoring computer when they are triggered. Set each alert to start a new scan when the alert finishes.D、From a monitoring computer use Performance Logs and Alerts to create a new counter set in System Monitor. Configure the counters to run continuously.
You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. Your network includes domain controllers, file and print servers, and application servers. The application servers run a variety of programs, including Microsoft SQL Server 2000 and Microsoft Exchange Server 2003. Your staff are responsible for monitoring current system performance on all servers. You need to enable your staff to use System Monitor to gather performance data for each unique server type. The data will be used for trend analysis and forecasting. Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two)A、For each server, add the most common performance counters and save them as an HTML file.B、For each server, add the most common performance counters and save them as a counter report file.C、Create trace logs based on the file and schedule and trace logs to gather data.D、Create alerts on the file and schedule the alerts to gather data.E、Create counter logs based on the file and schedule the counter logs to gather data.
You are designing a performance monitoring plan for the database that supports APP1. You need to monitor only necessary indicators. Which indicator or indicators should you include in the baseline?（）A、response times for frequently used queriesB、database backup and restore completion timesC、disk I/OD、CPU utilizationE、network packet sizeF、SOAP requests failed
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. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? （） A、You should create a cached data collection B、You should create an on-demand non-cached data collection C、You should create a scheduled non-cached data collection. D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.
单选题You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A Use the bcp utility.B Use the dta utility.C Use the SQL Server Import and Export Wizard.D Attach each SQL Server database to SQL Azure.
单选题You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）AUse the external table population.BUse the Oracle Data Pump export and import utility.CUse the conventional path data load of the SQL*Loader utility.DUse the INSERT INTO...SELECT command to load the data.
单选题You are designing a plan to migrate an application to Windows Azure. The application generates log files in a proprietary format. You need to recommend an approach for retaining the existing log file format. What should you recommend？（）A Configure Windows Azure Diagnostics to transfer event logs.B Configure Windows Azure Diagnostics to transfer directories.C Configure Windows AzureDiagnostics to transfer performance counters.D Configure Windows Azure Diagnostics to transfer basic Windows Azure logs.
单选题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？（）AWebSphere Commerce AnalyzerBTivoli Performance Viewer.CTivoli Web Site Analyzer.DDB2 Intelligent Miner for Data.
多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. Which constraints will remain enabled by default during this operation（）ACHECKBUNIQUECNOT NULLDPRIMARY KEYEFOREIGN KEY
单选题You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. After a regular test, you find that performance degradation is experienced by an instance for the three reasons: Excessive CPU usage, Server processes paging and Deadlocks. A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues. And detailed deadlock information should be contained in the provided data. You should utilize the least amount of administrative effort to finish the task. Which tool will you utilize to finish the task?（）ATo finish the task, you should utilize Resource Governor. BTo finish the task, you should utilize Database Engine Tuning Advisor.CTo finish the task, you should utilize Extended Events. DTo finish the task, you should utilize Performance Monitor (SYSMON).
单选题You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）AEnable Memory Access Mode, which reads performance data from SGA.BUse emergency monitoring to fetch data directly from SGA analysis.CRun Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.DUse Active Session History (ASH) data and hang analysis in regular performance monitoring.ERun ADDM in diagnostic mode.
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility
单选题Your network consists of a single Active Directory domain. The functional level of the domain is Windows Server 2008 R2. The domain contains 200 Windows Server 2008 R2 servers. You need to plan a monitoring solution that meets the following requirements. èSends a notification by e-mail to the administrator if an application error occurs on any of the servers èUses the minimum amount of administrative effort What should you include in your plan？（）AOn one server， create event subscriptions for each server. On the server， attach tasks to the application error events.BOn one server， create an Event Trace Sessions Data Collector Set. On all servers， create a System Performance Data Collector Set.COn all servers， create event subscriptions for one server. On all servers， attach a task for the application error events.DOn all servers， create a System Performance Data Collector Set. On one server， configure the report settings for the new Data Collector set.
单选题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? （）AYou should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. BYou 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. CYou 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. DYou 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.