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 45

Question 440

At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. Which shortcut most directly threatens the intended data outcome?

  1. Assume every self-hosted PostgreSQL extension can be installed with root OS access in a managed database.
  2. Give every low-usage tenant its own permanently oversized dedicated compute tier.
  3. Assume newly inserted records will always appear at the bottom of an un-ordered query.
  4. Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database.

Answer & Explanations

Correct answer: D

A.

Assume every self-hosted PostgreSQL extension can be installed with root OS access in a managed database. This concerns another issue: At Oakridge Data a PostgreSQL service relies on a specialized geographic extension. In the stated case—At Oakridge Insurance administrators migrate several related databases with instance-level dependencies—reject: Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database. The safer response is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

B.

Give every low-usage tenant its own permanently oversized dedicated compute tier. This concerns another issue: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. In the stated case—At Oakridge Insurance administrators migrate several related databases with instance-level dependencies—reject: Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database. The safer response is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

C.

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 Oakridge Insurance administrators migrate several related databases with instance-level dependencies—reject: Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database. The safer response is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

D.

Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database. The scenario is: At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. The likely failure is: Migration fails where instance-level requirements are unsupported. Instead: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

Question 441

At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. Which design or Azure data approach best fits this requirement?

  1. Treat SQL NULL as unknown or missing and use IS NULL instead of equality comparison when filtering it.
  2. Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.
  3. Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.
  4. Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

Answer & Explanations

Correct answer: B

A.

Treat SQL NULL as unknown or missing and use IS NULL instead of equality comparison when filtering it. This addresses a different situation: At Willowport Health incomplete patient contact records need review. The present case is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The relevant action here is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

B.

Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. This works because: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. The scenario is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. Verify the outcome by: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

C.

Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL. This addresses a different situation: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The present case is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The relevant action here is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

D.

Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine. This addresses a different situation: At Meadowline Commerce a storefront relies on an existing MySQL schema. The present case is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The relevant action here is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

Question 442

At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The team proposes this approach: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. Which technical principle explains the choice?

  1. Serverless can scale compute according to activity and support auto-pause where configured and supported.
  2. Engine family alone does not guarantee all self-managed plugins, versions or host customizations are supported by the managed offering.
  3. A relational join links rows through corresponding key values and inner joins retain matches only.
  4. The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.

Answer & Explanations

Correct answer: D

A.

Serverless can scale compute according to activity and support auto-pause where configured and supported. That explains a separate situation: At Pineport Research an internal reporting database is idle most evenings. The current case is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The actual mechanism is: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.

B.

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 Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The actual mechanism is: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.

C.

A relational join links rows through corresponding key values and inner joins retain matches only. That explains a separate situation: At Cedarcrest Finance invoices must display the correct customer account. The current case is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The actual mechanism is: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.

D.

The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. This principle supports the intervention: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. The relevant scenario is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. Verify the result by: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

Question 443

At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. After implementing this approach—Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential—which result would most directly confirm success?

  1. Import a small MySQL test schema and verify client driver and query behavior.
  2. Verify a test operator can administer the VM guest and supported SQL configuration required by the application.
  3. Compare a representative query plan and response after adding a test index.
  4. Run a synthetic peak query mix and inspect resource metrics before and after a justified tier change.

Answer & Explanations

Correct answer: B

A.

Import a small MySQL test schema and verify client driver and query behavior. This tests a separate situation: At Meadowline Commerce a storefront relies on an existing MySQL schema. The observed case is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. Use this acceptance check instead: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

B.

Verify a test operator can administer the VM guest and supported SQL configuration required by the application. This tests the targeted action: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. The reason is: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. The reported case is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension.

C.

Compare a representative query plan and response after adding a test index. This tests a separate situation: At Silverfield Commerce searching orders by customer ID becomes slow. The observed case is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. Use this acceptance check instead: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

D.

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 Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. Use this acceptance check instead: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

Question 444

At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. Which shortcut most directly threatens the intended data outcome?

  1. Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable.
  2. Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism.
  3. Execute UPDATE without a WHERE condition on a large production status table.
  4. Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service.

Answer & Explanations

Correct answer: D

A.

Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. This concerns another issue: At Meadowline Commerce a storefront relies on an existing MySQL schema. In the stated case—At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension—reject: Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. The safer response is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

B.

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 Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension—reject: Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. The safer response is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

C.

Execute UPDATE without a WHERE condition on a large production status table. This concerns another issue: At Harborpoint Deliveries only one tracking record needs a status correction. In the stated case—At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension—reject: Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. The safer response is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

D.

Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. The scenario is: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The likely failure is: Required low-level configuration cannot be implemented there. Instead: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

Question 445

At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. Which design or Azure data approach best fits this requirement?

  1. Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.
  2. Distinguish automatic service availability from application transaction retry and failover handling.
  3. Create an index on frequently filtered columns when measured query patterns justify it.
  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.

Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. This works because: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. The scenario is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. Verify the outcome by: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

B.

Distinguish automatic service availability from application transaction retry and failover handling. This addresses a different situation: At Pinecrest Payments database failover should not charge a card twice. The present case is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. The relevant action here is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

C.

