Practice Exams:

Microsoft DP-900 Dumps

EXAM: Microsoft Azure Data Fundamentals
Verified By Experts
Premium Bundle
$40.00
$59.97 $99.97

DP-900 Premium Bundle


  • Premium File 332 Questions & Answers
  • Training Course 32 Lectures
  • Study Guide 672 Pages

Microsoft DP-900 Practice Test 51

Question 500

At Meadowbank Health only an approved application subnet should query a managed SQL database. Which shortcut most directly threatens the intended data outcome?

  1. Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism.
  2. Open database access to every public address while sharing a master login in a repository.
  3. Write email = NULL and assume the comparison identifies missing email values.
  4. Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment.

Answer & Explanations

Correct answer: B

A.

Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. This concerns another issue: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. In the stated case—At Meadowbank Health only an approved application subnet should query a managed SQL database—reject: Open database access to every public address while sharing a master login in a repository. The safer response is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

B.

Open database access to every public address while sharing a master login in a repository. The scenario is: At Meadowbank Health only an approved application subnet should query a managed SQL database. This undermines the mechanism: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. Instead: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

C.

Write email = NULL and assume the comparison identifies missing email values. This concerns another issue: At Willowport Health incomplete patient contact records need review. In the stated case—At Meadowbank Health only an approved application subnet should query a managed SQL database—reject: Open database access to every public address while sharing a master login in a repository. The safer response is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

D.

Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment. This concerns another issue: At Pinecrest Payments database failover should not charge a card twice. In the stated case—At Meadowbank Health only an approved application subnet should query a managed SQL database—reject: Open database access to every public address while sharing a master login in a repository. The safer response is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

Question 501

At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. Which design or Azure data approach best fits this requirement?

  1. Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
  2. Use ORDER BY for deterministic display of results rather than relying on physical row storage order.
  3. Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.
  4. Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

Answer & Explanations

Correct answer: D

A.

Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. This addresses a different situation: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The present case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. The relevant action here is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

B.

Use ORDER BY for deterministic display of results rather than relying on physical row storage order. This addresses a different situation: At Cedarbank Logistics dispatch lists must show oldest outstanding shipments first. The present case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. The relevant action here is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

C.

Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. This addresses a different situation: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The present case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. The relevant action here is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

D.

Validate network access rules and Microsoft Entra authentication for Azure SQL connections. This works because: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. The scenario is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. Verify the outcome by: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

Question 502

At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. The team proposes this approach: Validate network access rules and Microsoft Entra authentication for Azure SQL connections. Which technical principle explains the choice?

  1. The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.
  2. Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.
  3. A view provides a defined query interface and can omit fields that consumers should not see.
  4. Engine family alone does not guarantee all self-managed plugins, versions or host customizations are supported by the managed offering.

Answer & Explanations

Correct answer: B

A.

The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. That explains a separate situation: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The current case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. The actual mechanism is: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.

B.

Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. This principle supports the intervention: Validate network access rules and Microsoft Entra authentication for Azure SQL connections. The relevant scenario is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. Verify the result by: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

C.

A view provides a defined query interface and can omit fields that consumers should not see. That explains a separate situation: At Cedarcrest Travel analysts need booking summaries without card tokens. The current case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. The actual mechanism is: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.

D.

Engine family alone does not guarantee all self-managed plugins, versions or host customizations are supported by the managed offering. That explains a separate situation: At Oakridge Data a PostgreSQL service relies on a specialized geographic extension. The current case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. The actual mechanism is: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.

Question 503

At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. After implementing this approach—Validate network access rules and Microsoft Entra authentication for Azure SQL connections—which result would most directly confirm success?

  1. Run a synthetic peak query mix and inspect resource metrics before and after a justified tier change.
  2. Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
  3. Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.
  4. Try a synthetic order with negative quantity and verify an enforced check rejects it.

Answer & Explanations

Correct answer: C

A.

Run a synthetic peak query mix and inspect resource metrics before and after a justified tier change. This tests a separate situation: At Bayfield Travel application requests slow under concurrent booking loads. The observed case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. Use this acceptance check instead: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

B.

Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior. This tests a separate situation: At Pineport Research an internal reporting database is idle most evenings. The observed case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. Use this acceptance check instead: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

C.

Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session. This tests the targeted action: Validate network access rules and Microsoft Entra authentication for Azure SQL connections. The reason is: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. The reported case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets.

D.

Try a synthetic order with negative quantity and verify an enforced check rejects it. This tests a separate situation: At Meadowline Manufacturing purchase quantities must be positive. The observed case is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. Use this acceptance check instead: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

Question 504

At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. Which shortcut most directly threatens the intended data outcome?

  1. Assume newly inserted records will always appear at the bottom of an un-ordered query.
  2. Open database access to every public address while sharing a master login in a repository.
  3. Increase storage capacity to solve a CPU-bound query plan without examining the bottleneck.
  4. Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment.

Answer & Explanations

Correct answer: B

A.

