Configuring Encryption - describe the encryption features supported in SQL Server 2016
- describe Transparent Data Encryption and the keys used for encrypting and decrypting data
- use Transparent Data Encryption
Configuring Always Encrypted - describe the features and limitations of Always Encrypted
- use the Always Encrypted Wizard
- configure Always Encrypted using SQL Server Management Studio
- configure Always Encrypted using PowerShell
Using Encryption Technologies - describe support and limitations for encryption with Azure SQL Database
- describe the benefits, requirements, restrictions, methods, and recommended practices for backup encryption
- create an encrypted backup
- recognize the purpose of cell-level encryption and how to use Transact-SQL and symmetric encryption to configure it
- enable encrypted connections to a database
- troubleshoot encryption
Creating Users and Configuring Access - describe the types of database users and their purpose
- create a database user using SQL Server Management Studio
- create a database user using Transact-SQL
- describe available server permissions
- recognize the steps involved in granting a user access to a database and its objects
- grant access to database objects
- revoke access to database objects
Working With Roles - describe database-level roles and their purpose
- describe server-level roles and their purpose
- describe the purpose of application roles
- recognize why you would use and how to create a custom role
Configuring Data Security - describe the purpose of row-level security and how to implement it
- implement row-level security using T-SQ: and predicates
- implement row-level security using T-SQ: and predicates
- describe the purpose of dynamic data masking
- define dynamic data masking
Configuring Options for Azure SQL Database - describe the benefits and features of using Azure SQL Database
- create and configure a new Azure SQL Database
- connect to and manage an Azure SQL Database using a local instance of SSMS
Configuring Auditing - describe why auditing is required and auditing methods
- use triggers for auditing
- use temporal tables for auditing
- use temporal tables for auditing
- view the audit log using SQL Server Management Studio or sys.fn_get_audit_file
Configuring SQL Server Audit - describe the purpose of Extended Events
- describe the purpose of SQL Server Audit, auditing levels, and components
- define an audit using SQL Server Audit
- describe the purpose of actions and actions groups
- create server audit specifications
- create database audit specifications
- use dynamic management and system views to manage an audit
Auditing an Azure SQL Database - compare auditing in Azure SQL Database with SQL Server auditing and describe its purpose
- configure auditing for Azure SQL Database
- describe the purpose of audit logs and reports when auditing in Azure SQL Database
- analyze audit logs and reports when auditing in Azure SQL Database
|
