What should you identify?
DRAG DROP
You plan to deploy a DHCP server that will support four subnets. The subnets will be configured as
shown in the following table:
You need to identify which network ID you should use for each subnet. What should you identify? To
answer, drag the appropriate network ID to the each subnet in the answer area.
Where should you search?
You install a 64-bit version of a SQL Server 2008 instance by using the default setup and
configuration settings. You receive the following error message:
“Your SQL Server installation completed with \a: ures.1
You close the error window before noting the location where additional information about the
error is recorded.
You need to locate the additional information.
Where should you search?
You need to ensure that the virtual machines can use Server1 as a DHCP server
Your network contains an Active Directory domain named contoso.com. The domain contains a
member server named HVServer1. HVServer1 runs Windows Server 2012 and has the Hyper-V server
role installed. HVServer1 hosts 10 virtual machines. All of the virtual machines connect to a virtual
switch named Switch1. Switch1 is configured as a private network. All of the virtual machines have
the DHCP guard and the router guard settings enabled.
You install the DHCP server role on a virtual machine named Server 1. You authorize Server1 as a
DHCP server in contoso.com. You create an IP scope.
You discover that the virtual machines connected to Switch1 do not receive IP settings from Server1.
You need to ensure that the virtual machines can use Server1 as a DHCP server.
What should you do?
Which cmdlet should you use?
You have a table named Inventory. You open a Microsoft Windows PowerShell session at the
following location by using the SQL Server Windows PowerShell provider. PS
SQLSERVER:\SQL\CONTOSO\DEFAULT\Databases\ReportServer\Tables\dbo.Inventory\Columns>
Using the SQL Server Windows PowerShell provider, you need to query all the columns in the table.
Which cmdlet should you use?
Which of the following is TRUE with regards to VHDX?
You work as a senior administrator at Contoso.com. The Contoso.com network consists of a single
domain named Contoso.com. All servers on the Contoso.com network have Windows Server 2012
R2 installed.
You are running a training exercise for junior administrators. You are currently discussing the new
VHD format called VHDX.
Which of the following is TRUE with regards to VHDX? (Choose all that apply.)
You need to ensure that Server2 can communicate with the client computers on LAN2
Your network contains two subnets. The subnets are configured as shown in the following table.
You have a server named Server2 that runs Windows Server 2012 R2. Server2 is connected to LAN1.
You run the route print command as shown in the exhibit.
You need to ensure that Server2 can communicate with the client computers on LAN2.
What should you do?
Which Transact-SQL statement should you execute?
You administer a SQL Server 2008 instance that contains a database named
AdventureWorks. You plan to use data compression to conserve disk space. You compress
a table named
VeryLarge that has a clustered index named Index1 and a non-clustered index named
Index2. Both indexes are partitioned. You execute the following Transact-SQL statement.
ALTER INDEX Index2 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
You need to ensure that all the indexes of the VeryLarge table are compressed by using
row-level compression. You need to accomplish this goal by using minimum resources.
Which Transact-SQL statement should you execute?
You need to log the amount of system resources used by each virtual machine
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server1. Server1 runs Windows Server 2012 R2 and has the Hyper-V server role
installed. You need to log the amount of system resources used by each virtual machine. What
should you do?
What should you run on Server1?
Your network contains an Active Directory domain named contoso.com. The domain contains an
application server named Server1. Server1 runs Windows Server 2012 R2. You have a client
application named App1 that communicates to Server1 by using dynamic TCP ports.
On Server1, a technician runs the following command: New-NetFirewallRule -DisplayName
AllowDynamic – Direction Outbound -LocalPort 1024- 65535 -Protocol TCP.
Users report that they can no longer connect to Server1 by using App1.
You need to ensure that App1 can connect to Server1.
What should you run on Server1?
Which of the following is TRUE with regards to connecting a physical disk to a virtual machine?
You work as an administrator at Contoso.com. The Contoso.com network consists of a single domain
named Contoso.com. All servers on the Contoso.com network have Windows Server 2012 R2
installed.
Contoso.com has a server, named ENSUREPASS-SR07, which has two physical disks installed. The C:
drive hosts the boot partition, while the D: drive is not being used. Both disks are online.
You have received instructions to create a virtual machine on ENSUREPASS-SR07. Subsequent to
creating the virtual machine, you have to connect the D: drive to the virtual machine.
Which of the following is TRUE with regards to connecting a physical disk to a virtual machine?