PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

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?

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?