PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which file extension should you use to save the script?

Your network contains an Active Directory domain named contoso.com. All servers run Windows
Server 2012 R2. The domain contains a server named Server1.
You open Review Options in the Active Directory Domain Services Configuration Wizard, and then
you click View script.
You need to ensure that you can use the script to promote Server1 to a domain controller.
Which file extension should you use to save the script?

You need to ensure that records that contain the word "root" are returned by the query

You administer a SQL Server 2008 instance and a SQL Server 2005 instance. Both
instances run on the same computer. The SQL Server 2008 instance contains a database
named WebApplicationDB that uses the Fulltext indexes.
Several records that include the word “root” are added to the WebApplicationDB database.
When the Fulltext index is queried for the word “root,” an empty resultset is returned.
You need to ensure that records that contain the word “root” are returned by the query.
What should you do?

Which built-in groups should you use?

Your network contains an Active Directory forest named contoso.com. The forest contains five
domains. All domain controllers run Windows Server 2012 R2.
The contoso.com domain contains two user accounts named Admin1 and Admin2.
You need to ensure that Admin1 and Admin2 can configure hardware and services on all of the
member servers in the forest. The solution must minimize the number of privileges granted to
Admin1 and Admin2.
Which built-in groups should you use?

Which tool should you use?

Your network contains an Active Directory domain named contoso.com.
An administrator provides you with a file that contains the information to create user accounts for
200 temporary employees. The file is shown in the exhibit. (Click the Exhibit button.)

You need to automate the creation of the user accounts. You must achieve this goal by using the
minimum amount of administrative effort.
Which tool should you use?

Which is the correct answer?

You are managing a SQL Server 2000 instance which includes a database called Products
for Home.com. You decide to install a SQL Server 2008 instance for business. You should
make sure that third-party applications could run normally on both database instances, you
could get the results by conforming to the listed conditions:1. The existed application
environments keep common. 2. Minimal database administrative effort.Which is the correct
answer?

Which results will the query return?

You have two tables named Customer and SalesOrder. In the Customer table you have 1000
customers, of which 900 customers have orders in the SalesOrder table.
You execute the following query to list all customers that have had at least one sale. SELECT *
FROM Customer
WHERE Customer.CustomerID IN (SELECT Customer.CustomerID
FROM SalesOrder)
You need to identify the results of the query.
Which results will the query return?