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 44

Question 430

At Pineport Retail developers want a cloud-hosted operational database without running database VMs. The team proposes this approach: Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration. Which technical principle explains the choice?

  1. Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data.
  2. The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.
  3. Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.
  4. A view provides a defined query interface and can omit fields that consumers should not see.

Answer & Explanations

Correct answer: A

A.

Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data. This principle supports the intervention: Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration. The relevant scenario is: At Pineport Retail developers want a cloud-hosted operational database without running database VMs. Verify the result by: Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS.

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 Pineport Retail developers want a cloud-hosted operational database without running database VMs. The actual mechanism is: Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data.

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 Pineport Retail developers want a cloud-hosted operational database without running database VMs. The actual mechanism is: Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data.

D.

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 Pineport Retail developers want a cloud-hosted operational database without running database VMs. The actual mechanism is: Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data.

Question 431

At Pineport Retail developers want a cloud-hosted operational database without running database VMs. After implementing this approach—Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration—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. 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. Change a sample order date once and verify all associated line records reflect the parent change.

Answer & Explanations

Correct answer: B

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 Pineport Retail developers want a cloud-hosted operational database without running database VMs. Use this acceptance check instead: Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS.

B.

Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS. This tests the targeted action: Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration. The reason is: Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data. The reported case is: At Pineport Retail developers want a cloud-hosted operational database without running database VMs.

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 Pineport Retail developers want a cloud-hosted operational database without running database VMs. Use this acceptance check instead: Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS.

D.

Change a sample order date once and verify all associated line records reflect the parent change. This tests a separate situation: At Cedarbrook Manufacturing order header details repeat across line items. The observed case is: At Pineport Retail developers want a cloud-hosted operational database without running database VMs. Use this acceptance check instead: Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS.

Question 432

At Pineport Retail developers want a cloud-hosted operational database without running database VMs. Which shortcut most directly threatens the intended data outcome?

  1. Deploy a full SQL Server virtual machine solely because every SQL database must have customer-managed operating system patches.
  2. Migrate a PostgreSQL-specific application blindly to a T-SQL dialect without evaluating compatibility.
  3. Increase storage capacity to solve a CPU-bound query plan without examining the bottleneck.
  4. Depend only on one web form to prevent invalid quantities from every API.

Answer & Explanations

Correct answer: A

A.

Deploy a full SQL Server virtual machine solely because every SQL database must have customer-managed operating system patches. The scenario is: At Pineport Retail developers want a cloud-hosted operational database without running database VMs. This undermines the mechanism: Azure SQL Database provides platform-managed database infrastructure and lifecycle tasks while customers control schema and data. Instead: Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration.

B.

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 Pineport Retail developers want a cloud-hosted operational database without running database VMs—reject: Deploy a full SQL Server virtual machine solely because every SQL database must have customer-managed operating system patches. The safer response is: Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration.

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 Pineport Retail developers want a cloud-hosted operational database without running database VMs—reject: Deploy a full SQL Server virtual machine solely because every SQL database must have customer-managed operating system patches. The safer response is: Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration.

D.

Depend only on one web form to prevent invalid quantities from every API. This concerns another issue: At Meadowline Manufacturing purchase quantities must be positive. In the stated case—At Pineport Retail developers want a cloud-hosted operational database without running database VMs—reject: Deploy a full SQL Server virtual machine solely because every SQL database must have customer-managed operating system patches. The safer response is: Choose Azure SQL Database for a new cloud relational application when a managed SQL database is preferred over server administration.

Question 433

At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. Which design or Azure data approach best fits this requirement?

  1. Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.
  2. Filter grouped aggregates with HAVING rather than using WHERE on an aggregate expression.
  3. Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
  4. Evaluate Azure SQL Database Hyperscale when a supported workload needs large database size and independently scalable read capacity.

Answer & Explanations

Correct answer: A

A.

Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. This works because: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. The scenario is: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. Verify the outcome by: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

B.

Filter grouped aggregates with HAVING rather than using WHERE on an aggregate expression. This addresses a different situation: At Meadowcrest Insurance analysts need branches exceeding an incident threshold. The present case is: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The relevant action here is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

C.

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 Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The relevant action here is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

D.

Evaluate Azure SQL Database Hyperscale when a supported workload needs large database size and independently scalable read capacity. This addresses a different situation: At Harborcrest Finance a long-lived transaction archive has rapid table growth. The present case is: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The relevant action here is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

Question 434

At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The team proposes this approach: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. Which technical principle explains the choice?

  1. The managed service supports MySQL-compatible workloads without requiring the team to operate the server VM.
  2. Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.
  3. An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.
  4. A single atomic field should not contain an uncontrolled list of repeating values.

Answer & Explanations

Correct answer: B

A.

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 Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The actual mechanism is: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.

B.

Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. This principle supports the intervention: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. The relevant scenario is: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. Verify the result by: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

