Which system function should you use?
You are tasked to create a table that has a column that must store the current time accurate to ten
microseconds.
You need to use a system function in conjunction with the DEFAULT option in the column definition.
Which system function should you use?
You need to ensure that that the following requirements are met: -Queries initiated through SQL Server Managem
You administer a SQL Server 2008 instance. The server hosts databases for several
mission-critical applications.
You plan to use the Resource Governor to limit the effect of queries that are executed by
Microsoft SQL Server Management Studio.
You need to ensure that that the following requirements are met:
-Queries initiated through SQL Server Management Studio do not exceed 20 percent of CPU
utilization. -Queries initiated by the mission-critical applications are allowed to consume 100
percent of CPU utilization when required.
What should you do?
Which file system should you use?
You plan to deploy a file server to a temporary location.
The temporary location experiences intermittent power failures.
The file server will contain a dedicated volume for shared folders.
You need to create a volume for the shared folders. The solution must minimize the likelihood of file
corruption if a power failure occurs.
Which file system should you use?
Which command should you run first?
Your network contains a Windows Server 2012 R2 image named Server12.wim.Server12.wim
contains the images shown in the following table.
You need to enable the Windows Server Migration Tools feature in the Windows Server 2012 R2
Datacenter image.
You want to achieve this goal by using the minimum amount of administrative effort.
Which command should you run first?
Which actions should you perform on the virtual machines?
DRAG DROP
You have a Hyper-V host named Host1.Host1 contains two virtual machines named VM1 and
VM2.VM1 is configured as a print server.VM1 runs Windows Server 2008 R2.VM2 is configured as a
file server.VM2 runs Windows Server 2012 R2.
You need to migrate all of the printers on VM1 to VM2.
Which actions should you perform on the virtual machines?
To answer, drag the appropriate action to the correct servers in the answer area. Each action may be
used once, more than once, or not at all. You may need to drag the split bar between panes or scroll
to view content.
Which tool should you use?
You perform a Server Core Installation of Windows Server 2012 R2 on a server named Server1.
You need to add a graphical user interface (GUI) to Server1.
Which tool should you use?
Which three cmdlets should you run in sequence?
DRAG DROP
You have a server named Server1 that runs Windows Server 2012 R2.
You add a new internal SAS disk to Server1.
You need to ensure that the new disk is available to store files.
Which three cmdlets should you run in sequence?
To answer, move the appropriate three cmdlets from the list of cmdlets to the answer area and
arrange them in the correct order.
Which performance object should you use?
You administer a SQL Server 2008 instance. Users report that applications that run on the
server perform poorly. You suspect that the performance issues are related to table scans.
You need to use an appropriate Windows System Monitor object to capture the appropriate
information.
Which performance object should you use?
You need to view which authentication method was used to establish the initial IPSec connection
Your network contains an Active Directory domain named contoso.com. The domain contains two
servers named Server1 and Server2 that run Windows Server 2012 R2.
Server2 establishes an IPSec connection to Server1.
You need to view which authentication method was used to establish the initial IPSec connection.
What should you do?
Which rule should you modify?
HOTSPOT
Your network contains an Active Directory domain named corp.contoso.com. The domain contains a
domain controller named DC1.
When you run ping dc1.corp.contoso.com, you receive the result as shown in the exhibit. (Click the
Exhibit button.)
You need to ensure that DC1 can respond to the Ping command.
Which rule should you modify?
To answer, select the appropriate rule in the answer area.
