Which of the following is a valid data source which you can import into SQL Server 2012?

• A.Oracle data file
• B..DOC file
• C.Access 2010
• D.Oracle export file

Comment: *

Name: *

Email: *

Verification: *

You administer a Microsoft SQL Server 2012 database named Orders.
Orders contain a table named OrderShip that is defined as follows:

A NULL value represents a domestic order. Ninety percent of the values in CountryCode are NULL.
Customers require a procedure that will return orders for all customers from a specified country. You create a new procedure:

Performance on this procedure is slow.
You need to alter the schema to optimize this query. Objects created must use a minimum amount of resources.
Which Transact-SQL statement should you use?

• A.CREATE NONCLUSTERED INDEX IX_CountryCode ON Ordership (CountryCode)WHERE CountryCode IS NOT NULL
• B.CREATE STATISTICS ST_CountryCode ON OrderShip (CountryCode)WHERE CountryCode IS NOT NULL
• C.CREATE CLUSTERED INDEX IX_CountryCode ON OrderShip (CountryCode)
• D.CREATE INDEX IX_CountryCode ON OrderShip (CustomerID)WHERE CountryCode IS NOT NULL

Comment: *

Name: *

Email: *

Verification: *

You administer several Microsoft SQL Server database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN).
Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors.
You need to reduce the occurrence of these timeout errors.
What should you do?

• A.Set the Merge agent on the problem subscribers to use the slow link agent profile.
• B.Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
• C.Change the Merge agent on the problem subscribers to run continuously.
• D.Set the Remote Connection Timeout on the Publisher to 0.

Comment: *

Name: *

Email: *

Verification: *

DRAG DROP
You administer a Microsoft SQL Server 2012 server.
You need to install the Power View components on a stand-alone server.
Which three 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.)

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You administer a Microsoft SQL Server 2012 database named Contoso on a server named
Server01.
You need to prevent users from disabling server audits in Server01.
What should you create?

• A.a Policy
• B.a Server Audit Specification
• C.an Alert
• D.an Extended Event session
• E.a Resource Pool
• F.a SQL Profiler Trace
• G.a Database Audit Specification

Comment: *

Name: *

Email: *

Verification: *