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 17

Question 160

An Azure SQL operations team investigates: A project marks the cloud migration complete before testing row counts, schema objects and connectivity. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Assess existing SQL Server dependencies, compatibility and workload utilization before selecting Azure SQL Database, Managed Instance or Azure VM.
  2. The application passes functional acceptance on the chosen VM while OS patching, storage and backup responsibilities are explicitly assigned.
  3. Post-migration row and schema checks, integrity checks, and application tests pass before source retirement.
  4. Select Azure SQL Database for a managed single-database PaaS application that does not depend on instance-level SQL Server features.
  5. Use a supported offline database migration or backup-and-restore workflow when a planned write outage is acceptable and validate target compatibility.

Explanation

Correct Answers

C:

The acceptance evidence for this incident (A project marks the cloud migration complete before testing row counts, schema objects and connectivity.) is: Post-migration row and schema checks, integrity checks, and application tests pass before source retirement. It directly tests whether the remediation (Use a supported offline database migration or backup-and-restore workflow when a planned write outage is acceptable and validate target compatibility.) solves the specified issue, instead of proving an unrelated database control works.

E:

The reported Azure SQL or SQL Server condition is: A project marks the cloud migration complete before testing row counts, schema objects and connectivity. The specific supported administrative response is: Use a supported offline database migration or backup-and-restore workflow when a planned write outage is acceptable and validate target compatibility. The technical risk is: Restoring from a single old backup without stopping writes or validation can lose committed changes. Confirm the correction with: Post-migration row and schema checks, integrity checks, and application tests pass before source retirement.

Incorrect Answers

A:

Azure SQL migration readiness assessment (1.3) addresses another technical failure: Choosing a target from server size alone can miss unsupported features and production performance needs. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: Post-migration row and schema checks, integrity checks, and application tests pass before source retirement.

B:

SQL server on azure virtual machines (1.1) would demonstrate or implement: The application passes functional acceptance on the chosen VM while OS patching, storage and backup responsibilities are explicitly assigned. This choice can be useful for that problem, but it does not establish the Offline migration and validated cutover (1.3) control being assessed here.

D:

Azure SQL database platform fit (1.1) addresses another technical failure: Moving an application with unsupported instance dependencies to a logical database can break its procedures or operations. The required paired action and test concerns Offline migration and validated cutover (1.3); a passing result for this alternative could leave that requirement unresolved.

Question 161

An Azure database administrator observes: An Azure SQL logical server is provisioned but the operations group cannot configure Entra authentication. Which action best addresses the specific technical requirement?

  1. Implement row-level security using supported predicate functions and security policies tied to verified tenant or user context.
  2. Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.
  3. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  4. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: An Azure SQL logical server is provisioned but the operations group cannot configure Entra authentication. The specific supported administrative response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. The technical risk is: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. Confirm the correction with: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

Incorrect Answers

A:

Row-level security with session predicates (2.3) addresses another technical failure: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. The case states: An Azure SQL logical server is provisioned but the operations group cannot configure Entra authentication. The most direct corrective action is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.

B:

Diagnosing login and token failures (2.1) addresses another technical failure: Treating every database error as a firewall block can conceal authentication and access-control faults. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.

C:

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 case instead tests Microsoft entra administrator for azure SQL (2.1); the choice measures or changes another part of the system.

Question 162

During post-change validation, the team reports: An Azure SQL logical server is provisioned but the operations group cannot configure Entra authentication. Which observation best demonstrates that the appropriate correction worked?

  1. An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.
  2. Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage.
  3. Cross-tenant test queries are filtered at the SQL engine, while each approved tenant sees its own records.
  4. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Explanation

Correct Answer

A:

