Exam Ref 70-764 Administering a SQL Database Infrastructure

Chapter 1. Configure data access and auditing

Important Have you read page xiii?

It contains valuable information regarding the skills you need to pass the exam.

An organization’s data is one of its most important assets, and in the twenty-first century securing your data is paramount. In this chapter we will examine the skills required to protect sensitive data through encryption, to control data access, and importantly to audit data access. In a lot of sectors there are common compliances and governance requirements, and SQL Server has technology and tools to help you achieve any such compliance.

Data loss comes in many forms, including hardware failure, database corruption, malicious activity, and user error, so you should develop a DRP ...