Scenario: A company is migrating its e-commerce database to Azure SQL. They need to ensure that the credit card information is masked for most users but visible for customer support staff. Which feature should they use?

Direct Answer (Verified)Reviewed by Sunny (Senior Cloud Engineer)

Correct Answer: Dynamic Data Masking (DDM)

Dynamic Data Masking (DDM) in Azure SQL Database masks sensitive data elements (like credit card numbers) on the fly for non-privileged query results, whilst allowing full access t...

๐Ÿ“‹Part of Microsoft Certified: Azure Administrator Associate (AZ-104) ยท Azure Certification Practice
Real Exam ScenarioScenario Based

Scenario: A company is migrating its e-commerce database to Azure SQL. They need to ensure that the credit card information is masked for most users but visible for customer support staff. Which feature should they use?

โœ“ Correct Answer & ExplanationScenario Based

Correct Answer

Dynamic Data Masking (DDM)

Why This Answer Is Correct

Dynamic Data Masking (DDM) in Azure SQL Database masks sensitive data elements (like credit card numbers) on the fly for non-privileged query results, whilst allowing full access to authorized roles.

๐Ÿ“š What This Question Tests

This question evaluates your knowledge of Scenario Based โ€” a core concept tested in Microsoft Certified: Azure Administrator Associate (AZ-104). Understanding Scenario Based is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.