多选题What are three common reasons why customers are saying that they need to evolve their data center?（　）Aarchitectures that is inflexible and inefficientBdesire to use the same vender for desktop and server deploymentsCselecting best-performing vendors fo

第1题：

You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）

• A、Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.
• B、Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.
• C、Modify the format file to specify the same collation as the Dublin database. Import the table again.
• D、Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.

第2题：

You need to recommend a backup solution for the file servers that supports the company's planned changes.   What should you include in the recommendation？（）

• A、File Server Resource Manager （FSRM）
• B、Microsoft System Center Data Protection Manager
• C、Windows Server Backup
• D、Windows Storage Server 2008

第3题：

Your network consists of an Active Directory Domain Services （AD DS） forest with 1，000 client computers that run Windows XP.   Nine hundred of the computers are on the local area network.   One hundred computers are portable computers that connect to the main office only once every few months.  You are planning to deploy Windows 7.  You need to generate a report of the software that is installed on all client computers.    You need this information as soon as possible.  What should you use？（）

• A、Microsoft System Center Essentials
• B、Microsoft Desktop Optimization Pack
• C、Microsoft System Center Operations Manager
• D、Microsoft System Center Data Protection Manager

第4题：

What are three common reasons why customers are saying that they need to evolve their datacenter?（）

• A、architectures that is inflexible and inefficient
• B、desire to use the same vender for desktop and server deployments
• C、selecting best-performing vendors for each individual component
• D、existing equipment has reached and of life
• E、increasing operational costs of managing data centers
• F、demand among users for access to information anytime, anywhere

第5题：

There are many reasons why customers lack sufficient security measures on the network. Which two reasons for insufficient security are typical of the customers today?（）

• A、the use of hosted email services eliminating the need for local security
• B、the perceived costs of security solutions
• C、the lack of risk analysis
• D、the lack of threats to their network
• E、the belief that free security tools are sufficient
• F、the desire to avoid unnecessary technologies

第6题：

TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do？（）

• A、Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.
• B、Configure SQL2 as a remote server. Write the query on SQL1.
• C、Configure SQL2 as a linked server to impersonate the remote login.
• D、Configure SQL2 as a distributed server. Use pass-through authentication.

第7题：

You need to generate the utilization report for the application servers. What should you use to generate the report？（）

• A、Microsoft Assessment and Planning Toolkit （MAP）
• B、Microsoft Desktop Optimization Pack （MDOP）
• C、Microsoft System Center Virtual Machine Manager
• D、Microsoft System Center Operations Manager

第8题：

Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

• A、 Create a FOR trigger. 
• B、 Create an INSTEAD OF trigger. 
• C、 Create an AFTER trigger. 
• D、 Create a DDL trigger.

第9题：

第10题：

第11题：

第12题：

第13题：

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

• A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.
• B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
• C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.
• D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

第14题：

You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003. Another system administrator, Tess King, needs your help in configuring the volume shadow copy settings on a member server. Tess is logged on to the server console. The settings are configured to allow the proper use of all available remote tools. You need to provide remote help to Tess by using a remote administration tool. You also need to ensure that Tess can observe your actions from the console. What should you do?（）

• A、Use Remote Desktop in Windows XP Professional to establish a Remote Desktop connection to the member server.
• B、Use Help and Support in Windows XP Professional to offer Remote Assistance to the member server.
• C、Use Computer Management to connect remotely to the member server.
• D、Use the Remote Registry tool to connect to the server.

第15题：

Your organization has an Ac tive Directory Domain Services (AD DS) domain. All servers run Windows Server 2008 R2. You need to deploy Microsoft Application Virtualization (App - V) 4.6 in a stand - alone configuration. Which should you install?（）

• A、Microsoft Application Virtualization Data base
• B、Microsoft Application Virtualization Desktop Client
• C、Microsoft System Center Application Virtualization Streaming Server
• D、Microsoft System Center Application Virtualization Management Server

第16题：

What two technologies do SMB customers most often want to implement in the future?（）

• A、Mobility
• B、Optical
• C、Telepresence
• D、Voice
• E、Data Center

第17题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution by using SQL Server 2008. Several reports on the server use a shared data source named DSProduction. You modify an existing report that uses the DSProduction data source. After deployment， the modified report must use an alternate data source. You need to prevent the modified report from affecting other reports. What should you do？（）

• A、 Update the connection string of the DSProduction shared data source to point to the alternate data source.
• B、 Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.
• C、 Create a new shared data source named DSProduction in the same folder as that of the modified report. Update the connection string of the new shared data source to point to the alternate data source.
• D、 Disable the DSProduction data source. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.

第18题：

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding， the Session objects are not lost.  What should you do？（）

• A、Use the InProc Session Management mode to store session data in the ASP.NET worker process. 
• B、Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. 
• C、Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. 
• D、Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm. 

第19题：

Your company has an Active Directory Domain Services (AD DS) domain. All servers run Windows Server 2008 R2. You have a Remote Desktop Services infrastructure that hosts remote desktop sessions for users. You need to be able to revoke 240 Remote Desktop Services client access licenses (RDS CALs). What should you do?（）

• A、Configure the Remote Desktop Session Host (RD Session Host) server to use Per User licensing mode.Install 100 RDS CALs.
• B、Configure the Remote Desktop Session Host (RD Session Host) server to use Per User licensing mode.Install 20 RDS CALs.
• C、Configure the Remote Desktop Session Host (RD Session Host) server to use Per Device licensing mode.  Install 20 RDS CALs.
• D、Configure the Remote Desktop Session Host (RD Session Host) server to use Per Device licensingmode. Install 100 RDS CALs.

第20题：

You need to design an authentication solution for Terminal Services that meets the business requirements.What should you do？（）

• A、Configure the terminal server to use smart cards
• B、Configure IPSec to permit only Remote Desktop Protocol （RDP） connections to the terminal server
• C、Deny the Remote Desktop Users group access to the terminal server
• D、Restrict treyresearch.com users from logging on locally to the terminal server

第21题：

第22题：

第23题：

第24题：