网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this？（）
A
Implement job classes
B
Implement Scheduler windows
C
Implement the mapping rule for the consumer groups
D
Set the SWITCH_TIME resource plan directive for both the resource plans
参考答案
参考解析
解析：
暂无解析
更多 “单选题You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this？（）A Implement job classesB Implement Scheduler windowsC Implement the mapping rule for the consumer groupsD Set the SWITCH_TIME resource plan directive for both the resource plans” 相关考题
考题
You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the database.C. Create a Flashback Data Archive in the tablespace where the tables are stored.D. Create a Flashback Data Archive in any suitable tablespace.E. Enable Flashback Data Archiving for the tables that require tracking
考题
You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.Which two actions should you take? (Each correct answer presents parts of the solution. Choose two)A. Configure the hard disks as two mirrored NTFS volumes.B. Configure the hard disks as one mirrored NTFS volumes.C. Configure the hard disks as two independent NTFS volumes.D. Configure the hard disks as one extended NTFS volume.E. Place inventory_data.mdf on the first volume and inventory_log.ldf on the second volume.F. Place inventory_data.mdf on the first volume and inventory_data2.ndf and inventory_log.ldf on the second volume.G. Place inventory_data.mdf and inventory_log.ldf on the same volume.
考题
When loading a tanker，you should ______．A.load only one tank at a timeB.keep the seamen on watch on standby in the mess roomC.keep a strain on the loading hosesD.close valves by closing them down，reopening one or two turns，and re-closing
考题
You want to create a template to be used as a standard for all company reports, which are many different styles. How many different templates must you have if you plan to use multiple report styles?（）A、Two B、One C、One per report styleD、One per report style + one more
考题
You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）A、Create a single storage group. Create one database for all usersB、Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group databaseC、Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group databaseD、Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes
考题
You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）A、MERGEB、SELECT …CROSS JOINC、INSERT ALL …SELECTD、CREATE VIEW …CONSTRAINT
考题
Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（） A、 WindowB、 ProgramC、 Job_ClassD、 Window group
考题
In which scenario will you create a sorted hash cluster？ （）A、 if the application uses queries joining tables only occasionallyB、 if the full table scan is executed often on only one table of the clustered tablesC、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD、 when you want the data to be returned automatically in the chronological order
考题
You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）A、one SQL Server 2005 computer with one instanceB、two SQL Server 2005 computers， each with two instancesC、two SQL Server computers， one with one instance and one with three instancesD、one SQL Server 2005 computer with two instances
考题
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 collectionB、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
考题
Your network contains two data centers named Datacenter1 and Datacenter2. An Active Directory site exists for each data center. The data centers connect to the Internet by using a direct link. The data centers connect to each other by using a high-speed WAN link. You plan to deploy Exchange Server 2010 Mailbox servers in both data centers. You need to plan message routing to meet the following requirements：.Ensure outbound delivery of e-mail messages if a single server fails .Automatically load balance the Hub Transport server in each site .Deploy the minimum number of servers What should you include in the plan？（）A、In each data center， deploy one Hub Transport server. Create and configure one Send connector.B、In each data center， deploy two Hub Transport servers. Create and configure one Send connector.C、In each data center， deploy one Edge Transport server. Create and configure two Send connectors.D、In each data center， deploy two Edge Transport servers. Create and configure two Send connectors.
考题
You are designing a strategy to improve the performance and reliability of the domain controllers. What should you do?（）A、Create one RAID-5 volume.B、Create two RAID-5 volumes.C、Create one mirrored volume and two RAID-5 volumes.D、Create two mirrored volumes and one RAID-5 volume.
考题
You need to recommend an RD Gateway configuration that meets the company’s technical requirements. What should you recommend？（）A、Create two Remote Desktop connection authorization policies （RD CAPs） and one Remote Desktop resource authorization policy （RD RAP）.B、Create one Remote Desktop connection authorization policy（RD CAP）and two Remote Desktop resource authorization policies （RD RAPs）.C、Create one Remote Desktop resource authorization policy（RD RAP）and deploy the Remote Desktop Connection Broker（RD Connection Broker） role service.D、Create one Remote Desktop connection authorization policy（RD CAP） and deploy the Remote Desktop Connection Broker （RD Connection Broker） role service.
考题
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 Windows Azure application. The application will store data in Windows Azure Blob storage. Many of the application services will be interdependent. You need to recommend an approach for optimizing the performance of the application. What should you recommend？ （）A、 Create one affinity group. Associate only the storage services with the affinity group.B、 Create one affinity group. Associate only the compute services with the affinity group.C、 Create one affinity group. Associate the compute services and storage services with the affinity group.D、 Create two affinity groups. Associate the compute services with one group and the storage services with the other group.
考题
单选题You are designing a Windows Azure application. The application will store data in Windows Azure Blob storage. Many of the application services will be interdependent. You need to recommend an approach for optimizing the performance of the application. What should you recommend？ （）A
Create one affinity group. Associate only the storage services with the affinity group.B
Create one affinity group. Associate only the compute services with the affinity group.C
Create one affinity group. Associate the compute services and storage services with the affinity group.D
Create two affinity groups. Associate the compute services with one group and the storage services with the other group.
考题
单选题You are designing a strategy to improve the performance and reliability of the domain controllers. What should you do？（）A
Create one RAID-5 volume.B
Create two RAID-5 volumes.C
Create one mirrored volume and two RAID-5 volumes.D
Create two mirrored volumes and one RAID-5 volume.
考题
单选题You are planning to deploy Windows 7 Enterprise to all of your company’s client computers. You have the following requirements： Create two custom partitions on each client computer’s hard disk， one for the operating system and the other for data. Automatically create the partitions during Windows Setup. You need to design an image that meets the requirements. What should you do？（）A
Use Windows PE to create the partitions. Install Windows 7 on the first partition.B
Use Windows System Image Manager （Windows SIM） to specify the partition configuration.C
Use Disk Management to create the two partitions on the hard disk.D
Use SysPrep to create the two partitions during Windows Setup.
考题
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）A
Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.B
Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.C
Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.D
Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.
考题
单选题Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）A
WindowB
ProgramC
Job_ClassD
Window group
考题
单选题You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?（）A
Implement job classesB
Implement Scheduler windowsC
Implement the mapping rule for the consumer groupsD
Set the SWITCH_TIME resource plan directive for both the resource plans
考题
单选题Your network contains two data centers named Datacenter1 and Datacenter2. An Active Directory site exists for each data center. The data centers connect to the Internet by using a direct link. The data centers connect to each other by using a high-speed WAN link. You plan to deploy Exchange Server 2010 Mailbox servers in both data centers. You need to plan message routing to meet the following requirements：.Ensure outbound delivery of e-mail messages if a single server fails .Automatically load balance the Hub Transport server in each site .Deploy the minimum number of servers What should you include in the plan？（）A
In each data center， deploy one Hub Transport server. Create and configure one Send connector.B
In each data center， deploy two Hub Transport servers. Create and configure one Send connector.C
In each data center， deploy one Edge Transport server. Create and configure two Send connectors.D
In each data center， deploy two Edge Transport servers. Create and configure two Send connectors.
考题
单选题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 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 collectionB
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
考题
单选题You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this？（）A
Implement job classesB
Implement Scheduler windowsC
Implement the mapping rule for the consumer groupsD
Set the SWITCH_TIME resource plan directive for both the resource plans
考题
单选题In which scenario will you create a sorted hash cluster？ （）A
if the application uses queries joining tables only occasionallyB
if the full table scan is executed often on only one table of the clustered tablesC
if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD
when you want the data to be returned automatically in the chronological order
考题
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）A
Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.B
Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.C
Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.D
Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.
考题
单选题You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）A
Create a single storage group. Create one database for all usersB
Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group databaseC
Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group databaseD
Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes
热门标签
最新试卷
