Microsoft DP-900 Dumps
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?
Answer & Explanations
Correct answer: 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 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.
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.
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.
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?
Answer & Explanations
Correct answer: D
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.
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.
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.
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?
Answer & Explanations
Correct answer: 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.
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.
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.
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?
Answer & Explanations
Correct answer: D
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.
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.
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.
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?
Answer & Explanations
Correct answer: C
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.
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.
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.
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?
Answer & Explanations
Correct answer: C
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.
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.
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.
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?
Answer & Explanations
Correct answer: 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 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.
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.
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.
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?
Answer & Explanations
Correct answer: 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.
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.
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.
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?
Answer & Explanations
Correct answer: 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 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.
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.
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.
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?
Answer & Explanations
Correct answer: 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.
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.
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.
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?
Answer & Explanations
Correct answer: B
Assume one exported spreadsheet is a fully supported transaction-consistent recovery mechanism. This concerns another issue: At Silverlake Insurance a mistaken data delete must be recoverable from earlier in the day. In the stated case—At 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.
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.
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.
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
- Microsoft DP-900 Practice Test 48 - 10 Questions (Last Reviewed 02-Oct-2026)
- Microsoft DP-900 Practice Test 49 - 10 Questions (Last Reviewed 01-Oct-2026)
- Microsoft DP-900 Practice Test 50 - 10 Questions (Last Reviewed 30-Sep-2026)
- Microsoft DP-900 Practice Test 51 - 10 Questions (Last Reviewed 29-Sep-2026)
- Microsoft DP-900 Practice Test 52 - 10 Questions (Last Reviewed 28-Sep-2026)