Assume newly inserted records will always appear at the bottom of an un-ordered query. This concerns another issue: At Cedarbank Logistics dispatch lists must show oldest outstanding shipments first. In the stated case—At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets—reject: Open database access to every public address while sharing a master login in a repository. The safer response is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

B.

Open database access to every public address while sharing a master login in a repository. The scenario is: At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets. This undermines the mechanism: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. Instead: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

C.

Increase storage capacity to solve a CPU-bound query plan without examining the bottleneck. This concerns another issue: At Bayfield Travel application requests slow under concurrent booking loads. In the stated case—At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets—reject: Open database access to every public address while sharing a master login in a repository. The safer response is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

D.

Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment. This concerns another issue: At Pinecrest Payments database failover should not charge a card twice. In the stated case—At Cedarport Commerce a cloud app needs identity-based SQL authentication without hardcoded secrets—reject: Open database access to every public address while sharing a master login in a repository. The safer response is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

Question 505

At Pinecrest Payments database failover should not charge a card twice. Which design or Azure data approach best fits this requirement?

  1. Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.
  2. Distinguish automatic service availability from application transaction retry and failover handling.
  3. Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.
  4. Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

Answer & Explanations

Correct answer: B

A.

Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. This addresses a different situation: At Meadowline Manufacturing purchase quantities must be positive. The present case is: At Pinecrest Payments database failover should not charge a card twice. The relevant action here is: Distinguish automatic service availability from application transaction retry and failover handling.

B.

Distinguish automatic service availability from application transaction retry and failover handling. This works because: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors. The scenario is: At Pinecrest Payments database failover should not charge a card twice. Verify the outcome by: Trigger a controlled connection interruption and verify the application retries idempotent operations safely.

C.

Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. This addresses a different situation: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The present case is: At Pinecrest Payments database failover should not charge a card twice. The relevant action here is: Distinguish automatic service availability from application transaction retry and failover handling.

D.

Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. This addresses a different situation: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The present case is: At Pinecrest Payments database failover should not charge a card twice. The relevant action here is: Distinguish automatic service availability from application transaction retry and failover handling.

Question 506

At Pinecrest Payments database failover should not charge a card twice. The team proposes this approach: Distinguish automatic service availability from application transaction retry and failover handling. Which technical principle explains the choice?

  1. Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.
  2. Hyperscale's storage and compute architecture targets large-scale SQL Database workloads with distinct storage scaling behavior.
  3. Engine family alone does not guarantee all self-managed plugins, versions or host customizations are supported by the managed offering.
  4. WHERE filters individual rows before projection into the result set.

Answer & Explanations

Correct answer: A

A.

Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors. This principle supports the intervention: Distinguish automatic service availability from application transaction retry and failover handling. The relevant scenario is: At Pinecrest Payments database failover should not charge a card twice. Verify the result by: Trigger a controlled connection interruption and verify the application retries idempotent operations safely.

B.

Hyperscale's storage and compute architecture targets large-scale SQL Database workloads with distinct storage scaling behavior. That explains a separate situation: At Harborcrest Finance a long-lived transaction archive has rapid table growth. The current case is: At Pinecrest Payments database failover should not charge a card twice. The actual mechanism is: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.

C.

Engine family alone does not guarantee all self-managed plugins, versions or host customizations are supported by the managed offering. That explains a separate situation: At Oakridge Data a PostgreSQL service relies on a specialized geographic extension. The current case is: At Pinecrest Payments database failover should not charge a card twice. The actual mechanism is: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.

D.

WHERE filters individual rows before projection into the result set. That explains a separate situation: At Pineport Commerce support needs orders placed on one business day. The current case is: At Pinecrest Payments database failover should not charge a card twice. The actual mechanism is: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.

Question 507

At Pinecrest Payments database failover should not charge a card twice. After implementing this approach—Distinguish automatic service availability from application transaction retry and failover handling—which result would most directly confirm success?

  1. Update a fictional city postal reference once and verify all related customer records use the approved value.
  2. Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS.
  3. Trigger a controlled connection interruption and verify the application retries idempotent operations safely.
  4. Restore a synthetic database to a timestamp before an accidental test delete.

Answer & Explanations

Correct answer: C

A.

Update a fictional city postal reference once and verify all related customer records use the approved value. This tests a separate situation: At Harborcrest Tax a postal region's standard reference data changes annually. The observed case is: At Pinecrest Payments database failover should not charge a card twice. Use this acceptance check instead: Trigger a controlled connection interruption and verify the application retries idempotent operations safely.

B.

Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS. This tests a separate situation: At Harborcrest Apps a new order service needs managed T-SQL storage. The observed case is: At Pinecrest Payments database failover should not charge a card twice. Use this acceptance check instead: Trigger a controlled connection interruption and verify the application retries idempotent operations safely.

C.

Trigger a controlled connection interruption and verify the application retries idempotent operations safely. This tests the targeted action: Distinguish automatic service availability from application transaction retry and failover handling. The reason is: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors. The reported case is: At Pinecrest Payments database failover should not charge a card twice.

