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 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?
You need to ensure that the following requirements are met: -SQL Server Audit information is stored in the D:\
You administer a Microsoft SQL Server 2008 R2 database. You configure the disk drives
according to the following table:
You discover that the Windows application log is being filled with entries from a SQL Server
Audit process named DatabaseAudit. The volume of these events is causing older events to
be removed from the log.
You need to ensure that the following requirements are met:
-SQL Server Audit information is stored in the D:\AuditLogs folder. -No data is currently lost
in the Windows application log.
What should you do?
You need to recommend a solution to minimize the amount of disk space used for the snapshot of VM1
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. On Server1, you create and start a virtual machine named VM1. VM1 is configured as
shown in the following table.
You plan to create a snapshot of VM1. You need to recommend a solution to minimize the amount
of disk space used for the snapshot of VM1. What should you do before you create the snapshot?
Which of the following is a reason for this configuration?
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 installed.
Contoso.com has a server, named ENSUREPASS-SR07, which has the AD DS, DHCP, and DNS server
roles installed. Contoso.com also has a server, named ENSUREPASS-SR08, which has the DHCP, and
Remote Access server roles installed. You have configured a server, which has the File and Storage
Services server role installed, to automatically acquire an IP address.
The server is named ENSUREPASS-SR09. You then create a filter on ENSUREPASS-SR07.
Which of the following is a reason for this configuration?
Which tool should you use?
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server1. Server1 runs Windows Server 2012 R2.
You need to create 3-TB virtual hard disk (VHD) on Server1.
Which tool should you use?
Which Transact-SQL statements should you execute?
You administer a SQL Server 2008 instance named SQL1. SQL1 contains a database
named DB1.
You create a new user named User1 in the DB1 database. No additional permissions have
been assigned to User1 or the public role. User1 will interact with database objects stored in
a new schema named Reporting. The other objects in the DB1 database are owned by the
dbo and are contained in a schema named Operations.
You need to grant the minimum necessary permission to User1 to create tables and stored
procedures in the Reporting schema.
You also need to ensure that User1 cannot alter any of the objects in the Operations
schema.
Which Transact-SQL statements should you execute?
Which of the following actions should you take?
You work as an administrator at Contoso.com. The Contoso.com network consists of a single domain
named Contoso.com. Subsequent to deploying a Server Core Installation of Windows Server 2012 on
a new Contoso.com server, you are instructed to add a graphical user interface (GUI) to the server.
You want to achieve this goal from the command prompt. Which of the following actions should you
take?
Which TransactSQL statement should you use?
You created a Service Broker queue by using the following TransactSQL
statement:
CREATE QUEUE VacationRequestQueue
WITH
RETENTION = OFF,
ACTIVATION (
PROCEDURE_NAME = dbo.VacationRequestProcess,
MAX_QUEUE_READERS = 5,
EXECUTE AS SELF
)Íž
You need to modify the Service Broker queue to prevent it from processing received messages. The
queue should continue to receive messages.
Which TransactSQL
statement should you use?
Which tool should you use?
Your network contains an Active Directory forest that contains two domains. The forest contains five
domain controllers. The domain controllers are configured as shown in the following table.
You need to configure DC5 as a global catalog server. Which tool should you use?