Question 1

What is database auditing and monitoring?

Accepted Answer

Database auditing and monitoring are procedures for making sure your data is secure and all the inquiries into it are valid. Database monitoring is a security technique that analyses activity for malicious actors, and with database auditing you can investigate each interaction with your data and analyze it thoroughly. And with this Configuring Encryption, Data Access, and Auditing in Microsoft SQL Server 2016 training, you can do auditing and monitoring for yourself.

Question 2

Why should I take Configuring Encryption, Data Access, and Auditing in Microsoft SQL Server 2016 training?

Accepted Answer

There are two big reasons that database administrators should consider getting this Configuring Encryption, Data Access, and Auditing in Microsoft SQL Server 2016 training. First, security and compliance. Security means knowing that you're keeping data safe and that you aren't losing money. Compliance means being able to prove that you're keeping it safe, which leads to customer confidence. The other big reason is that the very act of auditing and monitoring your data leads to cleaner, more useful data.

Question 3

Is this Configuring Encryption, Data Access, and Auditing in Microsoft SQL Server 2016 training associated with a certification?

Accepted Answer

No, this Configuring Encryption, Data Access, and Auditing in Microsoft SQL Server 2016 is no longer associated with a valid certification. The database monitoring and auditing skills you learned in this training used to apply to the MCSA: SQL 2016 Database Administration certification, but Microsoft retired that certification. The material on this training helped prepare learners for the 70-764 and 70-765 exams, but those are both retired.

Question 4

What will you learn in this database monitoring and auditing training?

Accepted Answer

This database monitoring and auditing training was originally developed to help database administrators with specific parts of the MCSA: SQL 2016 Database Administration certification exams. After this training, you'll know how to configure an audit on SQL Server, including how to query the SQL Server audit log and analyze the logs and reports. This training also covers how to monitor database activity, analyze the resource uses of different sessions, monitor queries and resolve problematic execution plans.

Question 5

Are the MCSA: SQL 2016 Database Administration exams 70-764 and 70-765 retired?

Accepted Answer

Yes, on January 31, 2021, Microsoft retired all three: 70-764, 70-765 and the certification they were attached to, the MCSA: SQL 2016 Database Administration. Although the tests and cert have retired, the information on this training is still as valid as ever. For database administrators who work with SQL Server 2016, this training is essential for understanding how to configure encryption, data access, and auditing.

Encryption, Data Access, and Auditing in SQL Server 2016 Online Training

Who This Course Is For

Course Curriculum

Platform Features

This course is included with every subscription

Small Team

Team

Enterprise

Frequently Asked Questions

Related Courses

DP-300

SQL for Data Practitioners

1Z0-071

Ready to upskill your team?