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 wou

题目

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 ”相关问题
  • 第1题:

    Which two roles or privileges must you have to export tables owned by another user?()

    • A、CREATE USER
    • B、CREATE SESSION
    • C、CREATE ANY TABLE
    • D、IMP_FULL_DATABASE
    • E、EXP_FULL_DATABASE

    正确答案:B,E

  • 第2题:

    You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database, you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first?()

    • A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.
    • B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’
    • C、Create a contract between the services by using the following statement.CREATE CONTRACT processData (ProcessReport SENT BY INITIATOR,SendResult SENT BY TARGET)
    • D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

    正确答案:C

  • 第3题:

    You need to design a configuration for the mailbox servers. What should you do?()

    • A、Create two Exchange Server 2003 computers. Place the mailboxes for main office users on one server, and place the mailboxes for remote users on the other server
    • B、Create a Network Load Balancing cluster that contains two Exchange Server 2003 computers. Place half of the user mailboxes on one server, and place half of the user mailboxes on the other server
    • C、Create a Microsoft Cluster Server cluster that contains two Exchange Server 2003 computers. Place all of the user mailboxes on one server and configure the other server as a failover node
    • D、Create a Microsoft Cluster Server cluster that contains two Exchange Server 2003 computers. Place half of the user mailboxes on one server, and place half of the user mailboxes on the other server

    正确答案:D

  • 第4题:

    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

    正确答案:A

  • 第5题:

    You are the network administrator for All network servers run Windows Server 2003. A member server named TestKingA contains two volumes. You need to perform a complete backup of the data on TestKingA. You must ensure that TestKingA can be completely restored in case of hardware failure. Which two actions should you perform? ()(Each correct answer presents part of the solution. Choose two)

    • A、Create an Automated System Recovery (ASR) backup.
    • B、Create a backup of user data.
    • C、Create a Windows Server 2003 bootable floppy disk.
    • D、Create a DOS bootable floppy disk.
    • E、Copy all Windows Server 2003 boot files to the Windows Server 2003 bootable floppy disk.
    • F、Copy only Boot.ini to the Windows Server 2003 bootable floppy disk

    正确答案:A,B

  • 第6题:

    Your company acquires a new Internet domain name.You need to ensure that all users can receive e-mail messages sent to the new domain name.Which two actions should you perform?()

    • A、Create a sharing policy.
    • B、Create a remote domain.
    • C、Create an accepted domain.
    • D、Create an e-mail address policy.
    • E、Modify the properties of the default Receive connector.

    正确答案:C,D

  • 第7题:

    You are developing a Windows Presentation Foundation (WPF) application. You need to use XAML to create a custom control that contains two Button controls. From which base class should you inherit? ()

    • A、 FrameworkElement
    • B、 UIElement
    • C、 UserControl
    • D、 Button

    正确答案:C

  • 第8题:

    You work as the enterprise exchange administrator at TestKing.com. TestKing.com makes use of Microsoft Exchange Server messaging solution. The TestKing.com network consists of a single ActiveDirectory domain named testking.com. TestKing.com is configured to run an exchange 2010 environment.Due to company growth, TestKing.com has bought two other comapnies named Courseware Publishersand Stanford Finance. Youz have received instructions from the CIO to make sure that the users fromboth of these companies have their own respective e-mail address that correspond to their company. What should you do?()

    • A、The best option is to create and configure two Receive connectors and two address lists.
    • B、The best option is to create and configure two transport rules and two address remote entries.
    • C、The best option is to create and configure two accepted domains and two e-mail address policies.
    • D、The best option is to create and configure two remote domains and two accepted domains.

    正确答案:C

  • 第9题:

    多选题
    You need to create a column that allows you to createa unique constraint. Which two column definitions should you choose?()
    A

    nvarchar(100) NULL

    B

    nvarchar(max) NOT NULL

    C

    nvarchar(100) NOT NULL

    D

    nvarchar(100) SPARSE NULL


    正确答案: B,D
    解析: 暂无解析

  • 第10题:

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


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

  • 第11题:

    单选题
    The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future.  What would you do?()
    A

     Create two custom ADDM tasks.

    B

     Modify the AWR snapshot time interval to two hours.

    C

     Create a new scheduler window for a time period of two hours.

    D

     Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.


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

  • 第12题:

    多选题
    In which two situations should you run the command sync group?() (Choose two.)
    A

    when you enable Unified Failover

    B

    when you create an ActiveN group

    C

    when you synchronize the sticky table

    D

    when you require synchronization of the 3G Cache objects


    正确答案: A,C
    解析: 暂无解析

  • 第13题:

    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 users
    • B、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 database
    • C、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 database
    • D、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

    正确答案:C

  • 第14题:

    You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes?()

    • A、 ONLINE
    • B、 REVERSE
    • C、 PARALLEL
    • D、 COMPRESS
    • E、 NOLOGGING
    • F、 COMPUTE STATISTICS

    正确答案:C,E

  • 第15题:

    You work as the enterprise exchange administrator at TestKing.com. TestKing.com makes use of Microsoft Exchange Server messaging solution. The TestKing.com network consists of two offices that areconfigured as an Active Directory site named Site A and Site B. You are planning to configure an Exchange Server 2010 environment in both sites. A direct Internet connections resides from both sites with a direct link. The connection between these two sites is via a highspeed WAN link. You have received instructions from the CIO to install Exchange Server 2010 Mailboxserves in both sites. You thus need to ensure that the Hub Transport server is automatically load balancedat every site as well as ensuring that outbound e-mail messages is delivered in the event of a singleserver failure. You should also ensure that the least amound of servers is deployed. What should you do?()

    • A、The best option is to install two Hub Transport servers and create and configure one Send connector.
    • B、The best option is to install one Edge Transport server and create two Send connectors.
    • C、The best option is to install two Edge Transport servers and create two Send connectors.
    • D、The best option is to install one Hub Transport server and create and configure one Send connector.

    正确答案:A

  • 第16题:

    You have an Exchange Server 2010 organization for a company named Contoso, Ltd. Contoso has the following security policy:  .Messages that contain the word budget cannot be sent to external recipients .Messages that contain the name Northwind Traders must be sent to the legal department automaticallyYou need to recommend a solution to meet the security policy.  What should you recommend?()

    • A、Create two transport rules.
    • B、Create two message classifications.
    • C、Create one transport rule and configure a legal hold.
    • D、Create one message classification and configure a legal hold.

    正确答案:A

  • 第17题:

    You install two Exchange Server 2010 Service Pack 1 (SP1) Edge Transport servers named Edge1 and Edge2.You need to ensure that e-mail is sent only to Edge2 if Edge1 fails. What should you do?()

    • A、Create two CNAME records that have the same name.Create one MX record that uses the FQDN of the CNAME records.Assign a priority of 0 to the MX record.
    • B、Create two MX records.Assign the MX record for Edge1 a priority of 5.Assign the MX record for Edge2 a priority of 1.
    • C、Create two A records that use the same name.Create one MX record that uses the FQDN of the A record.Assign a priority of 0 to the MX record.
    • D、Create two MX records.Assign the MX record for Edge1 a priority of 1.Assign the MX record for Edge2 a priority of 5.

    正确答案:D

  • 第18题:

    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.

    正确答案:D

  • 第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.

    正确答案:C

  • 第20题:

    单选题
    You work as the enterprise exchange administrator at TestKing.com. TestKing.com makes use of Microsoft Exchange Server messaging solution. The TestKing.com network consists of two offices that areconfigured as an Active Directory site named Site A and Site B. You are planning to configure an Exchange Server 2010 environment in both sites. A direct Internet connections resides from both sites with a direct link. The connection between these two sites is via a highspeed WAN link. You have received instructions from the CIO to install Exchange Server 2010 Mailboxserves in both sites. You thus need to ensure that the Hub Transport server is automatically load balancedat every site as well as ensuring that outbound e-mail messages is delivered in the event of a singleserver failure. You should also ensure that the least amound of servers is deployed. What should you do?()
    A

    The best option is to install two Hub Transport servers and create and configure one Send connector.

    B

    The best option is to install one Edge Transport server and create two Send connectors.

    C

    The best option is to install two Edge Transport servers and create two Send connectors.

    D

    The best option is to install one Hub Transport server and create and configure one Send connector.


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

  • 第21题:

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


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

  • 第22题:

    多选题
    You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes?()
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


    正确答案: E,B
    解析: 暂无解析

  • 第23题:

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


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

  • 第24题:

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


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