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 1

Question 1

At Harborline Retail customer account data must support repeatable financial queries. Which design or Azure data approach best fits this requirement?

  1. Assign interpretation, report development and business metric explanation to the data analyst role.
  2. Choose a relational database for an order system requiring related customer, order, and payment entities with constraints.
  3. Store scanned contracts as unstructured documents with separate extracted searchable tags.
  4. Model fixed customer account fields as structured rows with typed columns and an enforced schema.

Answer & Explanations

Correct answer: D

A.

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 Harborline Retail customer account data must support repeatable financial queries. The relevant action here is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

B.

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 Harborline Retail customer account data must support repeatable financial queries. The relevant action here is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

C.

Store scanned contracts as unstructured documents with separate extracted searchable tags. This addresses a different situation: At Pineport Legal signed vendor agreements must remain accessible alongside search tags. The present case is: At Harborline Retail customer account data must support repeatable financial queries. The relevant action here is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

D.

Model fixed customer account fields as structured rows with typed columns and an enforced schema. This works because: Structured rows provide predictable columns and data types for SQL filtering and constraints. The scenario is: At Harborline Retail customer account data must support repeatable financial queries. Verify the outcome by: Insert a typed sample record and reject an incompatible value in the account number column.

Question 2

At Harborline Retail customer account data must support repeatable financial queries. The team proposes this approach: Model fixed customer account fields as structured rows with typed columns and an enforced schema. Which technical principle explains the choice?

  1. Structured rows provide predictable columns and data types for SQL filtering and constraints.
  2. Semi-structured event records can have varying schemas and optional nested objects while remaining parseable.
  3. Transactional locking or optimistic concurrency detects conflicting updates before both reservations are committed.
  4. One JSON object per line enables incremental processing without needing a single enclosing array.

Answer & Explanations

Correct answer: A

A.

Structured rows provide predictable columns and data types for SQL filtering and constraints. This principle supports the intervention: Model fixed customer account fields as structured rows with typed columns and an enforced schema. The relevant scenario is: At Harborline Retail customer account data must support repeatable financial queries. Verify the result by: Insert a typed sample record and reject an incompatible value in the account number column.

B.

Semi-structured event records can have varying schemas and optional nested objects while remaining parseable. That explains a separate situation: At Meadowgate Utilities smart meters send evolving JSON telemetry payloads. The current case is: At Harborline Retail customer account data must support repeatable financial queries. The actual mechanism is: Structured rows provide predictable columns and data types for SQL filtering and constraints.

C.

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 Harborline Retail customer account data must support repeatable financial queries. The actual mechanism is: Structured rows provide predictable columns and data types for SQL filtering and constraints.

D.

One JSON object per line enables incremental processing without needing a single enclosing array. That explains a separate situation: At Silvergate Transit event producers export millions of independent JSON events. The current case is: At Harborline Retail customer account data must support repeatable financial queries. The actual mechanism is: Structured rows provide predictable columns and data types for SQL filtering and constraints.

Question 3

At Harborline Retail customer account data must support repeatable financial queries. After implementing this approach—Model fixed customer account fields as structured rows with typed columns and an enforced schema—which result would most directly confirm success?

  1. Insert a typed sample record and reject an incompatible value in the account number column.
  2. Ingest a sample with three readings and verify the original ordered list is recoverable.
  3. Import a sample description containing a comma and verify columns do not shift.
  4. Update a test entitlement and immediately verify the read behavior under the selected consistency mode.

Answer & Explanations

Correct answer: A

A.

Insert a typed sample record and reject an incompatible value in the account number column. This tests the targeted action: Model fixed customer account fields as structured rows with typed columns and an enforced schema. The reason is: Structured rows provide predictable columns and data types for SQL filtering and constraints. The reported case is: At Harborline Retail customer account data must support repeatable financial queries.

B.

Ingest a sample with three readings and verify the original ordered list is recoverable. This tests a separate situation: At Harborfield Science an instrument exports a sequence of spectrometer samples per reading. The observed case is: At Harborline Retail customer account data must support repeatable financial queries. Use this acceptance check instead: Insert a typed sample record and reject an incompatible value in the account number column.

