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? ()
第1题:
Which two roles or privileges must you have to export tables owned by another user?()
第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?()
第3题:
You need to design a configuration for the mailbox servers. What should you do?()
第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?()
第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)
第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?()
第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? ()
第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?()
第9题:
nvarchar(100) NULL
nvarchar(max) NOT NULL
nvarchar(100) NOT NULL
nvarchar(100) SPARSE NULL
第10题:
Use Windows PE to create the partitions. Install Windows 7 on the first partition.
Use Windows System Image Manager (Windows SIM) to specify the partition configuration.
Use Disk Management to create the two partitions on the hard disk.
Use SysPrep to create the two partitions during Windows Setup.
第11题:
Create two custom ADDM tasks.
Modify the AWR snapshot time interval to two hours.
Create a new scheduler window for a time period of two hours.
Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
第12题:
when you enable Unified Failover
when you create an ActiveN group
when you synchronize the sticky table
when you require synchronization of the 3G Cache objects
第13题:
You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do?()
第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?()
第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?()
第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?()
第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?()
第18题:
You are designing a strategy to improve the performance and reliability of the domain controllers. What should you do?()
第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? ()
第20题:
The best option is to install two Hub Transport servers and create and configure one Send connector.
The best option is to install one Edge Transport server and create two Send connectors.
The best option is to install two Edge Transport servers and create two Send connectors.
The best option is to install one Hub Transport server and create and configure one Send connector.
第21题:
Create one RAID-5 volume.
Create two RAID-5 volumes.
Create one mirrored volume and two RAID-5 volumes.
Create two mirrored volumes and one RAID-5 volume.
第22题:
ONLINE
REVERSE
PARALLEL
COMPRESS
NOLOGGING
COMPUTE STATISTICS
第23题:
Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.
Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.
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.
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.
第24题:
Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.
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.
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.
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.