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 47

Question 460

At Meadowline Commerce a storefront relies on an existing MySQL schema. Which shortcut most directly threatens the intended data outcome?

  1. Increase storage capacity to solve a CPU-bound query plan without examining the bottleneck.
  2. Open database access to every public address while sharing a master login in a repository.
  3. Execute UPDATE without a WHERE condition on a large production status table.
  4. Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable.

Answer & Explanations

Correct answer: D

A.

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 Meadowline Commerce a storefront relies on an existing MySQL schema—reject: Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. The safer response is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

B.

Open database access to every public address while sharing a master login in a repository. This concerns another issue: At Meadowbank Health only an approved application subnet should query a managed SQL database. In the stated case—At Meadowline Commerce a storefront relies on an existing MySQL schema—reject: Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. The safer response is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

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 Meadowline Commerce a storefront relies on an existing MySQL schema—reject: Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. The safer response is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

D.

Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. The scenario is: At Meadowline Commerce a storefront relies on an existing MySQL schema. The likely failure is: The application fails on incompatible query semantics and connectors. Instead: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

Question 461

At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. Which design or Azure data approach best fits this requirement?

  1. Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
  2. Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.
  3. Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.
  4. Aggregate sales by product using GROUP BY and an appropriate numeric SUM expression.

Answer & Explanations

Correct answer: C

A.

Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. This addresses a different situation: At Pineport Research an internal reporting database is idle most evenings. The present case is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. The relevant action here is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

B.

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 Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. The relevant action here is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

C.

Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine. This works because: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM. The scenario is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. Verify the outcome by: Import a small MySQL test schema and verify client driver and query behavior.

D.

Aggregate sales by product using GROUP BY and an appropriate numeric SUM expression. This addresses a different situation: At Oakridge Supplies merchandising needs revenue by item family. The present case is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. The relevant action here is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

Question 462

At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. The team proposes this approach: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine. Which technical principle explains the choice?

  1. Hyperscale's storage and compute architecture targets large-scale SQL Database workloads with distinct storage scaling behavior.
  2. Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data.
  3. The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.
  4. NULL participates in SQL three-valued logic rather than equaling an ordinary string or number.

Answer & Explanations

Correct answer: C

A.

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 Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. The actual mechanism is: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.

B.

Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data. That explains a separate situation: At Harborcrest Apps a new order service needs managed T-SQL storage. The current case is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. The actual mechanism is: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.

C.

The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM. This principle supports the intervention: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine. The relevant scenario is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. Verify the result by: Import a small MySQL test schema and verify client driver and query behavior.

D.

NULL participates in SQL three-valued logic rather than equaling an ordinary string or number. That explains a separate situation: At Willowport Health incomplete patient contact records need review. The current case is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. The actual mechanism is: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.

Question 463

At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. After implementing this approach—Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine—which result would most directly confirm success?

  1. Import a small MySQL test schema and verify client driver and query behavior.
  2. Restore a synthetic database to a timestamp before an accidental test delete.
  3. Run a test query returning only regions with more than ten sales and verify the correct grouping.
  4. Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.

Answer & Explanations

Correct answer: A

A.

Import a small MySQL test schema and verify client driver and query behavior. This tests the targeted action: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine. The reason is: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM. The reported case is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups.

B.

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 Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. Use this acceptance check instead: Import a small MySQL test schema and verify client driver and query behavior.

C.

Run a test query returning only regions with more than ten sales and verify the correct grouping. This tests a separate situation: At Meadowcrest Insurance analysts need branches exceeding an incident threshold. The observed case is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. Use this acceptance check instead: Import a small MySQL test schema and verify client driver and query behavior.

D.

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 Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. Use this acceptance check instead: Import a small MySQL test schema and verify client driver and query behavior.

Question 464

At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. 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. Concatenate untrusted search input directly into a SELECT string.
  3. Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable.
  4. Deploy a full SQL Server virtual machine solely because every SQL database must have customer-managed operating system patches.

Answer & Explanations

Correct answer: C

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 Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups—reject: Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. The safer response is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

B.

Concatenate untrusted search input directly into a SELECT string. This concerns another issue: At Silverport Retail a support page searches names containing apostrophes. In the stated case—At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups—reject: Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. The safer response is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

C.

Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. The scenario is: At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups. This undermines the mechanism: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM. Instead: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

D.

Deploy a full SQL Server virtual machine solely because every SQL database must have customer-managed operating system patches. This concerns another issue: At Harborcrest Apps a new order service needs managed T-SQL storage. In the stated case—At Pinebrook Travel a booking backend uses the MySQL protocol and needs hosted backups—reject: Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. The safer response is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

Question 465

At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. Which design or Azure data approach best fits this requirement?

  1. Create an index on frequently filtered columns when measured query patterns justify it.
  2. Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.
  3. Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
  4. Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

Answer & Explanations

Correct answer: C

A.

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 Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The relevant action here is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

B.

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 Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The relevant action here is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

C.

Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. This works because: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. The scenario is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. Verify the outcome by: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.