C.

Import a sample description containing a comma and verify columns do not shift. This tests a separate situation: At Elmwood Manufacturing one nightly flat stock report must be exchanged with a partner. The observed case is: At Harborline Retail customer account data must support repeatable financial queries. Use this acceptance check instead: Insert a typed sample record and reject an incompatible value in the account number column.

D.

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 Harborline Retail customer account data must support repeatable financial queries. Use this acceptance check instead: Insert a typed sample record and reject an incompatible value in the account number column.

Question 4

At Harborline Retail customer account data must support repeatable financial queries. Which shortcut most directly threatens the intended data outcome?

  1. Store every field as an unvalidated free-form string and rely on the dashboard to infer types.
  2. Concatenate JSON objects without separators and expect a standard parser to infer boundaries.
  3. Publish a transformed dataset with no source identifiers or pipeline history.
  4. Replace every missing price or sensor value with zero without approval.

Answer & Explanations

Correct answer: A

A.

Store every field as an unvalidated free-form string and rely on the dashboard to infer types. The scenario is: At Harborline Retail customer account data must support repeatable financial queries. This undermines the mechanism: Structured rows provide predictable columns and data types for SQL filtering and constraints. Instead: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

B.

Concatenate JSON objects without separators and expect a standard parser to infer boundaries. This concerns another issue: At Silvergate Transit event producers export millions of independent JSON events. In the stated case—At Harborline Retail customer account data must support repeatable financial queries—reject: Store every field as an unvalidated free-form string and rely on the dashboard to infer types. The safer response is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

C.

Publish a transformed dataset with no source identifiers or pipeline history. This concerns another issue: At Harborland Compliance financial totals must be traceable for auditors. In the stated case—At Harborline Retail customer account data must support repeatable financial queries—reject: Store every field as an unvalidated free-form string and rely on the dashboard to infer types. The safer response is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

D.

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 Harborline Retail customer account data must support repeatable financial queries—reject: Store every field as an unvalidated free-form string and rely on the dashboard to infer types. The safer response is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

Question 5

At Silverbrook Lending loan applications have required fields and validated numeric balances. Which design or Azure data approach best fits this requirement?

  1. Keep immutable raw events when analysts need to recompute historical metrics after the reporting logic changes.
  2. Model fixed customer account fields as structured rows with typed columns and an enforced schema.
  3. Use separation of duties for sensitive production database access and report publishing.
  4. Preserve nested event payload structure rather than assuming every field occurs in every incoming event.

Answer & Explanations

Correct answer: B

A.

Keep immutable raw events when analysts need to recompute historical metrics after the reporting logic changes. This addresses a different situation: At Meadowbank Commerce finance changes the definition of returned merchandise. The present case is: At Silverbrook Lending loan applications have required fields and validated numeric balances. The relevant action here is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

B.

Model fixed customer account fields as structured rows with typed columns and an enforced schema. This works because: Structured rows provide predictable columns and data types for SQL filtering and constraints. The scenario is: At Silverbrook Lending loan applications have required fields and validated numeric balances. Verify the outcome by: Insert a typed sample record and reject an incompatible value in the account number column.

C.

Use separation of duties for sensitive production database access and report publishing. This addresses a different situation: At Silverbrook Banking analysts need financial reporting without changing ledgers. The present case is: At Silverbrook Lending loan applications have required fields and validated numeric balances. The relevant action here is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

D.

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 Silverbrook Lending loan applications have required fields and validated numeric balances. The relevant action here is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

Question 6

At Silverbrook Lending loan applications have required fields and validated numeric balances. The team proposes this approach: Model fixed customer account fields as structured rows with typed columns and an enforced schema. Which technical principle explains the choice?

  1. Structured rows provide predictable columns and data types for SQL filtering and constraints.
  2. Transactional locking or optimistic concurrency detects conflicting updates before both reservations are committed.
  3. Document models naturally group related heterogeneous attributes under one item, avoiding many optional relational columns.
  4. A property absent from a record is not automatically the numeric zero or an explicitly provided empty string.

