070-469 試験問題を無料オンラインアクセス

You have a database that is accessed by 300 concurrent users.
You need to log all of the queries that become deadlocked. The solution must meet the following requirements:
- Provide a representation of the deadlock in XML format.
- Minimize the impact on the server.
What should you create?

• A.A SQL Server Profiler trace
• B.A SQL Server Agent job that retrieves information from the sys.dm_tran_session_transactions dynamic management views
• C.A script that enables trace flags
• D.A SQL Server Agent job that retrieves information from the sys.dm_tran_active_transactions dynamic management views

DRAG DROP
You need to build a stored procedure that amortizes the invoice amount. Which code segment should you use to create the stored procedure? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

正解：

Topic 2, Scenario 2
Application Information
You have two servers named SQL1 and SQL2 that have SQL Server 2012 installed.
You have an application that is used to schedule and manage conferences.
Users report that the application has many errors and is very slow.
You are updating the application to resolve the issues.
You plan to create a new database on SQL1 to support the application. A junior database administrator has created all the scripts that will be used to create the database. The script that you plan to use to create the tables for the new database is shown in Tables.sql. The script that you plan to use to create the stored procedures for the new database is shown in StoredProcedures.sql. The script that you plan to use to create the indexes for the new database is shown in Indexes.sql. (Line numbers are included for reference only.)
A database named DB2 resides on SQL2. DB2 has a table named SpeakerAudit that will audit changes to a table named Speakers.
A stored procedure named usp_UpdateSpeakersName will be executed only by other stored procedures. The stored procedures executing usp_UpdateSpeakersName will always handle transactions.
A stored procedure named usp_SelectSpeakersByName will be used to retrieve the names of speakers. Usp_SelectSpeakersByName can read uncommitted data.
A stored procedure named usp_GetFutureSessions will be used to retrieve sessions that will occur in the future.
Procedures.sql


Indexes.sql Tables.sql

You have a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is the only database on the instance.
The application generates all T-SQL statements dynamically and does not use stored procedures.
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?

• A.Allow Triggers to Fire Others
• B.Optimize for Ad hoc Workloads
• C.Enable Contained Databases
• D.Scan for Startup Procs

DRAG DROP
You have a SQL Server 2012 database named database1.
Users report that queries that usually take less than one second to execute, take more than
30 seconds to execute.
You need to view the server resource consumption when the queries are executed.
What should you do?
To answer, move the appropriate actions from the list of actions to the answer area and
arrange them in the correct order.

正解：

You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a table that is used for auditing is updated.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.A DEFAULT constraint
• B.A CHECK constraint
• C.A data manipulation language (DML) trigger
• D.A FOREIGN KEY constraint
• E.A Data Definition Language (DDL) trigger