PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

What should you recommend?

Your network contains an Active Directory domain named contoso.com. The Active Directory
site topology is configured as shown in the exhibit. (Click the Exhibit button.)

DC1 and DC2 run Windows Server 2003 R2. All FSMO roles are located on DC2.
You plan to deploy a read-only domain controller (RODC) to Site3.
You need to recommend changes to the network to support the planned RODC
implementation.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

You need to analyze the workload of the remote SQL Server instance on a local SQL Server instance by using the

You administer a remote SQL Server 2008 instance. Users report that the performance of
the application is poor.
You use SQL Profiler to capture a workload of the remote instance to a trace table on the
remote SQL Server instance.
You need to analyze the workload of the remote SQL Server instance on a local SQL Server
instance by using the Database Engine Tuning Advisor.
What should you do?

What should you recommend?

Your network contains an Active Directory domain named contoso.com.
Your company plans to open a branch office. The branch office will have 10 client computers
that run Windows 8 and at least one server that runs Windows Server 2012. The server will
host

BranchCache files and manage print queues for the network print devices in the branch
office.
You need to recommend a solution to ensure that the users in the branch office can print if
the branch office server fails.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

You need to implement a solution to reduce the amount of bandwidth used by the client computers in the branch

Your company has a main office that contains several servers and several users. The main
office contains a file server named Server1 that runs Windows Server 2012.
The users access a large report file that is created on Server1 each day.
The company plans to open a new branch office. The branch office will contain only client
computers.
You need to implement a solution to reduce the amount of bandwidth used by the client
computers in the branch office to download the report each day.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

Which computers should you identify?

Your network contains an Active Directory domain named contoso.com. The domain
contains four computers that are configured as shown in the following table.
You plan to use domain controller cloning.
You need to identify on which computers you can clone domain controllers that run Windows
Server 2012.
Which computers should you identify? (Each correct answer presents part of the solution.
Choose all that apply.)

Which TransactSQL statement should you use?

Your database contains two tables named Order and OrderDetails that store order information. They
relate to each other using the OrderID column in each table. Your business requires that the
LastModifiedDate column in the Order table must reflect the date and time when a change is made
in the OrderDetails table for the related order.

You need to create a trigger to implement this business requirement.
Which TransactSQL statement should you use?

What should you recommend?

Your company has two divisions named Division1 and Division2.
The network contains an Active Directory domain named contoso.com. The domain contains
two child domains named divisionl.contoso.com and division2.contoso.com.
The company sells Division1 to another company.
You need to prevent administrators in contoso.com and division2.contoso.com from gaining
administrative access to the resources in divisionl.contoso.com.
What should you recommend?