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 46

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.

Question 451

At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. After implementing this approach—Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL—which result would most directly confirm success?

  1. Verify a test operator can administer the VM guest and supported SQL configuration required by the application.
  2. Update one fictional delivery status and confirm only the intended primary-key row changes.
  3. Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.
  4. Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS.

Answer & Explanations

Correct answer: C

A.

Verify a test operator can administer the VM guest and supported SQL configuration required by the application. This tests a separate situation: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The observed case is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. Use this acceptance check instead: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

B.

Update one fictional delivery status and confirm only the intended primary-key row changes. This tests a separate situation: At Harborpoint Deliveries only one tracking record needs a status correction. The observed case is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. Use this acceptance check instead: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

C.

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

D.

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 Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. Use this acceptance check instead: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

Question 452

At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. Which shortcut most directly threatens the intended data outcome?

  1. Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility.
  2. Assume every self-hosted PostgreSQL extension can be installed with root OS access in a managed database.
  3. Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database.
  4. Concatenate untrusted search input directly into a SELECT string.

Answer & Explanations

Correct answer: A

A.

Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. The scenario is: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. This undermines the mechanism: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure. Instead: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

B.

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 Harborbank Analytics developers use PostgreSQL functions in a line-of-business app—reject: Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. The safer response is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

C.

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 Harborbank Analytics developers use PostgreSQL functions in a line-of-business app—reject: Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. The safer response is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

D.

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 Harborbank Analytics developers use PostgreSQL functions in a line-of-business app—reject: Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. The safer response is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

Question 453

At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. 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. Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.
  3. Use an INNER JOIN on approved keys to combine matching customer and order rows.
  4. Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

Answer & Explanations

Correct answer: B

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. The relevant action here is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

B.

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. Verify the outcome by: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

C.

Use an INNER JOIN on approved keys to combine matching customer and order rows. This addresses a different situation: At Cedarcrest Finance invoices must display the correct customer account. The present case is: At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. The relevant action here is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. The relevant action here is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

Question 454

At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. 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. Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.
  2. NULL participates in SQL three-valued logic rather than equaling an ordinary string or number.
  3. A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.
  4. Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data.

Answer & Explanations

Correct answer: C

A.

Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. That explains a separate situation: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The current case is: At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. The actual mechanism is: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.

B.

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. The actual mechanism is: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.

C.

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. Verify the result by: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

D.

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. The actual mechanism is: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure.

Question 455

At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. After implementing this approach—Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL—which result would most directly confirm success?

  1. Trigger a controlled connection interruption and verify the application retries idempotent operations safely.
  2. Insert a test line for an absent order ID and confirm the database rejects the reference.
  3. Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.
  4. Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

Answer & Explanations

Correct answer: D

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. Use this acceptance check instead: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

B.

Insert a test line for an absent order ID and confirm the database rejects the reference. This tests a separate situation: At Silvercrest Commerce all invoice lines must belong to an existing order. The observed case is: At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. Use this acceptance check instead: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

C.

Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service. This tests a separate situation: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The observed case is: At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. Use this acceptance check instead: Run a representative PostgreSQL-specific query and verify extension requirements against documented service support.

D.

Run a representative PostgreSQL-specific query and verify extension requirements against documented service support. This tests the targeted action: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL. The reason is: A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure. The reported case is: At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting.

Question 456

At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. 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. Put COUNT(*) in a row-level WHERE clause and expect every database to accept it.
  3. Assume a continuously saturated production database will pause and deliver large idle savings.
  4. Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility.

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting—reject: Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. The safer response is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

B.

Put COUNT(*) in a row-level WHERE clause and expect every database to accept it. This concerns another issue: At Meadowcrest Insurance analysts need branches exceeding an incident threshold. In the stated case—At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting—reject: Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. The safer response is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

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 Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting—reject: Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. The safer response is: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

D.

Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility. The scenario is: At Silverpoint Education a new open-source PostgreSQL-backed service needs managed hosting. The likely failure is: Queries and application logic can break after migration. Instead: Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL.

Question 457

At Meadowline Commerce a storefront relies on an existing MySQL schema. 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. Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.
  3. Create an index on frequently filtered columns when measured query patterns justify it.
  4. Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

Answer & Explanations

Correct answer: D

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 Meadowline Commerce a storefront relies on an existing MySQL schema. The relevant action here is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

B.

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 Meadowline Commerce a storefront relies on an existing MySQL schema. The relevant action here is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

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 Meadowline Commerce a storefront relies on an existing MySQL schema. The relevant action here is: Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine.

D.

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 Meadowline Commerce a storefront relies on an existing MySQL schema. Verify the outcome by: Import a small MySQL test schema and verify client driver and query behavior.

Question 458

At Meadowline Commerce a storefront relies on an existing MySQL schema. 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. Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.
  2. GROUP BY partitions rows into categories and aggregate functions calculate a result per category.
  3. Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors.
  4. The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.

Answer & Explanations

Correct answer: D

A.

Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. That explains a separate situation: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The current case is: At Meadowline Commerce a storefront relies on an existing MySQL schema. The actual mechanism is: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.

B.

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 Meadowline Commerce a storefront relies on an existing MySQL schema. The actual mechanism is: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.

C.

Platform-managed high availability protects eligible infrastructure failures, but clients must tolerate transient connection errors. That explains a separate situation: At Pinecrest Payments database failover should not charge a card twice. The current case is: At Meadowline Commerce a storefront relies on an existing MySQL schema. The actual mechanism is: The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.

D.

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 Meadowline Commerce a storefront relies on an existing MySQL schema. Verify the result by: Import a small MySQL test schema and verify client driver and query behavior.

Question 459

At Meadowline Commerce a storefront relies on an existing MySQL schema. 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. Run a synthetic peak query mix and inspect resource metrics before and after a justified tier change.
  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 Meadowline Commerce a storefront relies on an existing MySQL schema.

B.

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 Meadowline Commerce a storefront relies on an existing MySQL schema. 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 Meadowline Commerce a storefront relies on an existing MySQL schema. 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 Meadowline Commerce a storefront relies on an existing MySQL schema. Use this acceptance check instead: Import a small MySQL test schema and verify client driver and query behavior.

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.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests