Focus on this objective today: Implement data security and compliance: Secure GraphQL, REST, and MCP endpoints. Explain it in your own words, apply it to one realistic scenario, and verify the details against the official source. Source context: Read in English Implement data security and compliance with SQL Module 11 Units Feedback Intermediate Database Administrator Developer Data Engineer SQL Server Azure SQL Database Microsoft Fabric Learn how to protect sensitive data and meet compliance requirements by implementing encryption, masking, access controls, and auditing across Microsoft's SQL platforms. Learning objectives By the end of this module, you'll be able to: Design and implement data encryption using Always Encrypted and column-level encryption Configure Dynamic Data Masking to protect sensitive data Implement Row-Level Security to filter data access based on user context Design object-level permissions and implement secure, passwordless database access using Microsoft Entra ID Configure auditing to track database activity Secure model endpoints and API endpoints for modern applications Add Prerequisites Experience writing T-SQL queries and developing databases in SQL Server, Azure SQL, or SQL databases in Microsoft Fabric Familiarity with database security concepts such as authentication and authorization Understanding of Microsoft Entra ID basics Access to a SQL Server, Azure SQL Database, or SQL database in Microsoft Fabric for testing Introduction min Protect data with encryption min Configure dynamic data masking min Implement row-level security min Manage permissions and secure access min Implement auditing min Configure secure access to AI services min Secure data API endpoints min Exercise: Implement security features min Module assessment min Summary min Take the module assessment Module Assessment Results Assess your understanding of this module. Sign in and answer all questions correctly to earn a pass designation on your profile.
Objective
Implement data security and compliance: Secure GraphQL, REST, and MCP endpoints