Answer & Explanations

Correct answer: A

A.

Structured rows provide predictable columns and data types for SQL filtering and constraints. This principle supports the intervention: Model fixed customer account fields as structured rows with typed columns and an enforced schema. The relevant scenario is: At Silverbrook Lending loan applications have required fields and validated numeric balances. Verify the result by: Insert a typed sample record and reject an incompatible value in the account number column.

B.

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 Silverbrook Lending loan applications have required fields and validated numeric balances. The actual mechanism is: Structured rows provide predictable columns and data types for SQL filtering and constraints.

C.

Document models naturally group related heterogeneous attributes under one item, avoiding many optional relational columns. That explains a separate situation: At Westport Marketplace sellers add changing technical specifications to listings. The current case is: At Silverbrook Lending loan applications have required fields and validated numeric balances. The actual mechanism is: Structured rows provide predictable columns and data types for SQL filtering and constraints.

D.

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 Silverbrook Lending loan applications have required fields and validated numeric balances. The actual mechanism is: Structured rows provide predictable columns and data types for SQL filtering and constraints.

Question 7

At Silverbrook Lending loan applications have required fields and validated numeric balances. After implementing this approach—Model fixed customer account fields as structured rows with typed columns and an enforced schema—which result would most directly confirm success?

  1. Have two synthetic buyers reserve the last unit and confirm at most one succeeds.
  2. Insert a typed sample record and reject an incompatible value in the account number column.
  3. Reproduce a slow sample query and identify its execution plan and owner, then verify unchanged KPI definitions.
  4. Sort test dates spanning two calendar years and verify correct chronological order.

Answer & Explanations

Correct answer: B

A.

Have two synthetic buyers reserve the last unit and confirm at most one succeeds. This tests a separate situation: At Pinehill Commerce flash-sale buyers compete for the final inventory item. The observed case is: At Silverbrook Lending loan applications have required fields and validated numeric balances. Use this acceptance check instead: Insert a typed sample record and reject an incompatible value in the account number column.

B.

Insert a typed sample record and reject an incompatible value in the account number column. This tests the targeted action: Model fixed customer account fields as structured rows with typed columns and an enforced schema. The reason is: Structured rows provide predictable columns and data types for SQL filtering and constraints. The reported case is: At Silverbrook Lending loan applications have required fields and validated numeric balances.

C.

Reproduce a slow sample query and identify its execution plan and owner, then verify unchanged KPI definitions. This tests a separate situation: At Westfield Commerce SQL latency rises after order growth. The observed case is: At Silverbrook Lending loan applications have required fields and validated numeric balances. Use this acceptance check instead: Insert a typed sample record and reject an incompatible value in the account number column.

D.

Sort test dates spanning two calendar years and verify correct chronological order. This tests a separate situation: At Birchport Finance payment dates from several regions must sort correctly. The observed case is: At Silverbrook Lending loan applications have required fields and validated numeric balances. Use this acceptance check instead: Insert a typed sample record and reject an incompatible value in the account number column.

Question 8

At Silverbrook Lending loan applications have required fields and validated numeric balances. Which shortcut most directly threatens the intended data outcome?

  1. Store every field as an unvalidated free-form string and rely on the dashboard to infer types.
  2. Split the document on every comma without respecting quoting or nested objects.
  3. Convert the analytical table to a giant untyped text file and assume scanning just one attribute costs nothing.
  4. Run full table scans against production transaction tables during the busiest sale.

Answer & Explanations

Correct answer: A

A.

Store every field as an unvalidated free-form string and rely on the dashboard to infer types. The scenario is: At Silverbrook Lending loan applications have required fields and validated numeric balances. This undermines the mechanism: Structured rows provide predictable columns and data types for SQL filtering and constraints. Instead: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

B.

