Day: October 20, 2014

QUESTION 101Your network is configured as shown in the exhibit. (Click the Exhibit button.) Server1 regularly accesses Server2.You discover that all of the connections from Server1 to Server2 are routed through Router1.You need to optimize the connection path from Server1 to Server2.Which route command should you run on Server1? A.    Route add -p 10.10.10.0 MASK 255.255.255.0...

QUESTION 51Drag and Drop QuestionYou administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL Server...

QUESTION 41 You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server. What should you create? A.    an Extended Event session B.    a...