The acceptance evidence for this incident (An Azure SQL logical server is provisioned but the operations group cannot configure Entra authentication.) is: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password. It directly tests whether the remediation (Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

B:

Diagnosing login and token failures (2.1) would demonstrate or implement: Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.

C:

Row-level security with session predicates (2.3) would demonstrate or implement: Cross-tenant test queries are filtered at the SQL engine, while each approved tenant sees its own records. This case instead tests Microsoft entra administrator for azure SQL (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 evidence concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 163

An Azure database administrator observes: A new Azure SQL Managed Instance needs the correct tenant administrator before directory users can connect. Which action best addresses the specific technical requirement?

  1. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  2. Implement row-level security using supported predicate functions and security policies tied to verified tenant or user context.
  3. Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.
  4. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A new Azure SQL Managed Instance needs the correct tenant administrator before directory users can connect. The specific supported administrative response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. The technical risk is: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. Confirm the correction with: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

Incorrect Answers

B:

Row-level security with session predicates (2.3) addresses another technical failure: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.

C:

Diagnosing login and token failures (2.1) addresses another technical failure: Treating every database error as a firewall block can conceal authentication and access-control faults. This case instead tests Microsoft entra administrator for azure SQL (2.1); the choice measures or changes another part of the system.

D:

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. The required corrective action concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 164

In a database operations review, a team encounters: A new Azure SQL Managed Instance needs the correct tenant administrator before directory users can connect. Which failure or exposure is most directly relevant?

  1. Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access.
  2. Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools.
  3. Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation.
  4. Treating every database error as a firewall block can conceal authentication and access-control faults.

Explanation

Correct Answer

A:

The incident (A new Azure SQL Managed Instance needs the correct tenant administrator before directory users can connect.) most directly exposes: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. The resulting safe technical response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. Its verification is: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

Incorrect Answers

B:

Row-level security with session predicates (2.3) would demonstrate or implement: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.

C:

SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This case instead tests Microsoft entra administrator for azure SQL (2.1); the choice measures or changes another part of the system.

D:

Diagnosing login and token failures (2.1) would demonstrate or implement: Treating every database error as a firewall block can conceal authentication and access-control faults. The required risk concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 165

An Azure database administrator observes: A developer supplies an Entra token but the SQL deployment has no configured directory admin. Which action best addresses the specific technical requirement?

  1. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  2. Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.
  3. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  4. Implement row-level security using supported predicate functions and security policies tied to verified tenant or user context.

Explanation

Correct Answer

C:

The reported Azure SQL or SQL Server condition is: A developer supplies an Entra token but the SQL deployment has no configured directory admin. The specific supported administrative response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. The technical risk is: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. Confirm the correction with: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

Incorrect Answers

A:

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. The case states: A developer supplies an Entra token but the SQL deployment has no configured directory admin. The most direct corrective action is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.

B:

Diagnosing login and token failures (2.1) addresses another technical failure: Treating every database error as a firewall block can conceal authentication and access-control faults. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.

D:

Row-level security with session predicates (2.3) addresses another technical failure: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. The required corrective action concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 166

During post-change validation, the team reports: A developer supplies an Entra token but the SQL deployment has no configured directory admin. Which observation best demonstrates that the appropriate correction worked?

  1. Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage.
  2. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.
  3. An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.
  4. Cross-tenant test queries are filtered at the SQL engine, while each approved tenant sees its own records.

Explanation

Correct Answer

C:

The acceptance evidence for this incident (A developer supplies an Entra token but the SQL deployment has no configured directory admin.) is: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password. It directly tests whether the remediation (Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Diagnosing login and token failures (2.1) would demonstrate or implement: Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage. The case states: A developer supplies an Entra token but the SQL deployment has no configured directory admin. The most direct evidence is: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

B:

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. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.

D:

Row-level security with session predicates (2.3) would demonstrate or implement: Cross-tenant test queries are filtered at the SQL engine, while each approved tenant sees its own records. The required evidence concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 167

An Azure database administrator observes: An organization wants to use directory-backed SQL identities instead of issuing a common SQL administrator password. Which action best addresses the specific technical requirement?

  1. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  2. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  3. Implement row-level security using supported predicate functions and security policies tied to verified tenant or user context.
  4. Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: An organization wants to use directory-backed SQL identities instead of issuing a common SQL administrator password. The specific supported administrative response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. The technical risk is: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. Confirm the correction with: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

Incorrect Answers

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 Microsoft entra administrator for azure SQL (2.1) control being assessed here.

C:

Row-level security with session predicates (2.3) addresses another technical failure: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. This case instead tests Microsoft entra administrator for azure SQL (2.1); the choice measures or changes another part of the system.

D:

Diagnosing login and token failures (2.1) addresses another technical failure: Treating every database error as a firewall block can conceal authentication and access-control faults. The required corrective action concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 168

In a database operations review, a team encounters: An organization wants to use directory-backed SQL identities instead of issuing a common SQL administrator password. Which failure or exposure is most directly relevant?

  1. Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access.
  2. Treating every database error as a firewall block can conceal authentication and access-control faults.
  3. Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation.
  4. Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools.

Explanation

Correct Answer

A:

The incident (An organization wants to use directory-backed SQL identities instead of issuing a common SQL administrator password.) most directly exposes: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. The resulting safe technical response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. Its verification is: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

Incorrect Answers

B:

Diagnosing login and token failures (2.1) would demonstrate or implement: Treating every database error as a firewall block can conceal authentication and access-control faults. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.

C:

SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: Unvalidated or unencrypted database transport can expose credentials or data to interception and server impersonation. This case instead tests Microsoft entra administrator for azure SQL (2.1); the choice measures or changes another part of the system.

D:

Row-level security with session predicates (2.3) would demonstrate or implement: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. The required risk concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 169

An Azure database administrator observes: A database team must review which directory account has authority to create Azure SQL Entra users. Which action best addresses the specific technical requirement?

  1. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  2. Require supported TLS encryption, valid certificates and client hostname validation for database network connections.
  3. Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.
  4. Implement row-level security using supported predicate functions and security policies tied to verified tenant or user context.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A database team must review which directory account has authority to create Azure SQL Entra users. The specific supported administrative response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. The technical risk is: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. Confirm the correction with: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

Incorrect Answers

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 Microsoft entra administrator for azure SQL (2.1) control being assessed here.

C:

Diagnosing login and token failures (2.1) addresses another technical failure: Treating every database error as a firewall block can conceal authentication and access-control faults. This case instead tests Microsoft entra administrator for azure SQL (2.1); the choice measures or changes another part of the system.

D:

Row-level security with session predicates (2.3) addresses another technical failure: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. The required corrective action concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

Question 170

An Azure SQL operations team investigates: A database team must review which directory account has authority to create Azure SQL Entra users. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.
  2. Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.
  3. An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.
  4. Implement row-level security using supported predicate functions and security policies tied to verified tenant or user context.
  5. An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test.

Explanation

Correct Answers

A:

The reported Azure SQL or SQL Server condition is: A database team must review which directory account has authority to create Azure SQL Entra users. The specific supported administrative response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. The technical risk is: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. Confirm the correction with: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.

C:

The acceptance evidence for this incident (A database team must review which directory account has authority to create Azure SQL Entra users.) is: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password. It directly tests whether the remediation (Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

B:

Diagnosing login and token failures (2.1) addresses another technical failure: Treating every database error as a firewall block can conceal authentication and access-control faults. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.

D:

Row-level security with session predicates (2.3) addresses another technical failure: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. The required paired action and test concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.

E:

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 paired-answer requirement concerns Microsoft entra administrator for azure SQL (2.1); this alternative does not provide the matching intervention and separate acceptance evidence.