Which catalog view should you use?
Your company exchanges information with other companies by using XML and Web services. Your
manager asks you to remove a schema collection that is no longer used. Before dropping the
schema,
you should confirm that it is no longer in use.
You need to use a catalog view to determine if the schema collection is being used. Which catalog
view
should you use?
You need to identify the settings that are prevented from rolling back running the CWM Witch settings should y
You have a server named Server1 that runs Windows Server 2012 R2.
You apply a security policy to server1 by using the Security Configuration Wizard (CWM).
You plan to roll back the security policy.
You need to identify the settings that are prevented from rolling back running the CWM
Witch settings should you identify.
Which cmdlet should you use?
You have a DNS server named DNS1 that runs windows server 2012 R2.
DNS1 is used to resolve the names of internet resources by using several DNS forwarders.
You need to prevent DNS1 from performing iterative queries if the DNS forwarders are unable to
reslove the queries.
Which cmdlet should you use?
You need to check the physical consistency of the database
You administer a Microsoft SQL Server 2008 R2 instance.
You need to check the physical consistency of the database.
What should you do?
Which four actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The service account
used by SQL Server services must not have administrative permissions.
You configure a new SQL Server Agent job to run every night. One of the steps in the job
runs an
Operating System (CmdExec) step. The job continuously fails on this step and throws the
following error message: “The user does not have sufficient permission to perform the
operation.”
You need to ensure that the SQL Server Agent Job executes successfully. Which four
actions should you perform in sequence? (To answer, move the appropriate actions from the
list of actions to the answer area and arrange them in the correct order.)
What should you identify?
You have a Hyper-V host named server1 that runs windows server 2012 R2.server1 host 50 virtual
machines that run windows server 2012 R2
You enable and configure enhanced session mode on Server1.
You need to identify a new functionality available for the virtual machines hosted on server1.
What should you identify?
You need to rectify a damaged index without losing any data
You administer a Microsoft SQL Server 2008 R2 instance.
You need to rectify a damaged index without losing any data.
What should you do?
Which code segment should you use?
You have an XML schema that you must use to validate XML data in your database. You need to
store this XML schem
a. Which code segment should you use?
Which Transact-SQL statement(s) should you execute in the DB1 database?
You administer a SQL Server 2008 instance that contains a database named DB1. DB1
contains a table named Sales.Table1.
You need to obtain the effective permissions of a user named User1 to access the
Sales.Table1 table.
Which Transact-SQL statement(s) should you execute in the DB1 database?
Which TransactSQL statements should you use?
You have a table named Customers that has an XML column named CustomerDat
a. There are
currently no indexes on the table.
You use the following WHERE clause in a query:
WHERE CustomerData.exist (‘/CustomerDemographic/@Age[.>=”21″]’) = 1
You need to create indexes for the query.
Which TransactSQL
statements should you use?