Instantly download 70-459 training test engine

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. Create an extended events session to capture deadlock information.
• B. Query the sys.dm_exec_sessions dynamic management view.
• C. Create a trace in SQL Server Profiler that contains the Deadlock graph event.
• D. Query the sys.dm_exec_requests dynamic management view.

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 collation of the Products table
• B. the collation of the ProductName column
• C. the data type of the ProductName column
• D. the index on the ProductName column

Your company has a SQL Azure subscription.
You implement a database named Database1. Database1 has two tables named Table1 and Table2. You create a stored procedure named sp1. Sp1 reads data from Table1 and inserts data
into Table2.
A user named User1 informs you that he is unable to run sp1.
You verify that User1 has the SELECT permission on Table1 and Table2.
You need to ensure that User1 can run sp1. The solution must minimize the number of permissions assigned to User1.
What should you do?

• A. Add User1 to the db_datawriter role.
• B. Change sp1 to run as the sa user.
• C. Grant User1 the EXECUTE permission on sp1.
• D. Grant User1 the INSERT permission on Table2.

DRAG DROP
You need to recommend a backup process for data warehouse database.
The solution must meet the following requirements:
- Ensure that if a hardware failure occurs, you can bring the database online without
losing more than 24 hours of transactions. - Minimize the amount of administrative effort required to restore any lost data. - Minimize the space used by transaction logs.
What should you include in the recommendation?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You are designing your maintenance plan.
Which command should you use only during the monthly maintenance window?

• A. DBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex)
• B. ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)
• C. ALTER INDEX SODIndex ON SalesOrderDetail REORGANIZE
• D. ALTER INDEX SODIndex ON SalesOrderDetail REBUILD