mcAfee Secure Website
23

Microsoft DP-300 Bundle

Exam Code: DP-300

Exam Name Administering Microsoft Azure SQL Solutions

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: Azure Database Administrator Associate

DP-300 Training Materials $44.99

Reliable & Actual Study Materials for DP-300 Exam Success

The Latest DP-300 Exam Questions as Experienced in the Actual Test!

  • 24
    Questions & Answers

    DP-300 Questions & Answers

    470 Questions & Answers

    Includes questions types found on actual exam such as drag and drop, simulation, type in, and fill in the blank.

  • 25
    DP-300 Video Course

    DP-300 Training Course

    130 Video Lectures

    Based on Real Life Scenarios which you will encounter in exam and learn by working with real equipment.

  • exam =30
    Study Guide

    DP-300 Study Guide

    672 PDF Pages

    Study Guide developed by industry experts who have written exams in the past. They are technology-specific IT certification researchers with at least a decade of experience at Fortune 500 companies.

exam =32

Administering Microsoft Azure SQL Solutions (DP-300) Practice Tests

Guarantee

Satisfaction Guaranteed

Pass4sure has a remarkable Microsoft Candidate Success record. We're confident of our products and provide no hassle product exchange. That's how confident we are!

99.3% Pass Rate
Total Cost: $194.97
Bundle Price: $149.98

Purchase Individually

  • exam =34
    Questions & Answers

    Questions & Answers

    470 Questions

    $124.99
    exam =35
  • exam =37
    DP-300 Video Course

    Training Course

    130 Video Lectures

    $39.99
  • exam =36
    Study Guide

    Study Guide

    672 PDF Pages

    $29.99

Microsoft DP-300 Practice Test 25

Question 240

An Azure SQL operations team investigates: A database owner confuses TDE with encryption of the client network connection. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.
  2. Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue.
  3. A controlled access or schema-change event appears in the approved audit store with expected principal and timestamp.
  4. Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.
  5. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.

Explanation

Correct Answers

B:

The acceptance evidence for this incident (A database owner confuses TDE with encryption of the client network connection.) is: Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue. It directly tests whether the remediation (Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.) solves the specified issue, instead of proving an unrelated database control works.

D:

The reported Azure SQL or SQL Server condition is: A database owner confuses TDE with encryption of the client network connection. The specific supported administrative response is: Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management. The technical risk is: TDE protects physical database files and backups at rest but does not by itself hide plaintext from authorized SQL queries. Confirm the correction with: Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue.

Incorrect Answers

A:

Customer-managed tde keys in azure key vault (2.2) addresses another technical failure: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue.

C:

SQL database auditing and audit storage (2.3) would demonstrate or implement: A controlled access or schema-change event appears in the approved audit store with expected principal and timestamp. This case instead tests Transparent data encryption at rest (2.2); the choice measures or changes another part of the system.

E:

Managed identity database access (2.1) addresses another technical failure: Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely. The paired-answer requirement concerns Transparent data encryption at rest (2.2); this alternative does not provide the matching intervention and separate acceptance evidence.

Question 241

An Azure database administrator observes: A compliance team requires control over encryption-key lifecycle for a managed Azure SQL server. Which action best addresses the specific technical requirement?

  1. Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.
  2. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  3. Use supported private endpoints and private DNS configuration for Azure SQL Database and restrict public network access when private connectivity is required.
  4. Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A compliance team requires control over encryption-key lifecycle for a managed Azure SQL server. The specific supported administrative response is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards. The technical risk is: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. Confirm the correction with: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Incorrect Answers

B:

Dynamic data masking limitations (2.3) addresses another technical failure: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

C:

Azure SQL private endpoints and public exposure (2.2) addresses another technical failure: A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect. This case instead tests Customer-managed tde keys in azure key vault (2.2); the choice measures or changes another part of the system.

D:

SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The required corrective action concerns Customer-managed tde keys in azure key vault (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 242

During post-change validation, the team reports: A compliance team requires control over encryption-key lifecycle for a managed Azure SQL server. Which observation best demonstrates that the appropriate correction worked?

  1. Approved users authenticate with expected policies while disabled credentials fail and access is logged.
  2. Inside-VNet DNS resolves the intended private endpoint, allowed clients connect and prohibited public access fails.
  3. Authorized privileged users see expected values and restricted users receive masked output under tested permissions.
  4. A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Explanation

Correct Answer

D:

The acceptance evidence for this incident (A compliance team requires control over encryption-key lifecycle for a managed Azure SQL server.) is: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes. It directly tests whether the remediation (Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

SQL authentication management on SQL server vms (2.1) would demonstrate or implement: Approved users authenticate with expected policies while disabled credentials fail and access is logged. The case states: A compliance team requires control over encryption-key lifecycle for a managed Azure SQL server. The most direct evidence is: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

B:

Azure SQL private endpoints and public exposure (2.2) would demonstrate or implement: Inside-VNet DNS resolves the intended private endpoint, allowed clients connect and prohibited public access fails. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

C:

Dynamic data masking limitations (2.3) would demonstrate or implement: Authorized privileged users see expected values and restricted users receive masked output under tested permissions. This case instead tests Customer-managed tde keys in azure key vault (2.2); the choice measures or changes another part of the system.

Question 243

An Azure database administrator observes: A DBA rotates a customer-managed TDE key but forgets to authorize the SQL resource identity. Which action best addresses the specific technical requirement?

  1. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  2. Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives.
  3. Use supported private endpoints and private DNS configuration for Azure SQL Database and restrict public network access when private connectivity is required.
  4. Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: A DBA rotates a customer-managed TDE key but forgets to authorize the SQL resource identity. The specific supported administrative response is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards. The technical risk is: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. Confirm the correction with: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Incorrect Answers

A:

Dynamic data masking limitations (2.3) addresses another technical failure: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. The case states: A DBA rotates a customer-managed TDE key but forgets to authorize the SQL resource identity. The most direct corrective action is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.

B:

SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

C:

Azure SQL private endpoints and public exposure (2.2) addresses another technical failure: A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect. This case instead tests Customer-managed tde keys in azure key vault (2.2); the choice measures or changes another part of the system.

Question 244

In a database operations review, a team encounters: A DBA rotates a customer-managed TDE key but forgets to authorize the SQL resource identity. Which failure or exposure is most directly relevant?

  1. Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data.
  2. A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect.
  3. Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage.
  4. Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management.

Explanation

Correct Answer

C:

The incident (A DBA rotates a customer-managed TDE key but forgets to authorize the SQL resource identity.) most directly exposes: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. The resulting safe technical response is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards. Its verification is: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Incorrect Answers

A:

Dynamic data masking limitations (2.3) would demonstrate or implement: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. The case states: A DBA rotates a customer-managed TDE key but forgets to authorize the SQL resource identity. The most direct risk is: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage.

B:

Azure SQL private endpoints and public exposure (2.2) would demonstrate or implement: A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

D:

SQL authentication management on SQL server vms (2.1) would demonstrate or implement: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The required risk concerns Customer-managed tde keys in azure key vault (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 245

An Azure database administrator observes: An Azure Key Vault firewall rule blocks the database service from its encryption protector. Which action best addresses the specific technical requirement?

  1. Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.
  2. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  3. Use supported private endpoints and private DNS configuration for Azure SQL Database and restrict public network access when private connectivity is required.
  4. Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: An Azure Key Vault firewall rule blocks the database service from its encryption protector. The specific supported administrative response is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards. The technical risk is: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. Confirm the correction with: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Incorrect Answers

B:

Dynamic data masking limitations (2.3) addresses another technical failure: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

C:

Azure SQL private endpoints and public exposure (2.2) addresses another technical failure: A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect. This case instead tests Customer-managed tde keys in azure key vault (2.2); the choice measures or changes another part of the system.

D:

SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The required corrective action concerns Customer-managed tde keys in azure key vault (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 246

During post-change validation, the team reports: An Azure Key Vault firewall rule blocks the database service from its encryption protector. Which observation best demonstrates that the appropriate correction worked?

  1. Inside-VNet DNS resolves the intended private endpoint, allowed clients connect and prohibited public access fails.
  2. Approved users authenticate with expected policies while disabled credentials fail and access is logged.
  3. A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.
  4. Authorized privileged users see expected values and restricted users receive masked output under tested permissions.

Explanation

Correct Answer

C:

The acceptance evidence for this incident (An Azure Key Vault firewall rule blocks the database service from its encryption protector.) is: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes. It directly tests whether the remediation (Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Azure SQL private endpoints and public exposure (2.2) would demonstrate or implement: Inside-VNet DNS resolves the intended private endpoint, allowed clients connect and prohibited public access fails. The case states: An Azure Key Vault firewall rule blocks the database service from its encryption protector. The most direct evidence is: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

B:

SQL authentication management on SQL server vms (2.1) would demonstrate or implement: Approved users authenticate with expected policies while disabled credentials fail and access is logged. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

D:

Dynamic data masking limitations (2.3) would demonstrate or implement: Authorized privileged users see expected values and restricted users receive masked output under tested permissions. The required evidence concerns Customer-managed tde keys in azure key vault (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 247

An Azure database administrator observes: A production database depends on a vault key that is scheduled for deletion without a recovery plan. Which action best addresses the specific technical requirement?

  1. Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives.
  2. Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.
  3. Use supported private endpoints and private DNS configuration for Azure SQL Database and restrict public network access when private connectivity is required.
  4. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.

Explanation

Correct Answer

B:

The reported Azure SQL or SQL Server condition is: A production database depends on a vault key that is scheduled for deletion without a recovery plan. The specific supported administrative response is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards. The technical risk is: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. Confirm the correction with: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Incorrect Answers

A:

SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The case states: A production database depends on a vault key that is scheduled for deletion without a recovery plan. The most direct corrective action is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.

C:

Azure SQL private endpoints and public exposure (2.2) addresses another technical failure: A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect. This case instead tests Customer-managed tde keys in azure key vault (2.2); the choice measures or changes another part of the system.

D:

Dynamic data masking limitations (2.3) addresses another technical failure: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. The required corrective action concerns Customer-managed tde keys in azure key vault (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 248

In a database operations review, a team encounters: A production database depends on a vault key that is scheduled for deletion without a recovery plan. Which failure or exposure is most directly relevant?

  1. Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage.
  2. Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data.
  3. Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management.
  4. A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect.

Explanation

Correct Answer

A:

The incident (A production database depends on a vault key that is scheduled for deletion without a recovery plan.) most directly exposes: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. The resulting safe technical response is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards. Its verification is: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Incorrect Answers

B:

Dynamic data masking limitations (2.3) would demonstrate or implement: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

C:

SQL authentication management on SQL server vms (2.1) would demonstrate or implement: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. This case instead tests Customer-managed tde keys in azure key vault (2.2); the choice measures or changes another part of the system.

D:

Azure SQL private endpoints and public exposure (2.2) would demonstrate or implement: A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect. The required risk concerns Customer-managed tde keys in azure key vault (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 249

An Azure database administrator observes: An auditor wants evidence that a customer-managed encryption key can be rotated without losing database accessibility. Which action best addresses the specific technical requirement?

  1. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  2. Use supported private endpoints and private DNS configuration for Azure SQL Database and restrict public network access when private connectivity is required.
  3. Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.
  4. Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives.

Explanation

Correct Answer

C:

The reported Azure SQL or SQL Server condition is: An auditor wants evidence that a customer-managed encryption key can be rotated without losing database accessibility. The specific supported administrative response is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards. The technical risk is: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. Confirm the correction with: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Incorrect Answers

A:

Dynamic data masking limitations (2.3) addresses another technical failure: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. The case states: An auditor wants evidence that a customer-managed encryption key can be rotated without losing database accessibility. The most direct corrective action is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.

B:

Azure SQL private endpoints and public exposure (2.2) addresses another technical failure: A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

D:

SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The required corrective action concerns Customer-managed tde keys in azure key vault (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 250

An Azure SQL operations team investigates: An auditor wants evidence that a customer-managed encryption key can be rotated without losing database accessibility. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives.
  2. Use supported private endpoints and private DNS configuration for Azure SQL Database and restrict public network access when private connectivity is required.
  3. Authorized privileged users see expected values and restricted users receive masked output under tested permissions.
  4. Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.
  5. A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

Explanation

Correct Answers

D:

The reported Azure SQL or SQL Server condition is: An auditor wants evidence that a customer-managed encryption key can be rotated without losing database accessibility. The specific supported administrative response is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards. The technical risk is: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. Confirm the correction with: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.

E:

The acceptance evidence for this incident (An auditor wants evidence that a customer-managed encryption key can be rotated without losing database accessibility.) is: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes. It directly tests whether the remediation (Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The case states: An auditor wants evidence that a customer-managed encryption key can be rotated without losing database accessibility. The most direct paired action and test is: Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.

B:

Azure SQL private endpoints and public exposure (2.2) addresses another technical failure: A created private endpoint without correct DNS resolution or network controls can still leave clients using public endpoints or unable to connect. This choice can be useful for that problem, but it does not establish the Customer-managed tde keys in azure key vault (2.2) control being assessed here.

C:

Dynamic data masking limitations (2.3) would demonstrate or implement: Authorized privileged users see expected values and restricted users receive masked output under tested permissions. This case instead tests Customer-managed tde keys in azure key vault (2.2); the choice measures or changes another part of the system.