Microsoft DP-900 Dumps
Microsoft DP-900 Practice Test 14
Question 130
At Pinefield Media the catalog links to thousands of high-resolution training videos. The team proposes this approach: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows. Which technical principle explains the choice?
Answer & Explanations
Correct answer: B
Analysts model business questions and visualize trusted information after data is made available. That explains a separate situation: At Cedarwood Retail leadership needs an explained conversion dashboard. The current case is: At Pinefield Media the catalog links to thousands of high-resolution training videos. The actual mechanism is: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata.
Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata. This principle supports the intervention: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows. The relevant scenario is: At Pinefield Media the catalog links to thousands of high-resolution training videos. Verify the result by: Retrieve a sample video object using the stored reference from an associated catalog row.
Precomputed summaries reduce the data scanned by queries when the needed grouping and refresh cadence are known. That explains a separate situation: At Westlake Streaming an operations dashboard repeatedly totals playbacks by day. The current case is: At Pinefield Media the catalog links to thousands of high-resolution training videos. The actual mechanism is: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata.
Parquet groups values by column and supports compression and selective column reads for analytics. That explains a separate situation: At Westport Retail analysts scan years of orders but query only a few measures. The current case is: At Pinefield Media the catalog links to thousands of high-resolution training videos. The actual mechanism is: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata.
Question 131
At Pinefield Media the catalog links to thousands of high-resolution training videos. After implementing this approach—Use an object store for large images and videos rather than embedding all media bytes in transactional database rows—which result would most directly confirm success?
Answer & Explanations
Correct answer: C
Update a test entitlement and immediately verify the read behavior under the selected consistency mode. This tests a separate situation: At Silvercrest Learning access to an exam subscription must change promptly after payment. The observed case is: At Pinefield Media the catalog links to thousands of high-resolution training videos. Use this acceptance check instead: Retrieve a sample video object using the stored reference from an associated catalog row.
Attempt a sample order referencing a nonexistent customer and verify the foreign-key design rejects it. This tests a separate situation: At Pinebridge Commerce the checkout system needs consistent orders and line items. The observed case is: At Pinefield Media the catalog links to thousands of high-resolution training videos. Use this acceptance check instead: Retrieve a sample video object using the stored reference from an associated catalog row.
Retrieve a sample video object using the stored reference from an associated catalog row. This tests the targeted action: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows. The reason is: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata. The reported case is: At Pinefield Media the catalog links to thousands of high-resolution training videos.
Trigger a synthetic pipeline with a bad record and verify engineering-controlled quarantine and retry behavior. This tests a separate situation: At Meadowport Finance several source applications must feed a daily analytics platform. The observed case is: At Pinefield Media the catalog links to thousands of high-resolution training videos. Use this acceptance check instead: Retrieve a sample video object using the stored reference from an associated catalog row.
Question 132
At Pinefield Media the catalog links to thousands of high-resolution training videos. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: C
Reject all events with an optional nested property absent even when the published contract allows it. This concerns another issue: At Meadowgate Utilities smart meters send evolving JSON telemetry payloads. In the stated case—At Pinefield Media the catalog links to thousands of high-resolution training videos—reject: Place every full-resolution video in a frequently indexed order table. The safer response is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Run full table scans against production transaction tables during the busiest sale. This concerns another issue: At Cedarfield Market a live checkout and weekly BI reports compete for database resources. In the stated case—At Pinefield Media the catalog links to thousands of high-resolution training videos—reject: Place every full-resolution video in a frequently indexed order table. The safer response is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Place every full-resolution video in a frequently indexed order table. The scenario is: At Pinefield Media the catalog links to thousands of high-resolution training videos. This undermines the mechanism: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata. Instead: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Require a many-table SQL join for every simple session cache lookup. This concerns another issue: At Cedarline Apps a session token maps directly to short-lived preferences. In the stated case—At Pinefield Media the catalog links to thousands of high-resolution training videos—reject: Place every full-resolution video in a frequently indexed order table. The safer response is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Question 133
At Oakbridge Healthcare approved medical images must be accessed through controlled object references. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: C
Choose a relational database for an order system requiring related customer, order, and payment entities with constraints. This addresses a different situation: At Pinebridge Commerce the checkout system needs consistent orders and line items. The present case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. The relevant action here is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Choose a typed date-time representation for business timestamps instead of sorting formatted date strings. This addresses a different situation: At Birchport Finance payment dates from several regions must sort correctly. The present case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. The relevant action here is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Use an object store for large images and videos rather than embedding all media bytes in transactional database rows. This works because: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata. The scenario is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. Verify the outcome by: Retrieve a sample video object using the stored reference from an associated catalog row.
Distinguish a data scientist's experimental modeling responsibilities from the DBA, engineer and analyst fundamentals roles. This addresses a different situation: At Northbridge Energy analysts report usage while scientists experiment with demand forecasting. The present case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. The relevant action here is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Question 134
At Oakbridge Healthcare approved medical images must be accessed through controlled object references. The team proposes this approach: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows. Which technical principle explains the choice?
Answer & Explanations
Correct answer: B
Parquet groups values by column and supports compression and selective column reads for analytics. That explains a separate situation: At Westport Retail analysts scan years of orders but query only a few measures. The current case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. The actual mechanism is: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata.
Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata. This principle supports the intervention: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows. The relevant scenario is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. Verify the result by: Retrieve a sample video object using the stored reference from an associated catalog row.
A property absent from a record is not automatically the numeric zero or an explicitly provided empty string. That explains a separate situation: At Northfield Energy some telemetry reports omit an unavailable temperature reading. The current case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. The actual mechanism is: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata.
Lineage makes it possible to trace a reported value back to processing steps and upstream origins. That explains a separate situation: At Harborland Compliance financial totals must be traceable for auditors. The current case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. The actual mechanism is: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata.
Question 135
At Oakbridge Healthcare approved medical images must be accessed through controlled object references. After implementing this approach—Use an object store for large images and videos rather than embedding all media bytes in transactional database rows—which result would most directly confirm success?
Answer & Explanations
Correct answer: A
Retrieve a sample video object using the stored reference from an associated catalog row. This tests the targeted action: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows. The reason is: Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata. The reported case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references.
Store one CSV, one JSON, and one image sample and verify each has an owned catalog entry. This tests a separate situation: At Meadowcrest Research telemetry, documents, and tabular datasets need a shared governed landing zone. The observed case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. Use this acceptance check instead: Retrieve a sample video object using the stored reference from an associated catalog row.
Retrieve a synthetic PDF by contract identifier and verify its original bytes and extracted tags. This tests a separate situation: At Pineport Legal signed vendor agreements must remain accessible alongside search tags. The observed case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. Use this acceptance check instead: Retrieve a sample video object using the stored reference from an associated catalog row.
Select a fictional report figure and identify its source files, transformations, and refresh timestamps. This tests a separate situation: At Harborland Compliance financial totals must be traceable for auditors. The observed case is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. Use this acceptance check instead: Retrieve a sample video object using the stored reference from an associated catalog row.
Question 136
At Oakbridge Healthcare approved medical images must be accessed through controlled object references. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: D
Split every CSV row on commas without honoring quoted fields. This concerns another issue: At Elmwood Manufacturing one nightly flat stock report must be exchanged with a partner. In the stated case—At Oakbridge Healthcare approved medical images must be accessed through controlled object references—reject: Place every full-resolution video in a frequently indexed order table. The safer response is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Replace every missing price or sensor value with zero without approval. This concerns another issue: At Northfield Energy some telemetry reports omit an unavailable temperature reading. In the stated case—At Oakbridge Healthcare approved medical images must be accessed through controlled object references—reject: Place every full-resolution video in a frequently indexed order table. The safer response is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Rewrite business metrics in a dashboard to hide a missing index on the source database. This concerns another issue: At Westfield Commerce SQL latency rises after order growth. In the stated case—At Oakbridge Healthcare approved medical images must be accessed through controlled object references—reject: Place every full-resolution video in a frequently indexed order table. The safer response is: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Place every full-resolution video in a frequently indexed order table. The scenario is: At Oakbridge Healthcare approved medical images must be accessed through controlled object references. The likely failure is: Transactional database storage and backup costs grow unnecessarily. Instead: Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
Question 137
At Cedarline Apps a session token maps directly to short-lived preferences. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: C
Preserve nested event payload structure rather than assuming every field occurs in every incoming event. This addresses a different situation: At Meadowgate Utilities smart meters send evolving JSON telemetry payloads. The present case is: At Cedarline Apps a session token maps directly to short-lived preferences. The relevant action here is: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins.
Use JSON Lines for streams of independently parseable JSON records rather than placing arbitrary commas between objects. This addresses a different situation: At Silvergate Transit event producers export millions of independent JSON events. The present case is: At Cedarline Apps a session token maps directly to short-lived preferences. The relevant action here is: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins.
Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins. This works because: Key-value reads retrieve values by their unique identifier with minimal schema overhead for the lookup pattern. The scenario is: At Cedarline Apps a session token maps directly to short-lived preferences. Verify the outcome by: Fetch a fictional session record by its ID and verify an unrelated ID returns no data.
Assign interpretation, report development and business metric explanation to the data analyst role. This addresses a different situation: At Cedarwood Retail leadership needs an explained conversion dashboard. The present case is: At Cedarline Apps a session token maps directly to short-lived preferences. The relevant action here is: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins.
Question 138
At Cedarline Apps a session token maps directly to short-lived preferences. The team proposes this approach: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins. Which technical principle explains the choice?
Answer & Explanations
Correct answer: D
Transactional locking or optimistic concurrency detects conflicting updates before both reservations are committed. That explains a separate situation: At Pinehill Commerce flash-sale buyers compete for the final inventory item. The current case is: At Cedarline Apps a session token maps directly to short-lived preferences. The actual mechanism is: Key-value reads retrieve values by their unique identifier with minimal schema overhead for the lookup pattern.
Analysts model business questions and visualize trusted information after data is made available. That explains a separate situation: At Cedarwood Retail leadership needs an explained conversion dashboard. The current case is: At Cedarline Apps a session token maps directly to short-lived preferences. The actual mechanism is: Key-value reads retrieve values by their unique identifier with minimal schema overhead for the lookup pattern.
Warehouses organize conformed analytical data for scans and aggregation without depending on the hot OLTP write path. That explains a separate situation: At Harborpoint Retail finance combines sales records from several brands. The current case is: At Cedarline Apps a session token maps directly to short-lived preferences. The actual mechanism is: Key-value reads retrieve values by their unique identifier with minimal schema overhead for the lookup pattern.
Key-value reads retrieve values by their unique identifier with minimal schema overhead for the lookup pattern. This principle supports the intervention: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins. The relevant scenario is: At Cedarline Apps a session token maps directly to short-lived preferences. Verify the result by: Fetch a fictional session record by its ID and verify an unrelated ID returns no data.
Question 139
At Cedarline Apps a session token maps directly to short-lived preferences. After implementing this approach—Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins—which result would most directly confirm success?
Answer & Explanations
Correct answer: C
Run a quarterly revenue aggregation and confirm it queries curated analytical tables rather than the payment API. This tests a separate situation: At Harborpoint Retail finance combines sales records from several brands. The observed case is: At Cedarline Apps a session token maps directly to short-lived preferences. Use this acceptance check instead: Fetch a fictional session record by its ID and verify an unrelated ID returns no data.
Review a sample field rule and verify its owner approved the definition and access boundary. This tests a separate situation: At Pinecrest Insurance claim status meanings must remain consistent across teams. The observed case is: At Cedarline Apps a session token maps directly to short-lived preferences. Use this acceptance check instead: Fetch a fictional session record by its ID and verify an unrelated ID returns no data.
Fetch a fictional session record by its ID and verify an unrelated ID returns no data. This tests the targeted action: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins. The reason is: Key-value reads retrieve values by their unique identifier with minimal schema overhead for the lookup pattern. The reported case is: At Cedarline Apps a session token maps directly to short-lived preferences.
Parse a test configuration and retrieve one deeply nested feature flag by its path. This tests a separate situation: At Baycrest Software each customer has optional nested feature settings. The observed case is: At Cedarline Apps a session token maps directly to short-lived preferences. Use this acceptance check instead: Fetch a fictional session record by its ID and verify an unrelated ID returns no data.
Question 140
At Cedarline Apps a session token maps directly to short-lived preferences. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: D
Execute two unrelated independent updates and consider the transfer complete after only one succeeds. This concerns another issue: At Northcrest Banking account transfers require all-or-nothing postings. In the stated case—At Cedarline Apps a session token maps directly to short-lived preferences—reject: Require a many-table SQL join for every simple session cache lookup. The safer response is: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins.
Make every report author manually download and merge raw files each morning. This concerns another issue: At Meadowport Finance several source applications must feed a daily analytics platform. In the stated case—At Cedarline Apps a session token maps directly to short-lived preferences—reject: Require a many-table SQL join for every simple session cache lookup. The safer response is: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins.
Convert the analytical table to a giant untyped text file and assume scanning just one attribute costs nothing. This concerns another issue: At Westport Retail analysts scan years of orders but query only a few measures. In the stated case—At Cedarline Apps a session token maps directly to short-lived preferences—reject: Require a many-table SQL join for every simple session cache lookup. The safer response is: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins.
Require a many-table SQL join for every simple session cache lookup. The scenario is: At Cedarline Apps a session token maps directly to short-lived preferences. The likely failure is: The simple lookup becomes more complex and costly than necessary. Instead: Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins.
Microsoft Azure Data Fundamentals (DP-900) Practice Tests
- Microsoft DP-900 Practice Test 12 - 10 Questions (Last Reviewed 07-Nov-2026)
- Microsoft DP-900 Practice Test 13 - 10 Questions (Last Reviewed 06-Nov-2026)
- Microsoft DP-900 Practice Test 14 - 10 Questions (Last Reviewed 05-Nov-2026)
- Microsoft DP-900 Practice Test 15 - 10 Questions (Last Reviewed 04-Nov-2026)
- Microsoft DP-900 Practice Test 16 - 10 Questions (Last Reviewed 03-Nov-2026)