You work for a company that provides marketing data to other companies.
You have the following Transact-SQL 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?
A. <CoffeeDrinkingCustomer Age="27" />
<CoffeeDrinkingCustomer Age="35" />
B. <CustomerDemographics>
<Customer>
<CoffeeDrinkingCustomer Age="21"/>
</Customer>
</CustomerDemographics>
C. <CustomerDemographics>
<Customer>
<CoffeeDrinkingCustomer Age="27"/>
</Customer>
<Customer>
<CoffeeDrinkingCustomer Age="35"/>
</Customer>
</CustomerDemographics>
D. <CoffeeDrinkingCustomer Age="21" />