Split the document on every comma without respecting quoting or nested objects. This concerns another issue: At Baycrest Software each customer has optional nested feature settings. In the stated case—At Silverbrook Lending loan applications have required fields and validated numeric balances—reject: Store every field as an unvalidated free-form string and rely on the dashboard to infer types. The safer response is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

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 Silverbrook Lending loan applications have required fields and validated numeric balances—reject: Store every field as an unvalidated free-form string and rely on the dashboard to infer types. The safer response is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

D.

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 Silverbrook Lending loan applications have required fields and validated numeric balances—reject: Store every field as an unvalidated free-form string and rely on the dashboard to infer types. The safer response is: Model fixed customer account fields as structured rows with typed columns and an enforced schema.

Question 9

At Cedarfield Commerce electronics and furniture listings carry different optional specifications. 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. Assign database backup, availability and permission maintenance to the database administrator role.
  3. Represent variable optional product attributes using semi-structured JSON documents with agreed field conventions.
  4. Evaluate consistency needs before choosing an eventually consistent read model for a business-critical state transition.

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 Cedarfield Commerce electronics and furniture listings carry different optional specifications. The relevant action here is: Represent variable optional product attributes using semi-structured JSON documents with agreed field conventions.

B.

Assign database backup, availability and permission maintenance to the database administrator role. This addresses a different situation: At Harborcrest Manufacturing a production SQL service requires tested restore procedures. The present case is: At Cedarfield Commerce electronics and furniture listings carry different optional specifications. The relevant action here is: Represent variable optional product attributes using semi-structured JSON documents with agreed field conventions.

C.

Represent variable optional product attributes using semi-structured JSON documents with agreed field conventions. This works because: JSON preserves nested named properties while allowing records to omit optional attributes without changing every table column. The scenario is: At Cedarfield Commerce electronics and furniture listings carry different optional specifications. Verify the outcome by: Parse two different catalog samples and confirm their shared and optional properties remain accessible.

D.

Evaluate consistency needs before choosing an eventually consistent read model for a business-critical state transition. This addresses a different situation: At Silvercrest Learning access to an exam subscription must change promptly after payment. The present case is: At Cedarfield Commerce electronics and furniture listings carry different optional specifications. The relevant action here is: Represent variable optional product attributes using semi-structured JSON documents with agreed field conventions.

Question 10

At Cedarfield Commerce electronics and furniture listings carry different optional specifications. The team proposes this approach: Represent variable optional product attributes using semi-structured JSON documents with agreed field conventions. Which technical principle explains the choice?

  1. Analysts model business questions and visualize trusted information after data is made available.
  2. OLAP emphasizes aggregating broad time periods and many records for business insight.
  3. Numeric columns preserve arithmetic semantics while a currency code identifies units that should not be combined blindly.
  4. JSON preserves nested named properties while allowing records to omit optional attributes without changing every table column.

Answer & Explanations

Correct answer: D

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 Cedarfield Commerce electronics and furniture listings carry different optional specifications. The actual mechanism is: JSON preserves nested named properties while allowing records to omit optional attributes without changing every table column.

B.

OLAP emphasizes aggregating broad time periods and many records for business insight. That explains a separate situation: At Silverlake Hospitality planners compare occupancy over five years. The current case is: At Cedarfield Commerce electronics and furniture listings carry different optional specifications. The actual mechanism is: JSON preserves nested named properties while allowing records to omit optional attributes without changing every table column.

C.

Numeric columns preserve arithmetic semantics while a currency code identifies units that should not be combined blindly. That explains a separate situation: At Cedarbank Travel hotel charges arrive with distinct invoice currencies. The current case is: At Cedarfield Commerce electronics and furniture listings carry different optional specifications. The actual mechanism is: JSON preserves nested named properties while allowing records to omit optional attributes without changing every table column.

D.

JSON preserves nested named properties while allowing records to omit optional attributes without changing every table column. This principle supports the intervention: Represent variable optional product attributes using semi-structured JSON documents with agreed field conventions. The relevant scenario is: At Cedarfield Commerce electronics and furniture listings carry different optional specifications. Verify the result by: Parse two different catalog samples and confirm their shared and optional properties remain accessible.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests