DRAG DROP

You administer a Microsoft SQL Server instance that contains a database of confidential data.

You need to encrypt the database files at the page level. You also need to encrypt the transaction log files.

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.)

Reveal Solution Hide Solution

Correct Answer:

Explanation:

References: http://msdn.microsoft.com/en-us/library/bb510663.aspx http://msdn.microsoft.com/en-us/library/bb934049.aspx

You administer a Microsoft SQL Server server. You plan to deploy new features to an application.

You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.

What should you do?

Reveal Solution Hide Solution

You administer a Microsoft SQL Server database named Contoso on a server named Server01.

You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01.

What should you create?

Reveal Solution Hide Solution

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

You need to be notified immediately when fatal errors occur on Server01.

What should you create?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

DRAG DROP

You administer a Microsoft SQL Server database server that has a database named Contoso. The Contoso database has a table named EmployeeSalary in a schema named HumanResources.

You need to create a script that writes audit events into the application log whenever data in the EmployeeSalary table is modified by the public principal.

Which four Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)

Reveal Solution Hide Solution

Correct Answer:

Explanation:

References: http://msdn.microsoft.com/en-us/library/cc280386.aspx http://msdn.microsoft.com/en-us/library/cc280448.aspx http://msdn.microsoft.com/en-us/library/cc280404.aspx

DRAG DROP

You administer a Microsoft SQL Server database. Your database is experiencing deadlock issues. You need to be able to monitor deadlocks.

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.

Reveal Solution Hide Solution

Correct Answer:

You administer a Microsoft SQL Server 2012.

A process that normally runs in less than 10 seconds has been running for more than an hour. You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being blocked.

Which Transact-SQL statement should you use?

Reveal Solution Hide Solution

You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database.

You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.

You also need to maintain transactional consistency of the data across both servers.

You need to achieve these goals without manual intervention.

Which configuration should you use?

Reveal Solution Hide Solution