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

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

相似考题

1.( )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

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. 

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

4.()is the process of managing procurement relationships,monitoring contract performance,and making?changes and corrections as appropriate,and closing out contracts.A.Control Procurements B.Conduct Procurements C.Plan Procurement management D.Procurement strategy

参考答案和解析
正确答案： A,C,D
解析： 暂无解析
更多“You are designing a performance monitoring plan for the data”相关问题

  • 第1题：

    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 Console
    • B、Enable performance monitoring of the WebSphere Commerce application through the WebSphere Commerce Administration Console
    • C、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

    正确答案:A

  • 第2题：

    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.

    正确答案:A

  • 第3题：

    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.

    正确答案:C

  • 第4题：

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

    正确答案:C

  • 第5题：

    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.

    正确答案:A,E

  • 第6题：

    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.

    正确答案:C

  • 第7题：

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


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

  • 第8题：

    单选题
    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.


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

  • 第9题：

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


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

  • 第10题：

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

    Enable Memory Access Mode, which reads performance data from SGA.

    B

    Use emergency monitoring to fetch data directly from SGA analysis.

    C

    Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

    D

    Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

    E

    Run ADDM in diagnostic mode.


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

  • 第11题：

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

    On one server， create event subscriptions for each server. On the server， attach tasks to the application  error events.

    B

    On one server， create an Event Trace Sessions Data Collector Set. On all servers， create a System Performance Data Collector Set.

    C

    On all servers， create event subscriptions for one server. On all servers， attach a task for the  application error events.

    D

    On all servers， create a System Performance Data Collector Set. On one server， configure the report settings for the new Data Collector set.


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

  • 第12题：

    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

  • 第13题：

    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 Wizard
    • B、Federation Trusts
    • C、Reliability Monitor
    • D、Role Based Access Control （RBAC）

    正确答案:D

  • 第14题：

    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 files
    • B、Exchange Server Mail Flow Troubleshooter
    • C、Exchange Server Performance Troubleshooter
    • D、Microsoft System Center Configuration Manager

    正确答案:A

  • 第15题：

    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.

    正确答案:B

  • 第16题：

    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

    正确答案:A,C,D

  • 第17题：

    单选题
    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.


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

  • 第18题：

    单选题
    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.


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

  • 第19题：

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

    CHECK

    B

    UNIQUE

    C

    NOT NULL

    D

    PRIMARY KEY

    E

    FOREIGN KEY


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

  • 第20题：

    单选题
    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). 


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

  • 第21题：

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

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

相关内容