Create an index on frequently filtered columns when measured query patterns justify it. This addresses a different situation: At Silverfield Commerce searching orders by customer ID becomes slow. The present case is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. The relevant action here is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

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 Meadowcrest Health a migration requires carefully controlled SQL Server host settings. The relevant action here is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

Question 446

At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. The team proposes this approach: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. Which technical principle explains the choice?

  1. Serverless can scale compute according to activity and support auto-pause where configured and supported.
  2. The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.
  3. The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.
  4. SQL data manipulation statements have different effects on persisted records and must be controlled by matching predicates.

Answer & Explanations

Correct answer: C

A.

Serverless can scale compute according to activity and support auto-pause where configured and supported. That explains a separate situation: At Pineport Research an internal reporting database is idle most evenings. The current case is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. The actual mechanism is: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.

B.

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 Meadowcrest Health a migration requires carefully controlled SQL Server host settings. The actual mechanism is: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.

C.

The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. This principle supports the intervention: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. The relevant scenario is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. Verify the result by: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

D.

SQL data manipulation statements have different effects on persisted records and must be controlled by matching predicates. That explains a separate situation: At Harborpoint Deliveries only one tracking record needs a status correction. The current case is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. The actual mechanism is: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.

Question 447

At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. After implementing this approach—Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential—which result would most directly confirm success?

  1. Trigger a controlled connection interruption and verify the application retries idempotent operations safely.
  2. Verify a test operator can administer the VM guest and supported SQL configuration required by the application.
  3. Fetch a synthetic list twice after an index change and verify the ordered query still sorts by timestamp.
  4. Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

Answer & Explanations

Correct answer: B

A.

Trigger a controlled connection interruption and verify the application retries idempotent operations safely. This tests a separate situation: At Pinecrest Payments database failover should not charge a card twice. The observed case is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. Use this acceptance check instead: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

B.

Verify a test operator can administer the VM guest and supported SQL configuration required by the application. This tests the targeted action: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. The reason is: The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. The reported case is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings.

C.

Fetch a synthetic list twice after an index change and verify the ordered query still sorts by timestamp. This tests a separate situation: At Cedarbank Logistics dispatch lists must show oldest outstanding shipments first. The observed case is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. Use this acceptance check instead: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

D.

Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session. This tests a separate situation: At Meadowbank Health only an approved application subnet should query a managed SQL database. The observed case is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. Use this acceptance check instead: Verify a test operator can administer the VM guest and supported SQL configuration required by the application.

Question 448

At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. Which shortcut most directly threatens the intended data outcome?

  1. Use an INNER JOIN when the request explicitly includes customers with zero orders.
  2. Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database.
  3. Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility.
  4. Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service.

Answer & Explanations

Correct answer: D

A.

Use an INNER JOIN when the request explicitly includes customers with zero orders. This concerns another issue: At Westbridge Retail retention analysts need every customer including nonbuyers. In the stated case—At Meadowcrest Health a migration requires carefully controlled SQL Server host settings—reject: Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. The safer response is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

B.

Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database. This concerns another issue: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. In the stated case—At Meadowcrest Health a migration requires carefully controlled SQL Server host settings—reject: Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. The safer response is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

C.

Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. This concerns another issue: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. In the stated case—At Meadowcrest Health a migration requires carefully controlled SQL Server host settings—reject: Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. The safer response is: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

D.

Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. The scenario is: At Meadowcrest Health a migration requires carefully controlled SQL Server host settings. The likely failure is: Required low-level configuration cannot be implemented there. Instead: Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.

Question 449

At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. Which design or Azure data approach best fits this requirement?

  1. Validate network access rules and Microsoft Entra authentication for Azure SQL connections.
  2. Use a managed open-source database service only after confirming extension, version and network compatibility.
  3. Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.
  4. Use a foreign key between order lines and their parent orders to enforce a valid relationship.

Answer & Explanations

Correct answer: C

A.

Validate network access rules and Microsoft Entra authentication for Azure SQL connections. This addresses a different situation: At Meadowbank Health only an approved application subnet should query a managed SQL database. The present case is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The relevant action here is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

B.

Use a managed open-source database service only after confirming extension, version and network compatibility. This addresses a different situation: At Oakridge Data a PostgreSQL service relies on a specialized geographic extension. The present case is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The relevant action here is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

C.

Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL. This works because: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure. The scenario is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. Verify the outcome by: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

D.

Use a foreign key between order lines and their parent orders to enforce a valid relationship. This addresses a different situation: At Silvercrest Commerce all invoice lines must belong to an existing order. The present case is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The relevant action here is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

Question 450

At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The team proposes this approach: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL. Which technical principle explains the choice?

  1. GROUP BY partitions rows into categories and aggregate functions calculate a result per category.
  2. A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.
  3. Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.
  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.

GROUP BY partitions rows into categories and aggregate functions calculate a result per category. That explains a separate situation: At Oakridge Supplies merchandising needs revenue by item family. The current case is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The actual mechanism is: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.

B.

A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure. This principle supports the intervention: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL. The relevant scenario is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. Verify the result by: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

C.

Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. That explains a separate situation: At Meadowbank Health only an approved application subnet should query a managed SQL database. The current case is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The actual mechanism is: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.

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 Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The actual mechanism is: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests