You need to identify the network protocol used by the current connection
You administer a SQL Server 2008 instance. You need to identify the network protocol used
by the current connection. What should you do?
You need to prevent Server1 from attempting to resolve Internet host names for the client computers
Your network contains an Active Directory domain named contoso.com. The network contains 500
client computers that run Windows 8. All of the client computers connect to the Internet by using a
web proxy.
You deploy a server named Server1 that runs Windows Server 2012 R2. Server1 has the DNS Server
server role installed.
You configure all of the client computers to use Server1 as their primary DNS server. You need to
prevent Server1 from attempting to resolve Internet host names for the client computers.
What should you do on Server1?
You need to ensure that a user named User1 can link and unlink Group Policy objects (GPOs) to OU1
Your network contains an Active Directory domain named contoso.com. The domain contains 100
user accounts that reside in an organizational unit (OU) named 0U1. You need to ensure that a user
named User1 can link and unlink Group Policy objects (GPOs) to OU1. The solution must minimize
the number of permissions assigned to User1.
What should you do?
What should you create?
You have a server that runs Windows Server 2012 R2. The server contains the disks configured as
shown in the following table.
You need to create a volume that can store up to 3 TB of user files. The solution must ensure that
the user files are available if one of the disks in the volume fails.
What should you create?
Which command or commands should you use next?
You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing
application. You need to ensure that the database allows full-text searches on the
Customers table. You also need to ensure that the full-text index is ready for use by the
users.
You execute a Transact-SQL statement to create the full-text index on the Customers table
by using the CHANGE_TRACKING OFF and NO POPULATION clauses in the CREATE
FULLTEXT INDEX statement. You execute an ALTER FULLTEXT INDEX. Which command
or commands should you use next?
What script should you use?
You have a server named Contoso with multiple databases.
You have been tasked to write a PowerShell script to determine which databases on the server are
larger
than 100GB. You open PowerShell from SQL Server Management Studio. You create two variables as
follows:
PS SQLSERVER:\SQL\Contoso> $MultipleOfGB = 1024 * 1024
PS SQLSERVER:\SQL\Contoso> $Server = GetItem
You need to determine which script will produce the desired list of databases.
What script should you use?
What should you do for server core so it can be managed from another server 2012 R2?
What should you do for server core so it can be managed from another server 2012 R2?
Which two actions should you perform?
Your network contains a Hyper-V host named Hyperv1 that runs Windows Server 2012 R2.
Hyperv1 has a virtual switch named Switch1.
You replace all of the network adapters on Hyperv1 with new network adapters that support singleroot I/O virtualization (SR-IOV). You need to enable SR-IOV for all of the virtual machines on
Hyperv1. Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
Which two commands should you run from Windows PowerShell?
Your network contains an Active Directory domain named contoso.com. The domain contains a
member server named HVServer1. HVServer1 runs Windows Server 2012 R2 and has the Hyper-V
server role installed. HVServer1 hosts two virtual machines named Server1 and Server2. Both virtual
machines connect to a virtual switch named Switch1.
On Server2, you install a network monitoring application named App1.
You need to capture all of the inbound and outbound traffic to Server1 by using App1.
Which two commands should you run from Windows PowerShell? (Each correct answer presents
part of the solution. Choose two.)
You need to ensure that the configuration settings in GP1 are applied only to the laptops in OU1
Your network contains an Active Directory domain named contoso.com.
An organizational unit (OU) named OU1 contains the user accounts and the computer accounts for
laptops and desktop computers. A Group Policy object (GPO) named GP1 is linked to OU1. You need
to ensure that the configuration settings in GP1 are applied only to the laptops in OU1. The solution
must ensure that GP1 is applied automatically to new laptops that are added to OU1.
What should you do?