Which file system should the server administration team choose?
A company’s server administration team would like to take advantage of the newest file systems
available with Windows Server 2012 R2. The team needs a file system capable of managing
extremely large data drives that can auto-detect data corruption and automatically perform needed
repairs without taking a volume offline.
Which file system should the server administration team choose?
You need to set up the mirroring session to support the high volume of write transactions to the database
You manage two SQL Server 2008 instances on separate servers named Server1 and
Server2. The servers are located in different cities.
You plan to implement database mirroring between the two instances.
You need to set up the mirroring session to support the high volume of write transactions to
the database.
You do not want small errors to impact the principal server.
What should you do?
Which technology should the team choose?
A company’s server security team needs a solution that will prevent users from installing and using
unauthorized applications on their Windows 8 desktop computers.
Which technology should the team choose?
Which of the following could possibly be causes for the failure?
You are attempting to delete a global security group in the Active Directory Users and Computers
console, and the console will not let you complete the task.
Which of the following could possibly be causes for the failure? (Choose all answers that are
correct.)
which of the following security principals can be members of a global group?
In a domain running at the Windows Server 2012 R2 domain functional level, which of the following
security principals can be members of a global group? (Choose all answers that are correct.)
Which of the following group scope modifications are never permitted?
Which of the following group scope modifications are never permitted? (Choose all answers that are
correct.)
You need to monitor processor resources
You maintain a SQL Server 2008 instance.
You use the Resource Governor to manage processor resources on the server for a newly
deployed application named App1. App1 is assigned to a custom workload group named
MyApp.
You need to monitor processor resources.
What should you do?
Which of the following is not a correct reason for creating an OU?
Which of the following is not a correct reason for creating an OU?
What result should you expect?
You work for a company that provides marketing data to other companies.
You have the following TransactSQL
statement:
DECLARE @CustomerDemographics XML
SET @CustomerDemographics=N’
<CustomerDemographics>
<Customer CustomerID=”1″ Age=”21″ Education=”High School”>
<IsCoffeeDrinker>0</IsCoffeeDrinker>
</Customer>
<Customer CustomerID=”2″ Age=”27″ Education=”College”>
<IsCoffeeDrinker>1</IsCoffeeDrinker>
<IsFriendly>1</IsFriendly>
</Customer>
<Customer CustomerID=”3″ Age=”35″ Education=”Unknown”>
<IsCoffeeDrinker>1</IsCoffeeDrinker>
<IsFriendly>1</IsFriendly>
</Customer>
</CustomerDemographics>’
DECLARE @OutputAgeOfCoffeeDrinkers XML
SET @OutputAgeOfCoffeeDrinkers = @CustomerDemographics.query(‘
for $output in /child::CustomerDemographics/child::Customer[
( child::IsCoffeeDrinker[1] cast as xs:boolean )]
return
<CoffeeDrinkingCustomer>
{ $output/attribute::Age \}
</CoffeeDrinkingCustomer>’)
SELECT @OutputAgeOfCoffeeDrinkers
You need to determine the result of the query.
What result should you expect?
Which of the following groups do you use to consolidate groups and accounts that either span multiple domains
Which of the following groups do you use to consolidate groups and accounts that either span
multiple domains or the entire forest?