Which feature should you use?
You have two views named Sales.SalesSummaryOverall and Sales.CustomerAndSalesSummary.
They are defined as follows:
CREATE VIEW Sales.SalesSummaryOverall
AS
SELECT CustomerId, SUM(SalesTotal) AS OverallTotal
FROM Sales.SalesOrder
GROUP BY CustomerId
GO
CREATE VIEW Sales.CustomerAndSalesSummary
AS
SELECT Customer.Name,
SalesSummaryOverall.OverallTotal,
(SELECT AVG(OverallTotal)
FROM Sales.SalesSummaryOverall
WHERE SalesSummaryOverall.CustomerId =
Customer.CustomerId) AS avgOverallTotal,
(SELECT MAX(OverallTotal)
FROM Sales.SalesSummaryOverall
WHERE SalesSummaryOverall.CustomerId =
Customer.CustomerId) AS maxOverallTotal,
FROM Sales.Customer
LEFT OUTER JOIN Sales. Sales.SalesSummaryOverall
ON SalesSummaryByYear.CustomerId = Customer.CustomerId
GO
You have been tasked to modify the Sales.CustomerAndSalesSummary view to remove references to
other views. You need to identify a feature to use in the modified version of the
Sales.CustomerAndSalesSummary object to achieve the task.
Which feature should you use?
Which tool should you use?
Your network contains an Active Directory domain named contoso.com. The domain contains a
domain controller named DC5. DC5 has a Server Core Installation of Windows Server 2012 R2.
You need to uninstall Active Directory from DC5 manually.
Which tool should you use?
Which virtual machine settings should you configure on VM1 and VM2?
Your network contains two Hyper-V hosts named Host1 and Host2. Host1 contains a virtual machine
named VM1. Host2 contains a virtual machine named VM2. VM1 and VM2 run Windows Server 2012
R2.
You install the Network Load Balancing feature on VM1 and VM2.
You need to ensure that the virtual machines are configured to support Network Load Balancing
(NLB).
Which virtual machine settings should you configure on VM1 and VM2?
Which settings should you configure?
HOTSPOT
Your network contains an Active Directory domain named contoso.com.
Technicians use Windows Deployment Services (WDS) to deploy Windows Server 2012 R2.
The network contains a server named Server1 that runs Windows Server 2012 R2. Server1 has the
Hyper-V server role installed.
You need to ensure that you can use WDS to deploy Windows Server 2012 R2 to a virtual machine
named VM1.
Which settings should you configure?
To answer, select the appropriate settings in the answer area.
You need to configure the job step so that it can successfully complete execution
You upgrade an instance of Microsoft SQL Server 2000 to SQL Server 2008.
The SQL Server Agent service is configured to use the LocalSystem account. A job uses a
CMDExec step to access a file located on a remote network share.
After the upgrade, the job step fails to complete execution.
You need to configure the job step so that it can successfully complete execution.
What should you do?
which node should you configure the exclusion range?
HOTSPOT
Your network contains an Active Directory domain named contoso.com. The network contains two
subnets. The subnets are configured as shown in the following table.
The network contains a member server named Server1 that runs Windows Server 2012 R2. Server1
has the DHCP Server server role installed. Server1 is configured to lease IP addresses to the two
subnets.
You add three new printers to the MainOffice subnet. The printers have static IP addresses. The IP
addresses are consecutive.
You need to create an exclusion range that contains the IP addresses of the printers.
From which node should you configure the exclusion range? To answer, select the appropriate node
in the answer area.
Which snap-in should you use?
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server1. Server1 runs Windows Server 2012 R2.
An administrator creates a security template named Template1.
You need to apply Template1 to Server1.
Which snap-in should you use?
You need to configure GPO1 to apply to all of the users in OU1
Your network contains an Active Directory domain named contoso.com.
You have a Group Policy object (GPO) named GPO1 that contains several user settings. GPO1 is
linked to an organizational unit (OU) named OU1.
The help desk reports that GPO1 applies to only some of the users in OU1.
You open Group Policy Management as shown in the exhibit. (Click the Exhibit button.)
You need to configure GPO1 to apply to all of the users in OU1.
What should you do?
Which TransactSQL statement should you use?
You need to write a query that allows you to rank total sales for each salesperson into four groups,
where the top 25 percent of results are in group 1, the next 25 percent are in group 2, the next 25
percent
are in group 3, and the lowest 25 percent are in group 4.
Which TransactSQL
statement should you use?
You need to ensure that all users see only their own home folder when they access Home
Your network contains an Active Directory domain named adatum.com. The domain contains a file
server named Server2 that runs Windows Server 2012 R2. Server2 contains a shared folder named
Home. Home contains the home folder of each user.
All users have the necessary permissions to access only their home folder.
A user named User1 opens the Home share as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that all users see only their own home folder when they access Home.
What should you do from Server2?