1. Microsoft recommends using a server operating system rather than a desktop operating system for the deployment of SQL Server. Why might the use of a desktop operating system hinder the performance of SQL Server?
2. Your instructor has endeavored to emphasize the importance of security. What are some basic examples of ways to provide physical security for a SQL Server Database Management System? What can be done about logical security for the DBMS and the Data?
3. Discuss the two different types of authentication available for SQL Server. What are they? What are the advantages and disadvantages of each authentication type?
4. List and describe three different SQL Server authentication password policies.
5. Describe how SQL Server logins function at the SQL Server instance level and how they relate to accessing the database instances.
6. We have had class discussions regarding the choice of table indexes. What is an index? What are the advantages and disadvantages of using indexes? What type of data might serve as a valuable index for a table, and what types of data would be unsuitable for an index.
7. Identify three of the fixed roles provided at the server instance level and explain some of their associated permissions/privileges and their ability to perform administrative tasks
8. Discuss the two different types of encryption keys: Symmetric and Asymmetric. What are they used for?
9. Discuss the importance of using encryption for databases that hold confidential information. What types of information should be encrypted?
10. What are Database Schemas within Microsoft SQL Server? What is the advantages/disadvantages of granting permissions on a schema versus individual objects for a user or role?
11. Describe the purpose of each of the following system databases in SQL Server 2012:
    1. Master
    2. Tempdb
    3. Model
    4. Msdb
12. What is the importance of maintaining backups and security precautions that should be taken to protect the backups and the data they contain.