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 28

Question 270

An Azure SQL operations team investigates: A database team enables encrypted columns but fails to validate whether its planned query functions are supported. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. The signed-in user can perform the assigned database operations and is denied unrelated schema or data actions.
  2. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  3. Supported comparison or indexing operations succeed through the enclave-enabled client and unauthorized plaintext access remains blocked.
  4. Evaluate Always Encrypted with secure enclaves for supported encrypted-column operations that require enclave-supported computations and key configuration.
  5. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.

Explanation

Correct Answers

C:

The acceptance evidence for this incident (A database team enables encrypted columns but fails to validate whether its planned query functions are supported.) is: Supported comparison or indexing operations succeed through the enclave-enabled client and unauthorized plaintext access remains blocked. It directly tests whether the remediation (Evaluate Always Encrypted with secure enclaves for supported encrypted-column operations that require enclave-supported computations and key configuration.) solves the specified issue, instead of proving an unrelated database control works.

D:

The reported Azure SQL or SQL Server condition is: A database team enables encrypted columns but fails to validate whether its planned query functions are supported. The specific supported administrative response is: Evaluate Always Encrypted with secure enclaves for supported encrypted-column operations that require enclave-supported computations and key configuration. The technical risk is: Assuming all encrypted-column operations work without enclave support can cause unsupported queries or unexpected decryption behavior. Confirm the correction with: Supported comparison or indexing operations succeed through the enclave-enabled client and unauthorized plaintext access remains blocked.

Incorrect Answers

A:

Contained database users from entra identities (2.1) would demonstrate or implement: The signed-in user can perform the assigned database operations and is denied unrelated schema or data actions. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: Supported comparison or indexing operations succeed through the enclave-enabled client and unauthorized plaintext access remains blocked.

B:

SQL encrypted connections and TLS verification (2.2) addresses another technical failure: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This choice can be useful for that problem, but it does not establish the Always encrypted secure enclave workloads (2.2) control being assessed here.

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 Always encrypted secure enclave workloads (2.2); this alternative does not provide the matching intervention and separate acceptance evidence.

Question 271

An Azure database administrator observes: An application disables SQL server certificate verification to make a certificate warning disappear. Which action best addresses the specific technical requirement?

  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 supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  3. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.
  4. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: An application disables SQL server certificate verification to make a certificate warning disappear. The specific supported administrative response is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections. The technical risk is: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. Confirm the correction with: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

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: An application disables SQL server certificate verification to make a certificate warning disappear. The most direct corrective action is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections.

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 SQL encrypted connections and TLS verification (2.2) control being assessed here.

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 SQL encrypted connections and TLS verification (2.2); the choice measures or changes another part of the system.

Question 272

During post-change validation, the team reports: An application disables SQL server certificate verification to make a certificate warning disappear. Which observation best demonstrates that the appropriate correction worked?

  1. Authorized privileged users see expected values and restricted users receive masked output under tested permissions.
  2. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.
  3. Approved source clients can connect through expected network paths and unauthorized test addresses are rejected.
  4. The workload obtains a supported short-lived token and accesses only allowed SQL objects with no reusable password in source.

Explanation

Correct Answer

B:

The acceptance evidence for this incident (An application disables SQL server certificate verification to make a certificate warning disappear.) is: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. It directly tests whether the remediation (Require supported TLS encryption, valid certificates and client hostname validation for database network connections.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

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 case states: An application disables SQL server certificate verification to make a certificate warning disappear. The most direct evidence is: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

C:

Azure SQL firewall rule scoping (2.2) would demonstrate or implement: Approved source clients can connect through expected network paths and unauthorized test addresses are rejected. This case instead tests SQL encrypted connections and TLS verification (2.2); the choice measures or changes another part of the system.

D:

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 required evidence concerns SQL encrypted connections and TLS verification (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 273

An Azure database administrator observes: A SQL connection string explicitly allows plaintext traffic over an untrusted hybrid network. Which action best addresses the specific technical requirement?

  1. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  2. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.
  3. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  4. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A SQL connection string explicitly allows plaintext traffic over an untrusted hybrid network. The specific supported administrative response is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections. The technical risk is: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. Confirm the correction with: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Incorrect Answers

B:

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. This choice can be useful for that problem, but it does not establish the SQL encrypted connections and TLS verification (2.2) control being assessed here.

C:

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 case instead tests SQL encrypted connections and TLS verification (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 SQL encrypted connections and TLS verification (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 274

In a database operations review, a team encounters: A SQL connection string explicitly allows plaintext traffic over an untrusted hybrid network. Which failure or exposure is most directly relevant?

  1. Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely.
  2. Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data.
  3. Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation.
  4. Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily.

Explanation

Correct Answer

C:

The incident (A SQL connection string explicitly allows plaintext traffic over an untrusted hybrid network.) most directly exposes: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. The resulting safe technical response is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections. Its verification is: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Incorrect Answers

A:

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 case states: A SQL connection string explicitly allows plaintext traffic over an untrusted hybrid network. The most direct risk is: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation.

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 SQL encrypted connections and TLS verification (2.2) control being assessed here.

D:

Azure SQL firewall rule scoping (2.2) would demonstrate or implement: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The required risk concerns SQL encrypted connections and TLS verification (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 275

An Azure database administrator observes: A DBA rotates a database listener certificate and client hostname checks begin failing. Which action best addresses the specific technical requirement?

  1. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.
  2. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.
  3. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  4. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: A DBA rotates a database listener certificate and client hostname checks begin failing. The specific supported administrative response is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections. The technical risk is: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. Confirm the correction with: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Incorrect Answers

A:

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 case states: A DBA rotates a database listener certificate and client hostname checks begin failing. The most direct corrective action is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections.

B:

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. This choice can be useful for that problem, but it does not establish the SQL encrypted connections and TLS verification (2.2) control being assessed here.

C:

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 case instead tests SQL encrypted connections and TLS verification (2.2); the choice measures or changes another part of the system.

Question 276

During post-change validation, the team reports: A DBA rotates a database listener certificate and client hostname checks begin failing. 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. Authorized privileged users see expected values and restricted users receive masked output under tested permissions.
  3. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.
  4. Approved source clients can connect through expected network paths and unauthorized test addresses are rejected.

Explanation

Correct Answer

C:

The acceptance evidence for this incident (A DBA rotates a database listener certificate and client hostname checks begin failing.) is: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. It directly tests whether the remediation (Require supported TLS encryption, valid certificates and client hostname validation for database network connections.) 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 DBA rotates a database listener certificate and client hostname checks begin failing. The most direct evidence is: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

B:

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 choice can be useful for that problem, but it does not establish the SQL encrypted connections and TLS verification (2.2) control being assessed here.

D:

Azure SQL firewall rule scoping (2.2) would demonstrate or implement: Approved source clients can connect through expected network paths and unauthorized test addresses are rejected. The required evidence concerns SQL encrypted connections and TLS verification (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 277

An Azure database administrator observes: A security review finds the database uses a supported encrypted connection but accepts any presented certificate. Which action best addresses the specific technical requirement?

  1. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  2. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.
  3. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  4. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A security review finds the database uses a supported encrypted connection but accepts any presented certificate. The specific supported administrative response is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections. The technical risk is: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. Confirm the correction with: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Incorrect Answers

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 SQL encrypted connections and TLS verification (2.2) control being assessed here.

C:

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 case instead tests SQL encrypted connections and TLS verification (2.2); the choice measures or changes another part of the system.

D:

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 required corrective action concerns SQL encrypted connections and TLS verification (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 278

In a database operations review, a team encounters: A security review finds the database uses a supported encrypted connection but accepts any presented certificate. Which failure or exposure is most directly relevant?

  1. Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily.
  2. Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation.
  3. Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely.
  4. Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data.

Explanation

Correct Answer

B:

The incident (A security review finds the database uses a supported encrypted connection but accepts any presented certificate.) most directly exposes: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. The resulting safe technical response is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections. Its verification is: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Incorrect Answers

A:

Azure SQL firewall rule scoping (2.2) would demonstrate or implement: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The case states: A security review finds the database uses a supported encrypted connection but accepts any presented certificate. The most direct risk is: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation.

C:

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 case instead tests SQL encrypted connections and TLS verification (2.2); the choice measures or changes another part of the system.

D:

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 required risk concerns SQL encrypted connections and TLS verification (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 279

An Azure database administrator observes: A client requires a trusted transport session while private network routing remains separately configured. Which action best addresses the specific technical requirement?

  1. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  2. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.
  3. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  4. Use a supported managed identity or Entra-based service principal for application authentication to Azure SQL with database-level permissions.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A client requires a trusted transport session while private network routing remains separately configured. The specific supported administrative response is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections. The technical risk is: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. Confirm the correction with: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Incorrect Answers

B:

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. This choice can be useful for that problem, but it does not establish the SQL encrypted connections and TLS verification (2.2) control being assessed here.

C:

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 case instead tests SQL encrypted connections and TLS verification (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 SQL encrypted connections and TLS verification (2.2); a passing result for this alternative could leave that requirement unresolved.

Question 280

An Azure SQL operations team investigates: A client requires a trusted transport session while private network routing remains separately configured. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.
  2. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  3. The workload obtains a supported short-lived token and accesses only allowed SQL objects with no reusable password in source.
  4. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.
  5. Apply Azure SQL server-level or database-level firewall controls with least-privilege source ranges and verify interaction with network access policy.

Explanation

Correct Answers

B:

The reported Azure SQL or SQL Server condition is: A client requires a trusted transport session while private network routing remains separately configured. The specific supported administrative response is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections. The technical risk is: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. Confirm the correction with: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

D:

The acceptance evidence for this incident (A client requires a trusted transport session while private network routing remains separately configured.) is: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. It directly tests whether the remediation (Require supported TLS encryption, valid certificates and client hostname validation for database network connections.) solves the specified issue, instead of proving an unrelated database control works.

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 client requires a trusted transport session while private network routing remains separately configured. The most direct paired action and test is: Require supported TLS encryption, valid certificates and client hostname validation for database network connections.

C:

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. This case instead tests SQL encrypted connections and TLS verification (2.2); the choice measures or changes another part of the system.

E:

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 paired-answer requirement concerns SQL encrypted connections and TLS verification (2.2); this alternative does not provide the matching intervention and separate acceptance evidence.