Exam 98-364: Database Fundamentals/Administering a Database

This lesson covers Administering a Database. It looks at database security concepts and backup and restore.

Activity 1 - Understand Database Security Concepts

This objective may include but is not limited to: understanding the need to secure a database, what objects can be secured, what objects should be secured, user accounts, and roles.

1. Read Database Security.
2. Read Security Concepts.

Activity 2 - Understand Database Backups and Restore

This objective may include but is not limited to: understanding various backup types, such as full and incremental, importance of backups, how to restore a database.

1. Read Create a Full Database Backup.
2. Read Restore a Backup from a Device.

References

• Exam 98-364 Database Administration Fundamentals Student Study Guide
• Microsoft: Database Fundamentals Exam Details