Which query should you use?
You have two tables named Customer and SalesOrder.
You need to identify all customers that have not yet made any purchases and those that have only
made
orders with an OrderTotal less than 100.
Which query should you use?
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?
You need to ensure that all SQL Server instances are consistently configured for the following aspects…?
You administer several SQL Server 2008 instances.
You need to ensure that all SQL Server instances are consistently configured for the
following aspects:
-Naming conventions -Security settings -Force index creation -Avoidance of data
fragmentation
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?
What should you configure?
Your network contains a server named Server1 that runs Windows Server 2012 R2.Server1 has the
Hyper-V server role installed. Server1 hosts four virtual machines named VM1, VM2, VM3, and
VM4.Server1 is configured as shown in the following table.
You need to configure VM4 to track the CPU, memory, and network usage.
What should you configure?
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 tool should you use?
You have a server named Server1 that runs Windows Server 2012 R2.
You need to enable access-based enumeration for a file share on Server1.
Which tool should you use?
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?