Which is the correct answer?
You are mastering the company database, and managing 20 SQL Server 2005 computers
which are operated by other administrators that are asked to meet company service level
agreements (SLAs) on querying response time.
Some of the method on controlling query response times on the servers should be told for
these administrators.
Which is the correct answer?
Which TransactSQL statement should you use?
You have a table named dbo.Customers. The table was created by using the following TransactSQL
statement:
CREATE TABLE dbo.Customers
(
CustomerID int IDENTITY(1,1) PRIMARY KEY CLUSTERED,
AccountNumber nvarchar(25) NOT NULL,
FirstName nvarchar(50) NOT NULL,
LastName nvarchar(50) NOT NULL,
AddressLine1 nvarchar(255) NOT NULL,
AddressLine2 nvarchar(255) NOT NULL,
City nvarchar(50) NOT NULL,
StateProvince nvarchar(50) NOT NULL,
Country nvarchar(50) NOT NULL,
PostalCode nvarchar(50) NOT NULL,
CreateDate datetime NOT NULL DEFAULT(GETDATE()),
ModifiedDate datetime NOT NULL DEFAULT(GETDATE())
)
You create a stored procedure that includes the AccountNumber, Country, and StateProvince
columns
from the dbo.Customers table. The stored procedure accepts a parameter to filter the output on the
AccountNumber column.
You need to optimize the performance of the stored procedure. You must not change the existing
structure of the table.
Which TransactSQL
statement should you use?
What should you recommend?
Your company has a main office and four branch offices. The main office is located in
London.
The network contains an Active Directory domain named contoso.com. The network is
configured as shown in the exhibit. (Click the Exhibit button.)
Each office contains several servers that run Windows Server 2012.
In each branch office, you plan to deploy an additional 20 servers that will run Windows
Server 2012. Some of the servers will have a Server Core installation of Windows Server
2012.
You identify the following requirements for the deployment of the new servers:
Operating system images must be administered centrally.
The operating system images must be deployed by using PXE.
The WAN traffic caused by the deployment of each operating system must be minimized.
You need to recommend a solution for the deployment of the new servers.
What should you recommend?
Exhibits
What should you include in the recommendation?
Your network contains an Active Directory forest named contoso.com. The forest is
managed by using Microsoft System Center 2012.
Web developers must be able to use a self-service portal to request the deployment of
virtual machines based on predefined templates. The requests must be approved by an
administrator before the virtual machines are deployed.
You need to recommend a solution to deploy the virtual machines.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
You need to ensure that the report returns consistent results without affecting other users
You administer a SQL Server 2008 instance.
A stored procedure is used as the data source for a report that is frequently executed during
business hours. Users report that the data returned by the report is inconsistent. You
discover that the inconsistencies are caused by phantom reads. You need to ensure that the
report returns consistent results without affecting other users. What should you do?
What should you recommend?
Your network contains an Active Directory domain named contoso.com. The domain
contains a Microsoft System Center 2012 infrastructure. The domain contains two sites
named Site1 and Site2. The sites connect to each other by using a 1-Mbps WAN link.
The sites contain four servers. The servers are configured as shown in the following table.
In Site2, you plan to deploy 50 Hyper-V hosts.
You need to recommend a solution to deploy the Hyper-V hosts by using VMM. The solution
must minimize the amount of traffic between Site1 and Site2 during deployment.
What should you recommend?
Which three actions should you identify?
DRAG DROP
Your network contains an Active Directory domain named contoso.com. The domain
contains a server named Server1 that runs Windows Server 2008. Server1 is configured as
an enterprise certification authority (CA).
You back up all of the data on Server1, and then export the private and public keys of the
CA,
You plan to replace Server1 with a new member server that was purchased recently.
You need to identify which actions must be performed on the new server to restore the
certificate services of Server1.
Which three actions should you identify?
To answer, move the three appropriate actions from the list of actions to the answer area
and arrange them in the correct order.
Which five actions should you identify?
DRAG DROP
Your network contains an Active Directory domain named contoso.com. The domain
contains a server named Server1 that runs Windows Server 2008 R2. Server1 is a file
server.
You deploy a new member server named Server2 that runs Windows Server 2012.
You plan to migrate file shares from Server1 to Server2. File share and NTFS permissions
are assigned only to domain local groups.
You need to identify which actions are required to perform the migration.
Which five actions should you identify?
To answer, move the five appropriate actions from the list of actions to the answer area and
arrange them in the correct order.
Which constraint should you use?
You have a table named Customer.
You need to ensure that customer data in the table meets the following requirements:
credit limit must be zero unless customer identification has been verified.
credit limit must be less than 10,000.
Which constraint should you use?
What should you include in the recommendation?
Your network contains an Active Directory domain named contoso.com. The physical
topology of the network is configured as shown in the exhibit.
Each office contains 500 employees.
You plan to deploy several domain controllers to each office.
You need to recommend a site topology for the planned deployment.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
Exhibit
