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

You need to identify which long running transactions use an index.
Which dynamic management view should you use?

• A.sys.dm_exec_sessions
• B.sys.dm_exec_query_stats
• C.sys.dm_exec_query_optimizer_info
• D.sys.dm_exec_connections

You need to recommend a solution for Application1 that meets the security requirements. What should you include in the recommendation?

• A.Signed stored procedures
• B.Secure Socket Layer (SSL)
• C.Certificate Authentication
• D.Encrypted columns

During performance testing, you discover that database INSERT operations against the Inventory table are slow.
You need to recommend a solution to reduce the amount of time it takes to complete the INSERT operations.
What should you recommend?

• A.Create a column store index.Master Data Services
• B.Partition the nonclustered index.
• C.Partition the Inventory table.snapshot replication
• D.Drop the clustered index.change data capture

You need to recommend a database reporting solution that meets the business requirements.
What should you include in the recommendation?

• A.Performance Monitor
• B.A maintenance plan
• C.Data collection
• D.A dynamic management view

You are building a stored procedure for a Windows Azure SQL Database. The procedure will add multiple rows to a table.
You need to design the stored procedure to meet the following requirements:
If any of the new rows violates a table constraint, then no further additions must be attempted and all changes made by the stored procedure must be discarded.
If any errors occur, a row must be added to an audit table, and the original error must be returned to the caller of the stored procedure.
What should you include in the design?

• A.An implicit transaction that has error handling enabled
• B.An explicit transaction that has XACT_ABORT disabled
• C.An explicit transaction that has error handling enabled
• D.An implicit transaction that has XACT.ABORT enabled