You need to restore the backup
You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The
backup schedule is shown in the following table:
A drive fails and the CustomerOrders database goes into suspect mode on Tuesday at
09:00 hours.
You need to restore the backup.
What should you do?
Which of the following actions should you take?
You work as an administrator at ABC.com. The ABC.com network consists of a single domain named
ABC.com. All servers in the ABC.com domain, including domain controllers, have Windows Server
2012 R2 installed.
ABC.com’s user accounts are located in an organizational unit (OU), named ABCStaff. ABC.com’s
managers belong to a group, named ABCManagers.
You have been instructed to create a new Group Policy object (GPO) that should be linked to the
ABCStaffOU, but not affect ABC.com’s managers.
Which of the following actions should you take?
Which of the following are TRUE with regards to storage pools?
You work as a senior administrator at Lead2pass.com. The Lead2pass.com network consists of a
single domain named Lead2pass.com. All servers on the Lead2pass.com network have Windows
Server 2012 R2 installed.
You are running a training exercise for junior administrators. You are currently discussing storage
pools.
Which of the following are TRUE with regards to storage pools?
You need to ensure that the same set of custom starter GPOs are available in adatum.com
HOTSPOT
Your network contains two Active Directory forests named contoso.com and adatum.com.
A two-way forest trust exists between the forests.
You have custom starter Group Policy objects (GPOs) defined in contoso.com.
You need to ensure that the same set of custom starter GPOs are available in adatum.com.
In the table below, identify which action must be performed for the starter GPOs container in each
forest. Make only one selection in two of the rows. Each correct selection is worth one point.
Which method should you use?
A database contains tables named Sales and SalesArchive. SalesArchive contains historical sales
dat
a. You configure Change Tracking on the Sales table. The minimum valid version of the Sales table is
10.
You need to write a query to export only sales data that changed since version 10, including the
primary
key of deleted rows. Which method should you use?
Which settings should you modify from the Local Security Policy?
HOTSPOT
You have a server named Server1 that runs Windows Server 2012 R2. Server1 is a member of a
workgroup.
You need to ensure that only members of the Administrators group and members of a group named
Group1 can log on locally to Server1.
Which settings should you modify from the Local Security Policy? To answer, select the appropriate
settings in the answer area.
You need to restore the backup
You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The
backup schedule is shown in the following table:
A drive fails and the CustomerOrders database goes into suspect mode on Tuesday at
09:00 hours.
You need to restore the backup.
What should you do?
You need to prevent Group1 from being used to provide access to the resources in contoso.com
Your network contains two Active Directory forests named contoso.com and adatum.com. All
servers run Windows Server 2012 R2.
A one-way external trust exists between contoso.com and adatum.com.
Adatum.com contains a universal group named Group1. You need to prevent Group1 from being
used to provide access to the resources in contoso.com.
What should you do?
which node should you configure the exclusion range?
HOTSPOT
Your network contains an Active Directory domain named contoso.com. The network contains two
subnets. The subnets are configured as shown in the following table:
The network contains a member server named Server1 that runs Windows Server 2012 R2. Server1
has the DHCP Server server role installed.
Server1 is configured to lease IP addresses to the two subnets. You add three new printers to the
Warehouse subnet. The printers have static IP addresses. The IP addresses are consecutive.
You need to create an exclusion range that contains the IP addresses of the printers.
From which node should you configure the exclusion range? To answer, select the appropriate node
in the answer area.
Which three actions should you perform in sequence?
DRAG DROP
You have two servers named Server1 and Server2 that run Windows Server 2012 R2. Server1 has the
Hyper-V server role installed. Server1 hosts a virtual machine named VM1. VM1 is currently running.
VM1 has a snapshot that was created two weeks ago.
You plan to use Server2 to perform a forensic analysis of the contents of the disk of VM1 from two
weeks ago.
You need to ensure that you can view the contents of the disk of VM1 from two weeks ago from
Server2.
Which three actions should you perform in sequence? (To answer, move the appropriate three
actions from the list of actions to the answer area and arrange them in the correct order.)