PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which query should you use?

You have the following XML document that contains Product information.
DECLARE @prodList xml =’
<ProductList xmlns=”urn:Wide_World_Importers/schemas/Products”>
<Product Name=”Product1″ Category=”Food” Price=”12.3″ />
<Product Name=”Product2″ Category=”Drink” Price=”1.2″ />
<Product Name=”Product3″ Category=”Food” Price=”5.1″ />

</ProductList>’Íž
You need to return a list of products that contains the Product Name, Category, and Price of each
product.
Which query should you use?

Which tool should you use?

Your network contains one Active Directory domain named contoso.com. The domain contains 10
domain controllers and a read-only domain controller (RODC) named RODC01.
You plan to replace a domain controller named DC1. DC1 has the schema operations master role.
You need to transfer the schema master role to another domain controller named DC10 before you
remove Active Directory from DC1.
Which tool should you use?

You need to ensure that both database instances are available for their respective certified third-party appli

You have a server that contains a default SQL Server 2005 instance. You need to install a
SQL Server 2008 instance for a new application on the same server. The new application
requires SQL Server 2008 functionality.
You need to ensure that both database instances are available for their respective certified
third-party applications. The existing application environments remain unchanged.
What should you do?

Which two pieces of information should you identify?

On Server1, you plan to create an inbound firewall rule that contains the following settings:
Allows inbound connections to an application named App1.exe
Applies to the domain profile
Overrides any block rules
You need to identify the minimum information required to create the rule.
Which two pieces of information should you identify? Each correct answer presents part of the
solution.

What command should you run?

Your network contains one Active Directory forest named contoso.com. The forest contains a single
domain. All domain controllers run Windows Server 2012 R2.
You need to modify the membership of a group named Group1 to include two users named User1
and User2.
What command should you run? To answer, select the appropriate options in the answer area.
Select three.