D.

Restore a synthetic database to a timestamp before an accidental test delete. This tests a separate situation: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. The observed case is: At Pinecrest Payments database failover should not charge a card twice. Use this acceptance check instead: Trigger a controlled connection interruption and verify the application retries idempotent operations safely.

Question 508

At Pinecrest Payments database failover should not charge a card twice. Which shortcut most directly threatens the intended data outcome?

  1. Export every order and assume the spreadsheet viewer will enforce the date restriction.
  2. Increase storage capacity to solve a CPU-bound query plan without examining the bottleneck.
  3. Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment.
  4. Assume a continuously saturated production database will pause and deliver large idle savings.

Answer & Explanations

Correct answer: C

A.

Export every order and assume the spreadsheet viewer will enforce the date restriction. This concerns another issue: At Pineport Commerce support needs orders placed on one business day. In the stated case—At Pinecrest Payments database failover should not charge a card twice—reject: Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment. The safer response is: Distinguish automatic service availability from application transaction retry and failover handling.

B.

Increase storage capacity to solve a CPU-bound query plan without examining the bottleneck. This concerns another issue: At Bayfield Travel application requests slow under concurrent booking loads. In the stated case—At Pinecrest Payments database failover should not charge a card twice—reject: Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment. The safer response is: Distinguish automatic service availability from application transaction retry and failover handling.

C.

Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment. The scenario is: At Pinecrest Payments database failover should not charge a card twice. This undermines the mechanism: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors. Instead: Distinguish automatic service availability from application transaction retry and failover handling.

D.

Assume a continuously saturated production database will pause and deliver large idle savings. This concerns another issue: At Pineport Research an internal reporting database is idle most evenings. In the stated case—At Pinecrest Payments database failover should not charge a card twice—reject: Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment. The safer response is: Distinguish automatic service availability from application transaction retry and failover handling.

Question 509

At Harborland Logistics a managed SQL service briefly reconnects during maintenance. Which design or Azure data approach best fits this requirement?

  1. Distinguish automatic service availability from application transaction retry and failover handling.
  2. Apply first-normal-form principles by placing repeatable phone numbers in a separate related table.
  3. Scale Azure SQL compute based on observed CPU, IO, concurrent sessions and service-tier constraints.
  4. Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration.

Answer & Explanations

Correct answer: A

A.

Distinguish automatic service availability from application transaction retry and failover handling. This works because: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors. The scenario is: At Harborland Logistics a managed SQL service briefly reconnects during maintenance. Verify the outcome by: Trigger a controlled connection interruption and verify the application retries idempotent operations safely.

B.

Apply first-normal-form principles by placing repeatable phone numbers in a separate related table. This addresses a different situation: At Meadowport Services customers often provide multiple contact phones. The present case is: At Harborland Logistics a managed SQL service briefly reconnects during maintenance. The relevant action here is: Distinguish automatic service availability from application transaction retry and failover handling.

C.

Scale Azure SQL compute based on observed CPU, IO, concurrent sessions and service-tier constraints. This addresses a different situation: At Bayfield Travel application requests slow under concurrent booking loads. The present case is: At Harborland Logistics a managed SQL service briefly reconnects during maintenance. The relevant action here is: Distinguish automatic service availability from application transaction retry and failover handling.

D.

Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration. This addresses a different situation: At Harborcrest Apps a new order service needs managed T-SQL storage. The present case is: At Harborland Logistics a managed SQL service briefly reconnects during maintenance. The relevant action here is: Distinguish automatic service availability from application transaction retry and failover handling.

Question 510

At Harborland Logistics a managed SQL service briefly reconnects during maintenance. The team proposes this approach: Distinguish automatic service availability from application transaction retry and failover handling. Which technical principle explains the choice?

  1. The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.
  2. Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.
  3. The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.
  4. SQL result ordering is not guaranteed without an explicit sort clause.

Answer & Explanations

Correct answer: B

A.

The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. That explains a separate situation: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The current case is: At Harborland Logistics a managed SQL service briefly reconnects during maintenance. The actual mechanism is: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.

B.

Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors. This principle supports the intervention: Distinguish automatic service availability from application transaction retry and failover handling. The relevant scenario is: At Harborland Logistics a managed SQL service briefly reconnects during maintenance. Verify the result by: Trigger a controlled connection interruption and verify the application retries idempotent operations safely.

C.

The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM. That explains a separate situation: At Meadowline Commerce a storefront relies on an existing MySQL schema. The current case is: At Harborland Logistics a managed SQL service briefly reconnects during maintenance. The actual mechanism is: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.

D.

SQL result ordering is not guaranteed without an explicit sort clause. That explains a separate situation: At Cedarbank Logistics dispatch lists must show oldest outstanding shipments first. The current case is: At Harborland Logistics a managed SQL service briefly reconnects during maintenance. The actual mechanism is: Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests