Which of the following are the two built-in user accounts created automatically on a computer running Windows
Which of the following are the two built-in user accounts created automatically on a computer
running Windows Server 2012 R2?
Which Transact-SQL query should you use?
You administer a Microsoft SQL Server 2008 R2 instance that contains two databases
named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the
SQL_Latin1_General_CP1_CI_AS collation and the AdventureWorks database uses the
SQL_Latin1_General_CP1_CS_AS collation.
You need to write a query that returns all customers having the same name in each
database. You also need to ensure that the query is not case-sensitive.
Which Transact-SQL query should you use?
Which of the following is not a type of user account that can be configured in Windows Server 2012 R2?
Which of the following is not a type of user account that can be configured in Windows Server 2012
R2?
Which connection properties should you view?
HOTSPOT
Your network contains an Active Directory domain named fabrikam.com. You implement
DirectAccess and an IKEv2 VPN.
You need to view the properties of the VPN connection.
Which connection properties should you view? To answer, select the appropriate connection
properties in the answer area.
Which two actions should you perform?
Your network contains an Active Directory domain named contoso.com. The domain contains
servers named Server1 and Server2 that run Windows Server 2012 R2. Server1 has the Active
Directory Federation Services server role installed.Server2 is a file server.
Your company introduces a Bring Your Own Device (BYOD) policy.
You need to ensure that users can use a personal device to access domain resources by using Single
Sign-On (SSO) while they are connected to the internal network.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose
two.)
Which code segment should you use?
You have a table named Stores that has an XML column named OpenHours. This column contains
the opening and closing times.
<hours dayofWeek=“Monday” open=”8:00” closed=”18:00” />
<hours dayofWeek=“Tuesday” open=”8:00” closed=”18:00” />
…
<hours dayofWeek=“Saturday” open=”8:00” closed=”18:00” />
You need to write a query that returns a list of stores and their opening time for a specified day.
Which code segment should you use?
You need to ensure that the current state of VM1 is contained in a single virtual hard disk file
Your network contains a Hyper-V host named Server1 that runs Windows Server 2012 R2. Server1
hosts a virtual machine named VM1 that runs Windows Server 2012 R2.
You take a snapshot of VM1, and then you install an application on VM1.
You verify that the application runs properly.
You need to ensure that the current state of VM1 is contained in a single virtual hard disk file. The
solution must minimize the amount of downtime on VM1.
What should you do?
Which Transact-SQL command should you use?
You administer a Microsoft SQL Server 2008 R2 instance.
You need to attach a database named Northwind to the server.
Which Transact-SQL command should you use?
You need to ensure that you can use Event Viewer on Server1 to view the event logs on Core1
Your network contains an Active Directory domain named adatum.com. The domain contains a
server named Server1 that runs Windows Server 2012 R2.
On a server named Core1, you perform a Server Core Installation of Windows Server 2012 R2.You
join Core1 to the adatum.com domain.
You need to ensure that you can use Event Viewer on Server1 to view the event logs on Core1.
What should you do on Core1?
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?