PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which is the correct answer?

You are managing a SQL Server 2008 instance which includes some applications for
Home.com. You set the SQL Server Agent service to implement through utilizing the
SerTest\Test account. You create a job named MailingTester that allows a file to be stored to
a log server. The job could not run normally because it could not own proper access to the
log server. You decide to set the service of SQL Server Agent. You should make sure that
you could run the settings such that the SQL Server Agent service owns all access to the log
server. Which is the correct answer?

Which two possible commands can you use to achieve the goal?

Your network contains an Active Directory forest. The forest contains a single domain. The
forest has five Active Directory sites. Each site is associated to two subnets.
You add a site named Site6 that contains two domain controllers. Site6 is associated to one
subnet.
You need to verify whether replication to the domain controllers in Site6 completes
successfully.
Which two possible commands can you use to achieve the goal? Each correct answer
presents a complete solution.

What should you include in the recommendation?

Your company has a main office and four branch offices. The main office is located in
London.
The network contains an Active Directory domain named contoso.com. Each office contains
one domain controller that runs Windows Server 2012. The Active Directory site topology is
configured as shown in the exhibit. (Click the Exhibit button.)
You discover that when a domain controller in a branch office is offline for maintenance,
users in that branch office are authenticated by using the domain controllers in any of the
sites.
You need to recommend changes to Active Directory to ensure that when a domain
controller in a branch office is offline, the users in that branch office are authenticated by the
domain controllers in London.
What should you include in the recommendation?
Exhibit

What should you recommend?

Your network contains an Active Directory domain named contoso.com. All servers run
Windows Server 2008 R2. All domain controllers are installed on physical servers. The
network contains several Hyper-V hosts.
The network contains a Microsoft System Center 2012 infrastructure.
You plan to use domain controller cloning to deploy several domain controllers that will run
Windows Server 2012.
You need to recommend which changes must be made to the network infrastructure before
you can use domain controller cloning.
What should you recommend?

Which TransactSQL statement should you use?

You have a table named AccountsReceivable. The table has no indexes. There are 75,000 rows in the
table. You have a partition function named FG_AccountDat
a. The AccountsReceivable table is defined in
the following TransactSQL
statement:
CREATE TABLE AccountsReceivable (
column_a INT NOT NULL,

column_b VARCHAR(20) NULL)
ON [PRIMARY]Íž
You need to move the AccountsReceivable table from the PRIMARY file group to FG_AccountData.
Which TransactSQL statement should you use?

What should you include in the recommendation?

Your company has a main office and a branch office.
The network contains an Active Directory domain named contoso.com. The main office
contains domain controllers that run Windows Server 2012. The branch office contains a
read-only domain controller (RODC) that runs Windows Server 2012.
You need to recommend a solution to control which Active Directory attributes are replicated
to the RODC.
What should you include in the recommendation?

What should you include in the recommendation?

Your network contains an Active Directory domain named contoso.com. All domain
controllers run Windows Server 2012 R2. The forest functional level is Windows Server
2012.
Your company plans to deploy an application that will provide a search interface to users in
the company. The application will query the global catalog for the Employee-Number
attribute.
You need to recommend a solution to ensure that the application can retrieve the EmployeeNumber value from the global catalog.
What should you include in the recommendation?

You need to grant the minimum necessary permission to the application developers

You administer a SQL Server 2008 instance. The instance contains a database named DB1.

You plan to allow all the application developers to use SQL Server Profiler to capture traces
to troubleshoot the application that uses the database DB1.
You need to grant the minimum necessary permission to the application developers.
What should you do?