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 50

Question 490

At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. The team proposes this approach: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. 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 automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.
  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 Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. The actual mechanism is: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.

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 Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. The actual mechanism is: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.

C.

Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability. This principle supports the intervention: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. The relevant scenario is: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. Verify the result by: Restore a synthetic database to a timestamp before an accidental test delete.

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 Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. The actual mechanism is: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.

Question 491

At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. After implementing this approach—Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs—which result would most directly confirm success?

  1. Inventory fictional extension dependencies and run a targeted proof-of-concept query on the selected Azure engine.
  2. Run a test compatibility inventory for instance-dependent jobs and confirm supported behaviors on the candidate service.
  3. Run a synthetic date-range query and confirm no out-of-range orders appear.
  4. Restore a synthetic database to a timestamp before an accidental test delete.

Answer & Explanations

Correct answer: D

A.

Inventory fictional extension dependencies and run a targeted proof-of-concept query on the selected Azure engine. This tests a separate situation: At Oakridge Data a PostgreSQL service relies on a specialized geographic extension. The observed case is: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. Use this acceptance check instead: Restore a synthetic database to a timestamp before an accidental test delete.

B.

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 Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. Use this acceptance check instead: Restore a synthetic database to a timestamp before an accidental test delete.

C.

Run a synthetic date-range query and confirm no out-of-range orders appear. This tests a separate situation: At Pineport Commerce support needs orders placed on one business day. The observed case is: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. Use this acceptance check instead: Restore a synthetic database to a timestamp before an accidental test delete.

D.

Restore a synthetic database to a timestamp before an accidental test delete. This tests the targeted action: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. The reason is: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability. The reported case is: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day.

Question 492

At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. Which shortcut most directly threatens the intended data outcome?

  1. Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism.
  2. Give every reporting user direct access to all underlying columns for convenience.
  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: A

A.

Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. The scenario is: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. This undermines the mechanism: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability. Instead: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

B.

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 Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day—reject: Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. The safer response is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

C.

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 Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day—reject: Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. The safer response is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

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 Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day—reject: Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. The safer response is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

Question 493

At Oakview Banking the finance database needs an audited restore-time objective. Which design or Azure data approach best fits this requirement?

  1. Use an INNER JOIN on approved keys to combine matching customer and order rows.
  2. Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
  3. Validate network access rules and Microsoft Entra authentication for Azure SQL connections.
  4. Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

Answer & Explanations

Correct answer: D

A.

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 Oakview Banking the finance database needs an audited restore-time objective. The relevant action here is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

B.

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 Oakview Banking the finance database needs an audited restore-time objective. The relevant action here is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

C.

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 Oakview Banking the finance database needs an audited restore-time objective. The relevant action here is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

D.

Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. This works because: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability. The scenario is: At Oakview Banking the finance database needs an audited restore-time objective. Verify the outcome by: Restore a synthetic database to a timestamp before an accidental test delete.

Question 494

At Oakview Banking the finance database needs an audited restore-time objective. The team proposes this approach: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. 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. Referential integrity prevents child rows from referencing missing parent rows.
  3. Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.
  4. Serverless can scale compute according to activity and support auto-pause where configured and supported.

Answer & Explanations

Correct answer: C

A.

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 Oakview Banking the finance database needs an audited restore-time objective. The actual mechanism is: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.

B.

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 Oakview Banking the finance database needs an audited restore-time objective. The actual mechanism is: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.

C.

Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability. This principle supports the intervention: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. The relevant scenario is: At Oakview Banking the finance database needs an audited restore-time objective. Verify the result by: Restore a synthetic database to a timestamp before an accidental test delete.

D.

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 Oakview Banking the finance database needs an audited restore-time objective. The actual mechanism is: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability.

Question 495

At Oakview Banking the finance database needs an audited restore-time objective. After implementing this approach—Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs—which result would most directly confirm success?

  1. Import a small MySQL test schema and verify client driver and query behavior.
  2. Test a harmless quoted customer name and confirm it is treated as a value rather than a SQL operator.
  3. Restore a synthetic database to a timestamp before an accidental test delete.
  4. Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

Answer & Explanations

Correct answer: C

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 Oakview Banking the finance database needs an audited restore-time objective. Use this acceptance check instead: Restore a synthetic database to a timestamp before an accidental test delete.

B.

Test a harmless quoted customer name and confirm it is treated as a value rather than a SQL operator. This tests a separate situation: At Silverport Retail a support page searches names containing apostrophes. The observed case is: At Oakview Banking the finance database needs an audited restore-time objective. Use this acceptance check instead: Restore a synthetic database to a timestamp before an accidental test delete.

C.

Restore a synthetic database to a timestamp before an accidental test delete. This tests the targeted action: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs. The reason is: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability. The reported case is: At Oakview Banking the finance database needs an audited restore-time objective.

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 Oakview Banking the finance database needs an audited restore-time objective. Use this acceptance check instead: Restore a synthetic database to a timestamp before an accidental test delete.

Question 496

At Oakview Banking the finance database needs an audited restore-time objective. Which shortcut most directly threatens the intended data outcome?

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

Answer & Explanations

Correct answer: B

A.

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 Oakview Banking the finance database needs an audited restore-time objective—reject: Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. The safer response is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

B.

Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. The scenario is: At Oakview Banking the finance database needs an audited restore-time objective. This undermines the mechanism: Managed automatic backups support supported point-in-time restore windows, while retention settings govern recoverability. Instead: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

C.

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 Oakview Banking the finance database needs an audited restore-time objective—reject: Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. The safer response is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

D.

Write email = NULL and assume the comparison identifies missing email values. This concerns another issue: At Willowport Health incomplete patient contact records need review. In the stated case—At Oakview Banking the finance database needs an audited restore-time objective—reject: Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. The safer response is: Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.

Question 497

At Meadowbank Health only an approved application subnet should query a managed SQL database. Which design or Azure data approach best fits this requirement?

  1. Validate network access rules and Microsoft Entra authentication for Azure SQL connections.
  2. Plan a managed Azure SQL backup retention and point-in-time restore strategy aligned to business recovery needs.
  3. Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
  4. Use ORDER BY for deterministic display of results rather than relying on physical row storage order.

Answer & Explanations

Correct answer: A

A.

Validate network access rules and Microsoft Entra authentication for Azure SQL connections. This works because: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. The scenario is: At Meadowbank Health only an approved application subnet should query a managed SQL database. Verify the outcome by: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

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 Meadowbank Health only an approved application subnet should query a managed SQL database. The relevant action here is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

C.

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 Meadowbank Health only an approved application subnet should query a managed SQL database. The relevant action here is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

D.

Use ORDER BY for deterministic display of results rather than relying on physical row storage order. This addresses a different situation: At Cedarbank Logistics dispatch lists must show oldest outstanding shipments first. The present case is: At Meadowbank Health only an approved application subnet should query a managed SQL database. The relevant action here is: Validate network access rules and Microsoft Entra authentication for Azure SQL connections.

Question 498

At Meadowbank Health only an approved application subnet should query a managed SQL database. The team proposes this approach: Validate network access rules and Microsoft Entra authentication for Azure SQL connections. 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. Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.
  3. Selecting a service tier should reflect the actual workload bottleneck rather than database size alone.
  4. WHERE filters individual rows before projection into the result set.

Answer & Explanations

Correct answer: B

A.

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 Meadowbank Health only an approved application subnet should query a managed SQL database. The actual mechanism is: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.

B.

Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. This principle supports the intervention: Validate network access rules and Microsoft Entra authentication for Azure SQL connections. The relevant scenario is: At Meadowbank Health only an approved application subnet should query a managed SQL database. Verify the result by: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

C.

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 Meadowbank Health only an approved application subnet should query a managed SQL database. The actual mechanism is: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.

D.

WHERE filters individual rows before projection into the result set. That explains a separate situation: At Pineport Commerce support needs orders placed on one business day. The current case is: At Meadowbank Health only an approved application subnet should query a managed SQL database. The actual mechanism is: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code.

Question 499

At Meadowbank Health only an approved application subnet should query a managed SQL database. After implementing this approach—Validate network access rules and Microsoft Entra authentication for Azure SQL connections—which result would most directly confirm success?

  1. Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.
  2. Compare a representative query plan and response after adding a test index.
  3. Deploy a test database, run an approved SQL query and verify the team does not manage the underlying guest OS.
  4. Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.

Answer & Explanations

Correct answer: A

A.

Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session. This tests the targeted action: Validate network access rules and Microsoft Entra authentication for Azure SQL connections. The reason is: Database connectivity requires permitted network paths and valid database identities independently of storing a password in code. The reported case is: At Meadowbank Health only an approved application subnet should query a managed SQL database.

B.

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 Meadowbank Health only an approved application subnet should query a managed SQL database. Use this acceptance check instead: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

C.

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 Meadowbank Health only an approved application subnet should query a managed SQL database. Use this acceptance check instead: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

D.

Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets. This tests a separate situation: At Cedarcrest SaaS hundreds of customer databases have different peak usage periods. The observed case is: At Meadowbank Health only an approved application subnet should query a managed SQL database. Use this acceptance check instead: Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

Question 500

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

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

Answer & Explanations

Correct answer: B

A.

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

B.

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

C.

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

D.

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

Microsoft Azure Data Fundamentals (DP-900) Practice Tests