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 24

Question 230

An Azure SQL operations team investigates: A database user has overlapping role grants and DENY permissions that require effective access analysis. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.
  2. Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.
  3. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  4. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.
  5. Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

Explanation

Correct Answers

B:

The reported Azure SQL or SQL Server condition is: A database user has overlapping role grants and DENY permissions that require effective access analysis. The specific supported administrative response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. The technical risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. Confirm the correction with: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.

E:

The acceptance evidence for this incident (A database user has overlapping role grants and DENY permissions that require effective access analysis.) is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail. It directly tests whether the remediation (Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Azure SQL firewall rule scoping (2.2) addresses another technical failure: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The case states: A database user has overlapping role grants and DENY permissions that require effective access analysis. The most direct paired action and test is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.

C:

Microsoft entra administrator for azure SQL (2.1) addresses another technical failure: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.

D:

SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. The required paired action and test concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 231

An Azure database administrator observes: A finance database must protect stored database files against disclosure from stolen storage media. Which action best addresses the specific technical requirement?

  1. Configure Azure SQL or SQL Server auditing to collect relevant database events into appropriately restricted log destinations with retention controls.
  2. Configure supported customer-managed TDE protector keys in Azure Key Vault or Managed HSM with required identity permissions and key availability safeguards.
  3. Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.
  4. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.

Explanation

Correct Answer

C:

The reported Azure SQL or SQL Server condition is: A finance database must protect stored database files against disclosure from stolen storage media. 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:

SQL database auditing and audit storage (2.3) addresses another technical failure: Audit events written only to a disposable or broadly writable destination may be lost or tampered with. The case states: A finance database must protect stored database files against disclosure from stolen storage media. The most direct corrective action is: Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.

B:

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. This choice can be useful for that problem, but it does not establish the Transparent data encryption at rest (2.2) control being assessed here.

D:

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 required corrective action concerns Transparent data encryption at rest (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 232

During post-change validation, the team reports: A finance database must protect stored database files against disclosure from stolen storage media. Which observation best demonstrates that the appropriate correction worked?

  1. The workload obtains a supported short-lived token and accesses only allowed SQL objects with no reusable password in source.
  2. A controlled access or schema-change event appears in the approved audit store with expected principal and timestamp.
  3. A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.
  4. Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue.

Explanation

Correct Answer

D:

The acceptance evidence for this incident (A finance database must protect stored database files against disclosure from stolen storage media.) 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.

Incorrect Answers

A:

Managed identity database access (2.1) would demonstrate or implement: The workload obtains a supported short-lived token and accesses only allowed SQL objects with no reusable password in source. The case states: A finance database must protect stored database files against disclosure from stolen storage media. The most direct evidence is: Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue.

B:

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 choice can be useful for that problem, but it does not establish the Transparent data encryption at rest (2.2) control being assessed here.

C:

Customer-managed tde keys in azure key vault (2.2) would demonstrate or implement: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes. This case instead tests Transparent data encryption at rest (2.2); the choice measures or changes another part of the system.

Question 233

An Azure database administrator observes: A project claims TDE prevents any DBA with SELECT privileges from seeing customer data. Which action best addresses the specific technical requirement?

  1. Configure Azure SQL or SQL Server auditing to collect relevant database events into appropriately restricted log destinations with retention controls.
  2. Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.
  3. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.
  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

B:

The reported Azure SQL or SQL Server condition is: A project claims TDE prevents any DBA with SELECT privileges from seeing customer data. 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:

SQL database auditing and audit storage (2.3) addresses another technical failure: Audit events written only to a disposable or broadly writable destination may be lost or tampered with. The case states: A project claims TDE prevents any DBA with SELECT privileges from seeing customer data. The most direct corrective action is: Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.

C:

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. This case instead tests Transparent data encryption at rest (2.2); the choice measures or changes another part of the system.

D:

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 required corrective action concerns Transparent data encryption at rest (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 234

In a database operations review, a team encounters: A project claims TDE prevents any DBA with SELECT privileges from seeing customer data. 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. TDE protects physical database files and backups at rest but does not by itself hide plaintext from authorized SQL queries.
  3. Audit events written only to a disposable or broadly writable destination may be lost or tampered with.
  4. Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely.

Explanation

Correct Answer

B:

The incident (A project claims TDE prevents any DBA with SELECT privileges from seeing customer data.) most directly exposes: TDE protects physical database files and backups at rest but does not by itself hide plaintext from authorized SQL queries. The resulting safe technical response is: Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management. Its verification is: 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) would demonstrate or implement: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. The case states: A project claims TDE prevents any DBA with SELECT privileges from seeing customer data. The most direct risk is: TDE protects physical database files and backups at rest but does not by itself hide plaintext from authorized SQL queries.

C:

SQL database auditing and audit storage (2.3) would demonstrate or implement: Audit events written only to a disposable or broadly writable destination may be lost or tampered with. This case instead tests Transparent data encryption at rest (2.2); the choice measures or changes another part of the system.

D:

Managed identity database access (2.1) would demonstrate or implement: Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely. The required risk concerns Transparent data encryption at rest (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 235

An Azure database administrator observes: A SQL Server VM must back up and safeguard its TDE certificate before restoring encrypted databases elsewhere. 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. Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.
  3. Configure Azure SQL or SQL Server auditing to collect relevant database events into appropriately restricted log destinations with retention controls.
  4. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.

Explanation

Correct Answer

B:

The reported Azure SQL or SQL Server condition is: A SQL Server VM must back up and safeguard its TDE certificate before restoring encrypted databases elsewhere. 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: A SQL Server VM must back up and safeguard its TDE certificate before restoring encrypted databases elsewhere. The most direct corrective action is: Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.

C:

SQL database auditing and audit storage (2.3) addresses another technical failure: Audit events written only to a disposable or broadly writable destination may be lost or tampered with. This case instead tests Transparent data encryption at rest (2.2); the choice measures or changes another part of the system.

D:

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 required corrective action concerns Transparent data encryption at rest (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 236

During post-change validation, the team reports: A SQL Server VM must back up and safeguard its TDE certificate before restoring encrypted databases elsewhere. Which observation best demonstrates that the appropriate correction worked?

  1. The workload obtains a supported short-lived token and accesses only allowed SQL objects with no reusable password in source.
  2. Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue.
  3. A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes.
  4. A controlled access or schema-change event appears in the approved audit store with expected principal and timestamp.

Explanation

Correct Answer

B:

The acceptance evidence for this incident (A SQL Server VM must back up and safeguard its TDE certificate before restoring encrypted databases elsewhere.) 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.

Incorrect Answers

A:

Managed identity database access (2.1) would demonstrate or implement: The workload obtains a supported short-lived token and accesses only allowed SQL objects with no reusable password in source. The case states: A SQL Server VM must back up and safeguard its TDE certificate before restoring encrypted databases elsewhere. The most direct evidence is: Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue.

C:

Customer-managed tde keys in azure key vault (2.2) would demonstrate or implement: A rotation rehearsal validates the supported key version and the SQL resource retains access after planned key changes. This case instead tests Transparent data encryption at rest (2.2); the choice measures or changes another part of the system.

D:

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. The required evidence concerns Transparent data encryption at rest (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 237

An Azure database administrator observes: A security audit needs evidence that the Azure SQL database's at-rest encryption is active. 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 a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.
  3. Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.
  4. Configure Azure SQL or SQL Server auditing to collect relevant database events into appropriately restricted log destinations with retention controls.

Explanation

Correct Answer

C:

The reported Azure SQL or SQL Server condition is: A security audit needs evidence that the Azure SQL database's at-rest encryption is active. 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: A security audit needs evidence that the Azure SQL database's at-rest encryption is active. The most direct corrective action is: Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.

B:

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. This choice can be useful for that problem, but it does not establish the Transparent data encryption at rest (2.2) control being assessed here.

D:

SQL database auditing and audit storage (2.3) addresses another technical failure: Audit events written only to a disposable or broadly writable destination may be lost or tampered with. The required corrective action concerns Transparent data encryption at rest (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 238

In a database operations review, a team encounters: A security audit needs evidence that the Azure SQL database's at-rest encryption is active. 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. Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely.
  3. Audit events written only to a disposable or broadly writable destination may be lost or tampered with.
  4. TDE protects physical database files and backups at rest but does not by itself hide plaintext from authorized SQL queries.

Explanation

Correct Answer

D:

The incident (A security audit needs evidence that the Azure SQL database's at-rest encryption is active.) most directly exposes: TDE protects physical database files and backups at rest but does not by itself hide plaintext from authorized SQL queries. The resulting safe technical response is: Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management. Its verification is: 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) would demonstrate or implement: Key deletion or disabled access can render encrypted databases unavailable despite healthy compute and storage. The case states: A security audit needs evidence that the Azure SQL database's at-rest encryption is active. The most direct risk is: TDE protects physical database files and backups at rest but does not by itself hide plaintext from authorized SQL queries.

B:

Managed identity database access (2.1) would demonstrate or implement: Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely. This choice can be useful for that problem, but it does not establish the Transparent data encryption at rest (2.2) control being assessed here.

C:

SQL database auditing and audit storage (2.3) would demonstrate or implement: Audit events written only to a disposable or broadly writable destination may be lost or tampered with. This case instead tests Transparent data encryption at rest (2.2); the choice measures or changes another part of the system.

Question 239

An Azure database administrator observes: A database owner confuses TDE with encryption of the client network connection. 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 a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.
  3. Configure Azure SQL or SQL Server auditing to collect relevant database events into appropriately restricted log destinations with retention controls.
  4. Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.

Explanation

Correct Answer

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: A database owner confuses TDE with encryption of the client network connection. The most direct corrective action is: Enable and validate supported transparent data encryption for Azure SQL or SQL Server databases with appropriate key management.

B:

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. This choice can be useful for that problem, but it does not establish the Transparent data encryption at rest (2.2) control being assessed here.

C:

SQL database auditing and audit storage (2.3) addresses another technical failure: Audit events written only to a disposable or broadly writable destination may be lost or tampered with. This case instead tests Transparent data encryption at rest (2.2); the choice measures or changes another part of the system.

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.