Case Study:
Leafield Solutions
You need to meet the design requirement for the ProductTypes table in the Product database. Which of the
following would be the best solution?

Case Study:
Leafield Solutions
You need to ensure that the account used to generate reports can only connect during certain hours. What
should you configure?

Case Study:
Leafield Solutions
You need to enable users to modify data in the database tables using UPDATE operations. You need to
implement a solution that meets the design requirements. What should you configure?

Case Study:
Leafield Solutions
You need to configure a synchronization solution to copy data from the Current_Inventory database the
DesABCopAppDB database. What should you configure?

Case Study:
Leafield Solutions
The performance of the SPUpdate2 stored procedure needs to be improved. Your solution must meet the
design requirements. What should your solution include?

Case Study:
Fairstone Manufacturing Inc.
You need to recommend a solution to meet the recovery requirements for the manufacturing database. Your
solution must minimize costs. What should you recommend?

Case Study:
Fairstone Manufacturing Inc.
You need to provide a group of users from the IT and Manufacturing departments the minimum administrative
rights to view database information and server state for the Manufacturing database on MainDB1. What should
you do?

Case Study:
Fairstone Manufacturing Inc.
You need to enable the Developers to assign SQL Server instances on MainDB3 and MainDB4 to specific
processors on the servers. What should you configure?

Case Study:
Fairstone Manufacturing Inc.
You need to address the Sales Director’s requirements regarding the customer classification. You need to
recommend a solution for changing the classifictaions. What should you recommend?

Case Study:
Fairstone Manufacturing Inc.
You need to address the requirements for disc usage monitoring for the SQL Servers. What should you do?