Dynamic Data Masking in Azure SQL
12 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the primary purpose of Dynamic Data Masking (DDM)?

  • To programmatically manage data masking policies and rules
  • To grant or revoke permissions for accessing unmasked data (correct)
  • To flag sensitive database fields for potential masking
  • To apply various masking functions to database fields

    • Which of the following is NOT a supported operation in the Dynamic Data Masking REST API?

  • Manage data masking rules
  • Provision new database instances (correct)
  • Configure permissions for data masking
  • Manage data masking policies

    • Which of the following is a built-in role that can be used to configure Dynamic Data Masking?

  • Security Manager
  • There are no built-in roles for configuring Dynamic Data Masking (correct)
  • Database Administrator
  • Data Steward

    • What is the purpose of the UNMASK permission in Dynamic Data Masking?

    <p>To grant or revoke access to view unmasked data</p> Signup and view all the answers

    Which of the following steps is required to apply data masking to a database column using the Dynamic Data Masking portal?

    <p>Select the appropriate masking function</p> Signup and view all the answers

    What is the primary benefit of using Dynamic Data Masking with Microsoft Entra authentication?

    <p>It provides a granular way to control access to unmasked data</p> Signup and view all the answers

    What does dynamic data masking in Azure SQL Database help prevent?

    <p>Unauthorized access to sensitive data</p> Signup and view all the answers

    How does dynamic data masking impact the application layer?

    <p>Minimal effect on the application layer</p> Signup and view all the answers

    Where can a dynamic data masking policy be set up in Azure SQL Database?

    <p>Azure Portal under Security in SQL Database configuration pane</p> Signup and view all the answers

    What is an example of how dynamic data masking can be used for confidentiality?

    <p>Masking all the email addresses in query results</p> Signup and view all the answers

    Why might a service representative at a call center only see partial email addresses using dynamic data masking?

    <p>To identify a caller without revealing sensitive information</p> Signup and view all the answers

    What feature helps hide sensitive data in the result set of a query over designated database fields?

    <p>Dynamic data masking</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser