QUESTION 31
You need to recommend a solution to ensure that sp4 adheres to the security requirements. What should you include in the recommendation?
A. Configure data manipulation language(DML) triggers.
B. Enable SQL Server Audit.
C. Enable trace flags.
D. Enable C2 audit tracing.
Answer: B
QUESTION 32
You need to recommend a change to sp3 to ensure that the procedure continues to execute even if one of the UPDATE statements fails. Which change should you recommend?
A. Set the IMPLICIT_TRANSACTIONS option to on.
B. Set the XACT_ABORT option to off.
C. Set the IMPLICIT_TRANSACTIONS option to off.
D. Set the XACT_ABORT option to on.
Answer: B
QUESTION 33
You need to recommend a solution that addresses the concurrency requirement. What should you recommend?
A. Make calls to Sales.Proc1 and Sales.Proc2 synchronously.
B. Modify the stored procedures to update tables in the same order for all of the stored procedures.
C. Call the stored procedures in a Distributed Transaction Coordinator (DTC) transaction.
D. Break each stored procedure into two separate procedures, one that changes Sales.Table1 and one t
hat changes Sales.Table2.
Answer: B
QUESTION 34
You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort. What should you include in the recommendation?
A. filegroups
B. indexed views
C. table partitioning
D. indexes
Answer: A
QUESTION 35
You need to recommend a solution that addresses the index fragmentation and index width issue. What should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)
A. Change the data type of the lastModified column to smalldatetime.
B. Remove the modifiedBy column from the clustered index.
C. Change the data type of the id column to bigint.
D. Remove the lastModified column from the clustered index.
E. Change the data type of the modifiedBy column to tinyint.
F. Remove the id column from the clustered index.
Answer: ABF
QUESTION 36
You need to recommend a solution that meets the data recovery requirement. What should you include in the recommendation?
A. a differential backup
B. snapshot isolation
C. a transaction log backup
D. a database snapshot
Answer: D
QUESTION 37
You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application. What should you recommend changing?
A. the data type of the ProductName column
B. the collation of the Products table
C. the collation of the ProductName column
D. the index on the ProductName column
Answer: C
QUESTION 38
You need to recommend an isolation level for usp_UpdateOrderDetails. Which isolation level should recommend?
A. repeatable read
B. serializable
C. read uncommitted
D. read committed
Answer: A
QUESTION 39
You need to recommend a solution for Application 1 that meets the security requirements. What should you include in the recommendation?
A. Encrypted columns
B. Certificate Authentication
C. Signed stored procedures
D. Secure Socket Layer (SSL)
Answer: A
QUESTION 40
You need to recommend a solution to improve the performance of usp_UpdateInventory. The solution must minimize the amount of development effort. What should you include in the recommendation?
A. a table variable
B. a subquery
C. a common table expression
D. a cursor
Answer: C
If you want to pass Microsoft 70-459successfully, donot missing to read latest lead2pass Microsoft 70-459 practice tests.
If you can master all lead2pass questions you will able to pass 100% guaranteed.