Free Microsoft 70-457 Exam Dumps Questions & Answers

You administer a Microsoft SQL Server 2012 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.)
Build List and Reorder:

Correct Answer:

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

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of user should you create?

• A.SQL user without login
• B.login mapped to a virtual account
• C.User mapped to an asymmetric key
• D.Domain user

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.a Policy
• B.an Alert
• C.an Extended Event session
• D.a Database Audit Specification
• E.a Server Audit Specification
• F.a Resource Pool
• G.a SQL Profiler Trace

You administer a single server that contains a Microsoft SQL Server 2012 default instance. You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions. You need to ensure that the application login is unable to access other production databases. What should you do?

• A.Install a new default SQL Server instance on the server.
• B.Use the SQL Server default instance and enable Contained Databases.
• C.Use the SQL Server default instance and configure an affinity mask.
• D.Install a new named SQL Server instance on the server.

You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain. You plan to configure database mirroring. You need to be able to create database mirroring endpoints on both servers. What should you do?

• A.Configure the SQL Server service account to use Local System.
• B.Configure the SQL Server service account to use Network Service.
• C.Use a database certificate.
• D.Use a server certificate.