D.

Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. This addresses a different situation: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. The present case is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The relevant action here is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

Question 466

At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The team proposes this approach: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. Which technical principle explains the choice?

  1. Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.
  2. An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.
  3. Referential integrity prevents child rows from referencing missing parent rows.
  4. A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.

Answer & Explanations

Correct answer: B

A.

Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability. That explains a separate situation: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. The current case is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.

B.

An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. This principle supports the intervention: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. The relevant scenario is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. Verify the result by: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.

C.

Referential integrity prevents child rows from referencing missing parent rows. That explains a separate situation: At Silvercrest Commerce all invoice lines must belong to an existing order. The current case is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.

D.

A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure. That explains a separate situation: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The current case is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.

Question 467

At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. After implementing this approach—Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand—which result would most directly confirm success?

  1. Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.
  2. Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS.
  3. Compare a large synthetic database growth and read workload against eligible Hyperscale limits.
  4. Query synthetic customers and orders and verify an unmatched order is not returned by the inner join.

Answer & Explanations

Correct answer: A

A.

Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets. This tests the targeted action: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. The reason is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. The reported case is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods.

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 Cedarcrest SaaS hundreds of customer databases have different peak usage periods. Use this acceptance check instead: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.

C.

Compare a large synthetic database growth and read workload against eligible Hyperscale limits. This tests a separate situation: At Harborcrest Finance a long-lived transaction archive has rapid table growth. The observed case is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. Use this acceptance check instead: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.

D.

Query synthetic customers and orders and verify an unmatched order is not returned by the inner join. This tests a separate situation: At Cedarcrest Finance invoices must display the correct customer account. The observed case is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. Use this acceptance check instead: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.

Question 468

At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. Which shortcut most directly threatens the intended data outcome?

  1. Treat any transient SQL connection reset as an instruction to blindly double-submit the same payment.
  2. Add indexes to every column without considering insert overhead or actual predicates.
  3. Assume a continuously saturated production database will pause and deliver large idle savings.
  4. Give every low-usage tenant its own permanently oversized dedicated compute tier.

Answer & Explanations

Correct answer: D

A.

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 Cedarcrest SaaS hundreds of customer databases have different peak usage periods—reject: Give every low-usage tenant its own permanently oversized dedicated compute tier. The safer response is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

B.

Add indexes to every column without considering insert overhead or actual predicates. This concerns another issue: At Silverfield Commerce searching orders by customer ID becomes slow. In the stated case—At Cedarcrest SaaS hundreds of customer databases have different peak usage periods—reject: Give every low-usage tenant its own permanently oversized dedicated compute tier. The safer response is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

C.

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 Cedarcrest SaaS hundreds of customer databases have different peak usage periods—reject: Give every low-usage tenant its own permanently oversized dedicated compute tier. The safer response is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

D.

Give every low-usage tenant its own permanently oversized dedicated compute tier. The scenario is: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The likely failure is: Resources are overprovisioned and operating costs increase. Instead: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

Question 469

At Harborfield Property multiple small property-management databases share infrastructure. Which design or Azure data approach best fits this requirement?

  1. Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.
  2. Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
  3. Distinguish automatic service availability from application transaction retry and failover handling.
  4. Apply first-normal-form principles by placing repeatable phone numbers in a separate related table.

Answer & Explanations

Correct answer: B

A.

Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. This addresses a different situation: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. The present case is: At Harborfield Property multiple small property-management databases share infrastructure. The relevant action here is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

B.

Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. This works because: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. The scenario is: At Harborfield Property multiple small property-management databases share infrastructure. Verify the outcome by: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.

C.

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 Harborfield Property multiple small property-management databases share infrastructure. The relevant action here is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

D.

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 Harborfield Property multiple small property-management databases share infrastructure. The relevant action here is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

Question 470

At Harborfield Property multiple small property-management databases share infrastructure. The team proposes this approach: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. Which technical principle explains the choice?

  1. Attributes dependent only on a portion of a composite key belong in a parent table rather than every line.
  2. Selecting a service tier should reflect the actual workload bottleneck rather than database size alone.
  3. A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.
  4. An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.

Answer & Explanations

Correct answer: D

A.

Attributes dependent only on a portion of a composite key belong in a parent table rather than every line. That explains a separate situation: At Cedarbrook Manufacturing order header details repeat across line items. The current case is: At Harborfield Property multiple small property-management databases share infrastructure. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.

B.

Selecting a service tier should reflect the actual workload bottleneck rather than database size alone. That explains a separate situation: At Bayfield Travel application requests slow under concurrent booking loads. The current case is: At Harborfield Property multiple small property-management databases share infrastructure. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.

C.

A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure. That explains a separate situation: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The current case is: At Harborfield Property multiple small property-management databases share infrastructure. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.

D.

An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. This principle supports the intervention: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. The relevant scenario is: At Harborfield Property multiple small property-management databases share infrastructure. Verify the result by: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests