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 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?

  1. Analysts model business questions and visualize trusted information after data is made available.
  2. Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata.
  3. Precomputed summaries reduce the data scanned by queries when the needed grouping and refresh cadence are known.
  4. Parquet groups values by column and supports compression and selective column reads for analytics.

Answer & Explanations

Correct answer: B

A.

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.

B.

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.

C.

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.

D.

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?

  1. Update a test entitlement and immediately verify the read behavior under the selected consistency mode.
  2. Attempt a sample order referencing a nonexistent customer and verify the foreign-key design rejects it.
  3. Retrieve a sample video object using the stored reference from an associated catalog row.
  4. Trigger a synthetic pipeline with a bad record and verify engineering-controlled quarantine and retry behavior.

Answer & Explanations

Correct answer: C

A.

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.

B.

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.

C.

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.

D.

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?

  1. Reject all events with an optional nested property absent even when the published contract allows it.
  2. Run full table scans against production transaction tables during the busiest sale.
  3. Place every full-resolution video in a frequently indexed order table.
  4. Require a many-table SQL join for every simple session cache lookup.

Answer & Explanations

Correct answer: C

A.

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.

B.

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.

C.

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.

D.

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?

  1. Choose a relational database for an order system requiring related customer, order, and payment entities with constraints.
  2. Choose a typed date-time representation for business timestamps instead of sorting formatted date strings.
  3. Use an object store for large images and videos rather than embedding all media bytes in transactional database rows.
  4. Distinguish a data scientist's experimental modeling responsibilities from the DBA, engineer and analyst fundamentals roles.

Answer & Explanations

Correct answer: C

A.

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.

B.

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.

C.

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.

D.

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?

  1. Parquet groups values by column and supports compression and selective column reads for analytics.
  2. Blob/object storage addresses binary objects independently while the relational system can reference object locations and metadata.
  3. A property absent from a record is not automatically the numeric zero or an explicitly provided empty string.
  4. Lineage makes it possible to trace a reported value back to processing steps and upstream origins.

Answer & Explanations

Correct answer: B

A.

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.

B.

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.

C.

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.

D.

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?

  1. Retrieve a sample video object using the stored reference from an associated catalog row.
  2. Store one CSV, one JSON, and one image sample and verify each has an owned catalog entry.
  3. Retrieve a synthetic PDF by contract identifier and verify its original bytes and extracted tags.
  4. Select a fictional report figure and identify its source files, transformations, and refresh timestamps.

Answer & Explanations

Correct answer: A

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.

B.

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.

C.

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.

D.

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?

  1. Split every CSV row on commas without honoring quoted fields.
  2. Replace every missing price or sensor value with zero without approval.
  3. Rewrite business metrics in a dashboard to hide a missing index on the source database.
  4. Place every full-resolution video in a frequently indexed order table.

Answer & Explanations

Correct answer: D

A.

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.

B.

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.

C.

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.

D.

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?

  1. Preserve nested event payload structure rather than assuming every field occurs in every incoming event.
  2. Use JSON Lines for streams of independently parseable JSON records rather than placing arbitrary commas between objects.
  3. Select key-value storage for lookups primarily addressed by a stable unique key rather than complex cross-record joins.
  4. Assign interpretation, report development and business metric explanation to the data analyst role.

Answer & Explanations

Correct answer: C

A.

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.

B.

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.

C.

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.

D.

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?

  1. Transactional locking or optimistic concurrency detects conflicting updates before both reservations are committed.
  2. Analysts model business questions and visualize trusted information after data is made available.
  3. Warehouses organize conformed analytical data for scans and aggregation without depending on the hot OLTP write path.
  4. Key-value reads retrieve values by their unique identifier with minimal schema overhead for the lookup pattern.

Answer & Explanations

Correct answer: D

A.

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.

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 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.

C.

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.

D.

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?

  1. Run a quarterly revenue aggregation and confirm it queries curated analytical tables rather than the payment API.
  2. Review a sample field rule and verify its owner approved the definition and access boundary.
  3. Fetch a fictional session record by its ID and verify an unrelated ID returns no data.
  4. Parse a test configuration and retrieve one deeply nested feature flag by its path.

Answer & Explanations

Correct answer: C

A.

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.

B.

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.

C.

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.

D.

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?

  1. Execute two unrelated independent updates and consider the transfer complete after only one succeeds.
  2. Make every report author manually download and merge raw files each morning.
  3. Convert the analytical table to a giant untyped text file and assume scanning just one attribute costs nothing.
  4. Require a many-table SQL join for every simple session cache lookup.

Answer & Explanations

Correct answer: D

A.

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.

B.

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.

C.

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.

D.

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