Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 認定 070-457 試験問題:

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

2. You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages. You create a user account in the msdb database for the AgentPortalUser login. You use the Database Mail Configuration Wizard to create a Database Mail profile. Security has not been configured for the Database Mail profile. You need to ensure that AgentPortalUser can send email messages. What should you do?

A) In the Database Mail Configuration Wizard, create an email account for each recipient's email address in the Database Mail profile.
B) Disable the guest user in the msdb database.
C) In the Database Mail Configuration Wizard, configure the Database Mail profile as a private profile for the AgentPortalUser account.
D) Use the sysmail_help_profileaccount_sp stored procedure to add accounts to the Database Mail profile.

3. You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long wait times when they submit data into the application. You need to identify which queries are taking longer than 1 second to run over an extended period of time. What should you do?

A) Use sp_configure to set a value for blocked process threshold. Create an extended event session.
B) Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.
C) Use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000.
D) Run the sp_who command from a query window.
E) Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step.

4. You administer a single server that contains a Microsoft SQL Server 2012 default instance on which several production databases have been deployed. You plan to install a new ticketing application that requires the deployment of a database on the server. The SQL login for this application requires sysadmin permissions. You need to ensure that the login for the ticketing application cannot access other production databases. What should you do?

A) Use the SQL Server default instance and configure a user-defined server role. Add the login for the ticketing application to this role.
B) Install a new default SQL Server instance on the server.
C) Use the SQL Server default instance and enable Contained Databases.
D) Install a new named SQL Server instance on the server.

5. 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?

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

質問と回答：