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 […]