Microsoft DP-900 Dumps
Microsoft DP-900 Practice Test 48
Question 470
At Harborfield Property multiple small property-management databases share infrastructure. The team proposes this approach: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. Which technical principle explains the choice?
Answer & Explanations
Correct answer: D
Attributes dependent only on a portion of a composite key belong in a parent table rather than every line. That explains a separate situation: At Cedarbrook Manufacturing order header details repeat across line items. The current case is: At Harborfield Property multiple small property-management databases share infrastructure. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.
Selecting a service tier should reflect the actual workload bottleneck rather than database size alone. That explains a separate situation: At Bayfield Travel application requests slow under concurrent booking loads. The current case is: At Harborfield Property multiple small property-management databases share infrastructure. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.
A managed PostgreSQL service preserves the expected database engine dialect while Azure operates much of the infrastructure. That explains a separate situation: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The current case is: At Harborfield Property multiple small property-management databases share infrastructure. The actual mechanism is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily.
An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. This principle supports the intervention: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. The relevant scenario is: At Harborfield Property multiple small property-management databases share infrastructure. Verify the result by: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.
Question 471
At Harborfield Property multiple small property-management databases share infrastructure. After implementing this approach—Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand—which result would most directly confirm success?
Answer & Explanations
Correct answer: 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 Harborfield Property multiple small property-management databases share infrastructure. Use this acceptance check instead: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.
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 Harborfield Property multiple small property-management databases share infrastructure. Use this acceptance check instead: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.
Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets. This tests the targeted action: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand. The reason is: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. The reported case is: At Harborfield Property multiple small property-management databases share infrastructure.
Try a synthetic order with negative quantity and verify an enforced check rejects it. This tests a separate situation: At Meadowline Manufacturing purchase quantities must be positive. The observed case is: At Harborfield Property multiple small property-management databases share infrastructure. Use this acceptance check instead: Generate staggered synthetic tenant loads and inspect whether pooled capacity meets service targets.
Question 472
At Harborfield Property multiple small property-management databases share infrastructure. 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 Harborfield Property multiple small property-management databases share infrastructure—reject: Give every low-usage tenant its own permanently oversized dedicated compute tier. The safer response is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
Give every low-usage tenant its own permanently oversized dedicated compute tier. The scenario is: At Harborfield Property multiple small property-management databases share infrastructure. This undermines the mechanism: An elastic pool shares allocated resources across databases whose peaks do not overlap heavily. Instead: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
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 Harborfield Property multiple small property-management databases share infrastructure—reject: Give every low-usage tenant its own permanently oversized dedicated compute tier. The safer response is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
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 Harborfield Property multiple small property-management databases share infrastructure—reject: Give every low-usage tenant its own permanently oversized dedicated compute tier. The safer response is: Use an Azure SQL Database elastic pool for several databases with varying, noncoincident resource demand.
Question 473
At Pineport Research an internal reporting database is idle most evenings. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: C
Deploy Azure Database for MySQL Flexible Server when the application requires a compatible managed MySQL engine. This addresses a different situation: At Meadowline Commerce a storefront relies on an existing MySQL schema. The present case is: At Pineport Research an internal reporting database is idle most evenings. The relevant action here is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
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 Pineport Research an internal reporting database is idle most evenings. The relevant action here is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. This works because: Serverless can scale compute according to activity and support auto-pause where configured and supported. The scenario is: At Pineport Research an internal reporting database is idle most evenings. Verify the outcome by: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
Distinguish automatic service availability from application transaction retry and failover handling. This addresses a different situation: At Pinecrest Payments database failover should not charge a card twice. The present case is: At Pineport Research an internal reporting database is idle most evenings. The relevant action here is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Question 474
At Pineport Research an internal reporting database is idle most evenings. The team proposes this approach: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. Which technical principle explains the choice?
Answer & Explanations
Correct answer: D
A relational join links rows through corresponding key values and inner joins retain matches only. That explains a separate situation: At Cedarcrest Finance invoices must display the correct customer account. The current case is: At Pineport Research an internal reporting database is idle most evenings. The actual mechanism is: Serverless can scale compute according to activity and support auto-pause where configured and supported.
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 Research an internal reporting database is idle most evenings. The actual mechanism is: Serverless can scale compute according to activity and support auto-pause where configured and supported.
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 Pineport Research an internal reporting database is idle most evenings. The actual mechanism is: Serverless can scale compute according to activity and support auto-pause where configured and supported.
Serverless can scale compute according to activity and support auto-pause where configured and supported. This principle supports the intervention: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. The relevant scenario is: At Pineport Research an internal reporting database is idle most evenings. Verify the result by: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
Question 475
At Pineport Research an internal reporting database is idle most evenings. After implementing this approach—Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity—which result would most directly confirm success?
Answer & Explanations
Correct answer: A
Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior. This tests the targeted action: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. The reason is: Serverless can scale compute according to activity and support auto-pause where configured and supported. The reported case is: At Pineport Research an internal reporting database is idle most evenings.
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 Pineport Research an internal reporting database is idle most evenings. Use this acceptance check instead: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
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 Pineport Research an internal reporting database is idle most evenings. Use this acceptance check instead: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
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 Pineport Research an internal reporting database is idle most evenings. Use this acceptance check instead: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
Question 476
At Pineport Research an internal reporting database is idle most evenings. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: D
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 Pineport Research an internal reporting database is idle most evenings—reject: Assume a continuously saturated production database will pause and deliver large idle savings. The safer response is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
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 Pineport Research an internal reporting database is idle most evenings—reject: Assume a continuously saturated production database will pause and deliver large idle savings. The safer response is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Copy mutable city tax settings onto every customer row with no shared reference. This concerns another issue: At Harborcrest Tax a postal region's standard reference data changes annually. In the stated case—At Pineport Research an internal reporting database is idle most evenings—reject: Assume a continuously saturated production database will pause and deliver large idle savings. The safer response is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Assume a continuously saturated production database will pause and deliver large idle savings. The scenario is: At Pineport Research an internal reporting database is idle most evenings. The likely failure is: The cost assumption fails under constant utilization. Instead: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Question 477
At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: C
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. The relevant action here is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Use parameterized SQL statements when querying records with user-provided search terms. This addresses a different situation: At Silverport Retail a support page searches names containing apostrophes. The present case is: At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. The relevant action here is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. This works because: Serverless can scale compute according to activity and support auto-pause where configured and supported. The scenario is: At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. Verify the outcome by: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
Deploy Azure Database for PostgreSQL Flexible Server for an application whose existing SQL features depend on PostgreSQL. This addresses a different situation: At Harborbank Analytics developers use PostgreSQL functions in a line-of-business app. The present case is: At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. The relevant action here is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Question 478
At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. The team proposes this approach: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. Which technical principle explains the choice?
Answer & Explanations
Correct answer: D
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. The actual mechanism is: Serverless can scale compute according to activity and support auto-pause where configured and supported.
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. The actual mechanism is: Serverless can scale compute according to activity and support auto-pause where configured and supported.
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. The actual mechanism is: Serverless can scale compute according to activity and support auto-pause where configured and supported.
Serverless can scale compute according to activity and support auto-pause where configured and supported. This principle supports the intervention: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. The relevant scenario is: At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. Verify the result by: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
Question 479
At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. After implementing this approach—Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity—which result would most directly confirm success?
Answer & Explanations
Correct answer: B
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. Use this acceptance check instead: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior. This tests the targeted action: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity. The reason is: Serverless can scale compute according to activity and support auto-pause where configured and supported. The reported case is: At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests.
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. Use this acceptance check instead: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. Use this acceptance check instead: Execute synthetic weekday and idle-period workloads and examine auto-pause and restart behavior.
Question 480
At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: C
Join customers and orders only on a similar-looking surname. This concerns another issue: At Cedarcrest Finance invoices must display the correct customer account. In the stated case—At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests—reject: Assume a continuously saturated production database will pause and deliver large idle savings. The safer response is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests—reject: Assume a continuously saturated production database will pause and deliver large idle savings. The safer response is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Assume a continuously saturated production database will pause and deliver large idle savings. The scenario is: At Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests. This undermines the mechanism: Serverless can scale compute according to activity and support auto-pause where configured and supported. Instead: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
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 Meadowbridge Services a proof-of-concept SQL database runs infrequent development tests—reject: Assume a continuously saturated production database will pause and deliver large idle savings. The safer response is: Consider Azure SQL Database serverless compute for an eligible single database with intermittent activity.
Microsoft Azure Data Fundamentals (DP-900) Practice Tests
- Microsoft DP-900 Practice Test 46 - 10 Questions (Last Reviewed 04-Oct-2026)
- Microsoft DP-900 Practice Test 47 - 10 Questions (Last Reviewed 03-Oct-2026)
- 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)