1.
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?
2.
You need to recommend a solution to allow application users to perform tables. The solution must meet the business requirements. What should you recommend?
3.
You need to recommend a feature to support your backup solution. What should you include in the recommendation?
4.
You need to recommend a solution for Application1 that meets the security requirements. What should you include in the recommendation?
 
5.
You need to recommend a disk monitoring solution that meets the business requirements. What should you include in the recommendation?
6.
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?
7.
You need to recommend a solution for the deployment of SQL Server 2014. The solution must meet the business requirements. What should you include in the recommendation?
8.
You need to recommend a solution to synchronize Database2 to App1_Db1. What should you recommend?
9.
You need to recommend a database reporting solution that meets the business requirements. What should you include in the recommendation?
10.
You need to recommend an isolation level for usp_UpdateOrderDetails. Which isolation level should you recommend?