Examers.io
ExamsOrganizationsHow it worksPricingHelp & FAQ
Microsoft logo

Microsoft Certified:Azure Database Administrator Associate

Domain 2Objective 3

Implement Compliance Controls for Sensitive Data DP-300 Practice Questions (Page 1)

Part of the Implement a secure environment domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 29 practice questions to prepare you well beyond it. (estimate)

29questions here
6free pages
7concepts
20–25%of the exam

Questions 1–5

  1. 1foundation · easy

    You are configuring server-level auditing for an Azure SQL Database server. Which of the following is a valid destination for the audit logs?

    Select an answer first
  2. 2foundation · easy

    You are designing a data classification strategy for an Azure SQL database that stores customer names, email addresses, and credit card numbers. Which two categories would you use to classify the credit card numbers?

    Select an answer first
  3. 3foundation · easy

    You need to implement a data classification strategy for an Azure SQL database. Which Azure service or feature provides a built-in dashboard to view recommended classifications and apply them to columns?

    Select an answer first
  4. 4foundation · easy

    You need to create a table in an Azure SQL database that only allows inserts and does not allow updates or deletes, to maintain a tamper-evident log. Which type of ledger table should you create?

    Select an answer first
  5. 5application · medium

    A government agency must provide tamper-evident records of changes to a 'CitizenRecords' table in an Azure SQL database. The agency also needs to prove to auditors that the database itself has not been tampered with. You need to implement a solution that provides both table-level tamper-evidence and database-level integrity verification. What should you do?

    Select an answer first
Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.