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 21 You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store the credit card numbers in the database. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer. A. One-way encryption B. Reversible […]
QUESTION 11 You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You need to identify which transaction causes the deadlock. What should you do? More than one answer choice may achieve the goal. Select the BEST answer. A. Query the sys.dm_exec_sessions dynamic management view. B. Create an extended events session […]
QUESTION 1 You have an application that uses a view to access data from multiple tables. You need to ensure that you can insert rows into the underlying tables by using the view. What should you do? A. Materialize the view. B. Create an INSTEAD OF trigger on the view. C. Define the view by […]