单选题You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your sug

第1题：

第2题：

第3题：

A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.

• A、OLTPs
• B、transactions
• C、data sarts
• D、OLAPs

第4题：

Your client has deployed a cisco wireless location appliance within their warehouse environment. they have been experiencing problems with tracking objects using active rfid tags. the rfid tag data is not being collected. On which device would you verify that rfid status has been enabled？（）

• A、cisco wcs
• B、access point
• C、wireless controller
• D、location manager

第5题：

Yours truly，customer has deployed a cisco wireless location appliance within its warehouse  environment. however， employees there have been experiencing problems when tracking objects using active rfid tags. the rfid tag data is not being collected. On which device would you verify  that rfids have been enabled？（）

• A、access point
• B、location manager
• C、wireless controller
• D、cisco wcs

第6题：

You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

• A、The trace file
• B、The fixed views
• C、The data dictionary views
• D、The operating system log fields
• E、The dynamic performance views.

第7题：

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. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What 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 that are scheduled stimultaneously

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

You work as the enterprise exchange administrator at Xxx .The Xxx network consists of a domain named xxx .Xxx currently makes use of Exchange 2000 Server and Exchange Server 2003 Service Pack 2 （SP2） in their messaging system.You receive instruction from Xxx to migrate the messaging system to Exchange Server 2010 with Client Access server， Mailbox server and Hub Transport servers. What actions must you take？（）

• A、You should take away the Exchange 2000 Server servers in the environment.
• B、You should configure EdgeSync synchronization in the environment.
• C、You should run the setup /NewProvisionedServer in the environment.
• D、You should run the Migration Preparation Tool from the other servers in the environment.

第15题：

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. 

第16题：

Your customer has deployed a Cisco Wireless Location Appliance within its warehouse environment. However，employees there have been experiencing problems when tracking objects using active RFIDtags. The RFID tag data is not being collected. On which device would you verify that RFIDs have beenenabled？（）

• A、Cisco WCS
• B、access point
• C、location manager
• D、wireless controller

第17题：

You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）

• A、owner
• B、touser
• C、include
• D、schemas
• E、fromuser
• F、transform
• G、remap_schema
• H、remap_datafile
• I、reuse_datafiles
• J、remap_tablespace

第18题：

You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

• A、 perform point-in-time recovery
• B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
• C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
• D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

第19题：

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.

第20题：

第21题：

第22题：

第23题：