Azure Data Engineer Associate (DP-203) Cert Prep: 3 Design and Implement Data Security

Learn about designing and implementing data security on Azure and begin your preparations to pass that domain of the Microsoft Azure Data Engineering (DP-203) exam.

Introduction

• Overview

1. Design Security for Data Policies and Standards

• Design a data auditing strategy
• Design a data masking strategy
• Design for data privacy
• Design a data retention policy
• Design to purge data based on business requirements
• Role-based access control and POSIX-like Access Control List for Data Lake
• Design row-level and column-level security

2. Implement Data Security

• Encrypt data at rest and in motion
• Implement POSIX-like ACLs for Data Lake Storage Gen2
• Manage identities, keys, and secrets across different data platform technologies
• Implement secure endpoints—private and public
• Implement resource tokens in Azure Databricks
• Load a DataFrame with sensitive information
• Write encrypted data to tables or Parquet files

Conclusion

• Summary and next steps