PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

identify which tools are available on Server1 and which tools are unavailable on Server1.

HOTSPOT
You deploy a Server with a GUI installation of Windows Server 2012 R2 Datacenter.
From Windows PowerShell, you run the following command:
Remove-WindowsFeature ServerGui-Shell.
In the table below, identify which tools are available on Server1 and which tools are unavailable on
Server1.
Make only one selection in each row. Each correct selection is worth one point.

What results should the query produce?

You have a table named Subcategories that contains subcategories for socks, vests and helmets. You
have another table named Products that contains products only from the subcategories socks and
vests.
You have the following query:
SELECT s.Name, p.Name AS ProductName
FROM Subcategories s
OUTER APPLY
(SELECT *
FROM Products pr
WHERE pr.SubcategoryID = s.SubcategoryID) p
WHERE s.Name IS NOT NULL;
You need to predict the results of the query.
What results should the query produce?

Which two possible sources can you use to achieve this goal?

You have a server named Server1 that runs a Server Core Installation of Windows Server 2012 R2
Datacenter.
You have a WIM file that contains the four images of Windows Server 2012 R2 as shown in the
Images exhibit. (Click the Exhibit button.)

You review the installed features on Server1 as shown in the Features exhibit. (Click the Exhibit
button.)

You need to install the Server Graphical Shell feature on Server1.
Which two possible sources can you use to achieve this goal? (Each correct answer presents a
complete solution. Choose two.)

What should you configure on the new server?

HOTSPOT
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server that runs Windows Server 2012 R2.
You perform a Server Core Installation of Windows Server 2012 R2 on a new server.
You need to ensure that you can add the new server to Server Manager on Server1.
What should you configure on the new server? To answer, select the appropriate setting in the
answer area.

You need to ensure that the following requirements are met: -The data collector is used to gather performance

You maintain multiple SQL Server 2008 instances.
You are designing a consolidated repository of performance data.
You need to ensure that the following requirements are met:
-The data collector is used to gather performance information. -A single database stores
performance information for all instances. -Performance information that is older than 14
days is deleted. -Administrative effort to manage performance data is minimized.
What should you do?