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

第1题：

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. 

第2题：

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

第3题：

第4题：

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.

第5题：

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.

第6题：

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

第7题：

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.

第8题：

第9题：

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）

第10题：

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