PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

You need to completely repair the database in the minimum amount of time

You maintain a SQL Server 2008 instance. You discover that the database named
CityPowerLightDB presents data integrity problems. You perform a full database backup at
22:00 hours. The SQL Server instance experiences a power failure at 05:59 hours. No data
modifications have occurred after the backup. When the database is online, you discover
that some table data pages are corrupt. You need to completely repair the database in the
minimum amount of time. What should you do?

What task types are included in a SQL Maintenance Plan?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You plan to automate maintenance tasks.
What task types are included in a SQL Maintenance Plan? (To answer, drag the component
to the correct task or tasks in the answer area. The component may be used once or more
than once. Each task may be used once or not at all. Additionally, you may need to drag the
split bar between panes or scroll to view content.)

You need to join Server1 to the contoso.com domain

Your network contains an Active Directory domain named contoso.com. The domain contains two
domain controllers. The domain controllers are configured as shown in the following table.

In the perimeter network, you install a new server named Server1 that runs a Server Core
Installation of Windows Server 2012 R2. You need to join Server1 to the contoso.com domain. What
should you use?

You need to ensure that the members of Group1 can access Share1

Your network contains an Active Directory forest that contains three domains. A group named
Group1 is configured as a domain local distribution group in the forest root domain. You plan to
grant Group1 read-only access to a shared folder named Share1. Share1 is located in a child domain.
You need to ensure that the members of Group1 can access Share1.
What should you do first?

What should you configure on Server1?

Your network contains an Active Directory domain named contoso.com. All servers run either
Windows Server 2008 R2 or Windows Serve 2012 R2. All client computers run either Windows 7 or
Windows 8. The domain contains a member server named Server1 that runs Windows Server 2012
R2. Server1 has the File and Storage Services server role installed. On Server1, you create a share
named Share1.
You need to ensure that users can use Previous Versions to restore the files in Share1.
What should you configure on Server1?