You need to identify which service location (SRV) records are registered by DC3
Your network contains an Active Directory domain named adatum.com. The domain contains three
domain controllers.
The domain controllers are configured as shown in the following table.
DC3 loses network connectivity due to a hardware failure.
You plan to remove DC3 from the domain.
You log on to DC3.
You need to identify which service location (SRV) records are registered by DC3.
What should you do?
What command should you run on Server1?
HOTSPOT
You have three servers named Server1, Server2, and DC1 that run Windows Server 2012 R2. IPv6
addresses and configurations are assigned to all of the servers by using DHCPv6.
The IPv6 routing on Server1 is shown in the following table.
You verify that Server2 can ping the IPv6 address of DC1.
You need to ensure that Server1 can ping the IPv6 address of DC1.
What command should you run on Server1? (To answer, select the appropriate options in the
answer area.)
You need to configure the SQL Server instance to comply with the security audit policy
You are reviewing and configuring the security of a SQL Server 2008 instance that contains
database DB1.
The security audit policy specifies the following requirements:
-Only successful and failed logon attempts are recorded in log files. -The SQL Server
instance is shut down if records cannot be written to the log files.
You need to configure the SQL Server instance to comply with the security audit policy.
What should you do?
Which zone should you identify?
HOTSPOT
You have a DNS server named Server 1. Server1 runs Windows Server 2012 R2.
The network ID is 10.1.1.0/24.
An administrator creates several reverse lookup zones.
You need to identify which reverse lookup zone is configured correctly.
Which zone should you identify?
To answer, select the appropriate zone in the answer area.
What should you configure?
HOTSPOT
Your network contains a server named Server1 that runs Windows Server 2012 R2. App1 has the
Print and Document Services server role installed.
All client computers run Windows 8.
The network contains a network-attached print device named Printer1.
From App1, you share Printer1.
You need to ensure that users who have connected to Printer1 previously can print to Printer1 if
App1 fails.
What should you configure? To answer, select the appropriate option in the answer area.
You need to enable SQL Server to perform an index seek for these queries
You have a table named Person that contains a nvarchar column named Surname. The Person table
currently has a clustered index on PersonID. The Surname column contains Russian and Japanese
characters.
The following code segment will be used to search by Surname. IF @lang =’Russian’
SELECT PersonID, Surname
FROM Person
WHERE Surname = @SearchName COLLATE Cyrillic_General_CI_AS
if @lang = ‘Japanese’
SELECT PersonID, Surname
FROM Person
WHERE Surname = @SearchName COLLATE Japanese_CI_AS_KS
You need to enable SQL Server to perform an index seek for these queries. 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 -DisplayNameAllowDynamic -Direction Outbound -LocalPort 1024-65535 –
Protocol TCP. Users report that they can no longer connect to Server1 by using Appl.
You need to ensure that App1 can connect to Server1.
What should you run on Server1?
Which sp_configure configuration option should you configure?
You administer a SQL Server 2008 instance.
You need to allow users on the SQL Server instance to query remote data sources by using
the OPENROWSET() function.
Which sp_configure configuration option should you configure?
Which two actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The instance has a
Products table that is currently in the OevUser schema. The Appusers database role is
assigned Read and update permissions to the table.
The DevUser schema is owned by a database login that has been renamed. You need to
move the Products table from the DevUser schema to the dbo schema. Which two actions
should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)
You need to ensure that the same applications are published to User2
Your network contains an Active Directory domain named contoso.com. The domain contains a user
account named User1 that resides in an organizational unit (OU) named OU1.
A Group Policy object (GPO) named GPO1 is linked to OU1. GPO1 is used to publish several
applications to a user named User1.
In the Users container, you create a new user named User2.
You need to ensure that the same applications are published to User2.
What should you do?