C.

An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. That explains a separate situation: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The current case is: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The actual mechanism is: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.

D.

A single atomic field should not contain an uncontrolled list of repeating values. That explains a separate situation: At Meadowport Services customers often provide multiple contact phones. The current case is: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. The actual mechanism is: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.

Question 435

At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. After implementing this approach—Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility—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. Trigger a controlled connection interruption and verify the application retries idempotent operations safely.
  3. Fetch a synthetic list twice after an index change and verify the ordered query still sorts by timestamp.
  4. Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

Answer & Explanations

Correct answer: D

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 Silverline Finance an existing SQL Server application has linked workflows and instance requirements. Use this acceptance check instead: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

B.

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 Silverline Finance an existing SQL Server application has linked workflows and instance requirements. Use this acceptance check instead: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

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 Silverline Finance an existing SQL Server application has linked workflows and instance requirements. Use this acceptance check instead: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

D.

Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service. This tests the targeted action: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. The reason is: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. The reported case is: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements.

Question 436

At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. Which shortcut most directly threatens the intended data outcome?

  1. Give every reporting user direct access to all underlying columns for convenience.
  2. Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable.
  3. Assume every SQL Server instance feature exists unchanged in a single Azure SQL Database.
  4. Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service.

Answer & Explanations

Correct answer: C

A.

Give every reporting user direct access to all underlying columns for convenience. This concerns another issue: At Cedarcrest Travel analysts need booking summaries without card tokens. In the stated case—At Silverline Finance an existing SQL Server application has linked workflows and instance requirements—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.

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 Silverline Finance an existing SQL Server application has linked workflows and instance requirements—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 every SQL Server instance feature exists unchanged in a single Azure SQL Database. The scenario is: At Silverline Finance an existing SQL Server application has linked workflows and instance requirements. This undermines the mechanism: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. Instead: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

D.

Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. This concerns another issue: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. In the stated case—At Silverline Finance an existing SQL Server application has linked workflows and instance requirements—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.

Question 437

At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. Which design or Azure data approach best fits this requirement?

  1. Define a primary key on the order table that uniquely identifies each order record.
  2. Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.
  3. Scale Azure SQL compute based on observed CPU, IO, concurrent sessions and service-tier constraints.
  4. Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.

Answer & Explanations

Correct answer: B

A.

Define a primary key on the order table that uniquely identifies each order record. This addresses a different situation: At Bayfield Retail several orders can belong to one customer. The present case is: At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. The relevant action here is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

B.

Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. This works because: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. The scenario is: At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. Verify the outcome by: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

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 Oakridge Insurance administrators migrate several related databases with instance-level dependencies. The relevant action here is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

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 Oakridge Insurance administrators migrate several related databases with instance-level dependencies. The relevant action here is: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility.

Question 438

At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. The team proposes this approach: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. Which technical principle explains the choice?

  1. Selecting a service tier should reflect the actual workload bottleneck rather than database size alone.
  2. Serverless can scale compute according to activity and support auto-pause where configured and supported.
  3. Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.
  4. GROUP BY partitions rows into categories and aggregate functions calculate a result per category.

Answer & Explanations

Correct answer: C

A.

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 Oakridge Insurance administrators migrate several related databases with instance-level dependencies. The actual mechanism is: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.

B.

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 Oakridge Insurance administrators migrate several related databases with instance-level dependencies. The actual mechanism is: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.

C.

Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. This principle supports the intervention: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. The relevant scenario is: At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. Verify the result by: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

D.

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 Oakridge Insurance administrators migrate several related databases with instance-level dependencies. The actual mechanism is: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations.

Question 439

At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. After implementing this approach—Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility—which result would most directly confirm success?

  1. Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
  2. Query a test reporting view and confirm it excludes protected payment-token columns.
  3. Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.
  4. Trigger a controlled connection interruption and verify the application retries idempotent operations safely.

Answer & Explanations

Correct answer: C

A.

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 Oakridge Insurance administrators migrate several related databases with instance-level dependencies. Use this acceptance check instead: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

B.

Query a test reporting view and confirm it excludes protected payment-token columns. This tests a separate situation: At Cedarcrest Travel analysts need booking summaries without card tokens. The observed case is: At Oakridge Insurance administrators migrate several related databases with instance-level dependencies. Use this acceptance check instead: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

C.

Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service. This tests the targeted action: Select Azure SQL Managed Instance when migrating an application requiring greater SQL Server instance compatibility. The reason is: Managed Instance supports many instance-level SQL Server capabilities while retaining managed infrastructure operations. The reported case is: At Oakridge Insurance administrators migrate several related databases with instance-level dependencies.

D.

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 Oakridge Insurance administrators migrate several related databases with instance-level dependencies. Use this acceptance check instead: Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.

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.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests