cert
cert-1
cert-2

Pass Microsoft DP-900 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
DP-900 Exam - Verified By Experts
DP-900 Premium Bundle
$29.98

DP-900 Premium Bundle

$79.99
$109.97
  • Premium File 332 Questions & Answers. Last update: Nov 13, 2026
  • Training Course 32 Video Lectures
  • Study Guide 672 Pages
 
$109.97
$79.99
accept 21 downloads in last 7 days
block-screenshots
Purchase Microsoft DP-900 Exam Training Products Individually
Microsoft DP-900 Premium File
Premium File 332 Q&A
$76.99$69.99
Microsoft DP-900 Video Training Course
Training Course 32 Lectures
$21.99 $19.99
Microsoft DP-900 PDF Study Guide
Study Guide 672 Pages
$21.99 $19.99
Microsoft DP-900 Practice Test 34

Question 330

Multiple reports need identical monthly revenue definitions. Which choice BEST meets this requirement?

  1. Use versioned Databricks notebooks with explicit dependencies and job orchestration.
  2. Publish a governed semantic model with shared dimensions and measures.
  3. Use a line chart with a continuous or properly sorted time axis.
  4. Assume a pretty dashboard theme defines a metric's business semantics.

Explanation

Correct Answer

B:

Semantic modeling makes reusable business meanings above source tables.

Incorrect Answers

A:

Use versioned Databricks notebooks with explicit dependencies and job orchestration. That action primarily handles Databricks collaborative notebooks; the given requirement is Semantic model over curated analytics. Semantic modeling makes reusable business meanings above source tables.

C:

Use a line chart with a continuous or properly sorted time axis. That action primarily handles Line chart time-series selection; the given requirement is Semantic model over curated analytics. Semantic modeling makes reusable business meanings above source tables.

D:

Assume a pretty dashboard theme defines a metric's business semantics. It does not implement Semantic model over curated analytics. Duplicated ad hoc measures create contradictory dashboards.

Question 331

A migration keeps an existing shared folder API without rewriting apps for object endpoints. What is the MOST appropriate next validation or correction?

  1. Call a blob URL an SMB UNC path and assume file locking works identically.
  2. Map deliverables and access permissions to accountable role owners.
  3. Test network reachability share permissions and file read/write.
  4. Validate object upload download and authorization from representative clients.

Explanation

Correct Answer

C:

Test network reachability share permissions and file read/write. This tests the intended result: authorized clients can mount the intended share and preserve folder paths.

Incorrect Answers

A:

Call a blob URL an SMB UNC path and assume file locking works identically. This unsafe shortcut leaves the Azure Files SMB shared directories problem unresolved. Choosing only Blob REST storage breaks an application requiring SMB file operations.

B:

Map deliverables and access permissions to accountable role owners. It tests Separation of data roles in a migration rather than the critical Azure Files SMB shared directories behavior. Azure Files exposes managed file shares distinct from Blob REST object storage.

D:

Validate object upload download and authorization from representative clients. It tests Azure Blob Storage for object data rather than the critical Azure Files SMB shared directories behavior. Azure Files exposes managed file shares distinct from Blob REST object storage.

Question 332

A budget has four mutually exclusive spending categories totaling 100 percent. After selecting the proper Pie donut chart proportion caution approach, which observation gives the clearest evidence of success?

  1. Approved device identities send telemetry while revoked devices are rejected.
  2. Slices sum to the intended whole and readers can compare shares.
  3. Every eligible change since prior success appears exactly as required downstream.
  4. Relative category sizes and labels are clear.

Explanation

Correct Answer

B:

Slices sum to the intended whole and readers can compare shares. This is the directly observable result for Pie donut chart proportion caution; pie-like charts express part-to-whole composition.

Incorrect Answers

A:

Approved device identities send telemetry while revoked devices are rejected. This supports Azure IoT Hub device messaging, not confirmation of Pie donut chart proportion caution. The relevant evidence is that slices sum to the intended whole and readers can compare shares.

C:

Every eligible change since prior success appears exactly as required downstream. This supports Incremental ingestion with watermark, not confirmation of Pie donut chart proportion caution. The relevant evidence is that slices sum to the intended whole and readers can compare shares.

D:

Relative category sizes and labels are clear. This supports Column chart category comparison, not confirmation of Pie donut chart proportion caution. The relevant evidence is that slices sum to the intended whole and readers can compare shares.

Question 333

A data platform must support both source files and curated dimension tables. Select TWO statements that correctly describe the Structured warehouse and unstructured lake coexistence implementation and how it can be verified.

  1. Images remain retrievable while SQL reports query approved modeled facts.
  2. Use a slicer configured with the intended field and report interactions.
  3. Use a Fabric Warehouse for supported SQL-centric analytical table operations.
  4. Use complementary file-based lake storage and relational analytics tables as needed.
  5. Store every photograph as a dimension key and delete the original media.

Explanation

Correct Answers

A:

Images remain retrievable while SQL reports query approved modeled facts. This is directly observable success evidence for Structured warehouse and unstructured lake coexistence.

D:

Use complementary file-based lake storage and relational analytics tables as needed. This is an appropriate action for the Structured warehouse and unstructured lake coexistence case. Large-scale analytics integrates multiple data formats and query models.

Incorrect Answers

B:

Use a slicer configured with the intended field and report interactions. This implements Slicer interactive filter instead of the required Structured warehouse and unstructured lake coexistence function. Large-scale analytics integrates multiple data formats and query models.

C:

Use a Fabric Warehouse for supported SQL-centric analytical table operations. This implements Fabric Warehouse relational reporting instead of the required Structured warehouse and unstructured lake coexistence function. Large-scale analytics integrates multiple data formats and query models.

E:

Store every photograph as a dimension key and delete the original media. This is not a safe or appropriate Structured warehouse and unstructured lake coexistence implementation. Forcing binary media into every warehouse fact row increases processing overhead.

Question 334

A large order table has frequent WHERE OrderID queries and slow scans. If the relevant B tree index for lookups safeguard is skipped, which failure is MOST directly associated with that omission?

  1. Ignoring lag could lose recent writes at regional failover.
  2. Ignoring transient failover errors can disrupt applications.
  3. Unnecessary indexes can slow frequent writes.
  4. Assuming views automatically encrypt their base tables misstates access protection.

Explanation

Correct Answer

C:

Unnecessary indexes can slow frequent writes. Indexes trade extra storage and write overhead for faster supported reads. A suitable check is to compare plans and update costs before and after an index.

Incorrect Answers

A:

Ignoring lag could lose recent writes at regional failover. This failure is associated with Azure SQL active geo-replication tradeoff; it is not the primary failure in the stated B tree index for lookups scenario. Indexes trade extra storage and write overhead for faster supported reads.

B:

Ignoring transient failover errors can disrupt applications. This failure is associated with Azure SQL high availability and zone resiliency; it is not the primary failure in the stated B tree index for lookups scenario. Indexes trade extra storage and write overhead for faster supported reads.

D:

Assuming views automatically encrypt their base tables misstates access protection. This failure is associated with SQL view virtual query object; it is not the primary failure in the stated B tree index for lookups scenario. Indexes trade extra storage and write overhead for faster supported reads.

Question 335

A report incorrectly orders two events near a daylight-saving transition. Select THREE statements that correctly describe the Timestamp and timezone representation implementation and how it can be verified.

  1. Ordered events represent the correct absolute instant across regions.
  2. Sort local clock strings from different time zones and claim they are globally chronological.
  3. Timestamp interpretation needs explicit timezone conventions for cross-region analysis.
  4. Normalize event instants with timezone offsets and retain needed locale context.
  5. Use Avro with compatible schema evolution rules for serialized data exchange.
  6. Evaluate latency concurrency query style and update volume before choosing a store.

Explanation

Correct Answers

A:

Ordered events represent the correct absolute instant across regions. This is directly observable success evidence for Timestamp and timezone representation.

C:

Timestamp interpretation needs explicit timezone conventions for cross-region analysis. This supports why the action and evidence together address Timestamp and timezone representation.

D:

Normalize event instants with timezone offsets and retain needed locale context. This is an appropriate action for the Timestamp and timezone representation case. Timestamp interpretation needs explicit timezone conventions for cross-region analysis.

Incorrect Answers

B:

Sort local clock strings from different time zones and claim they are globally chronological. This is not a safe or appropriate Timestamp and timezone representation implementation. Treating all naive timestamps as UTC can shift historical events.

E:

Use Avro with compatible schema evolution rules for serialized data exchange. This implements Avro schema-aware records instead of the required Timestamp and timezone representation function. Timestamp interpretation needs explicit timezone conventions for cross-region analysis.

F:

Evaluate latency concurrency query style and update volume before choosing a store. This implements Data platform read and write profiles instead of the required Timestamp and timezone representation function. Timestamp interpretation needs explicit timezone conventions for cross-region analysis.

Question 336

A report generator overwrites a valid model file with an incorrect one. After selecting the proper Blob versioning on overwrite approach, which observation gives the clearest evidence of success?

  1. A prior version is available and current version remains identifiable.
  2. Supported clients mount the share and read or write approved paths.
  3. Document reads and writes return expected JSON properties at scale.
  4. Conflicting updates follow the documented application semantics.

Explanation

Correct Answer

A:

A prior version is available and current version remains identifiable. This is the directly observable result for Blob versioning on overwrite; versioning retains historical object states independently of overwriting current contents.

Incorrect Answers

B:

Supported clients mount the share and read or write approved paths. This supports Azure Files SMB application migration, not confirmation of Blob versioning on overwrite. The relevant evidence is that a prior version is available and current version remains identifiable.

C:

Document reads and writes return expected JSON properties at scale. This supports Cosmos DB NoSQL JSON document container, not confirmation of Blob versioning on overwrite. The relevant evidence is that a prior version is available and current version remains identifiable.

D:

Conflicting updates follow the documented application semantics. This supports Cosmos DB multi-region writes conflict handling, not confirmation of Blob versioning on overwrite. The relevant evidence is that a prior version is available and current version remains identifiable.

Question 337

A team stores customer documents in a private Azure storage account. After selecting the proper Storage encryption and access controls approach, which observation gives the clearest evidence of success?

  1. Authorized clients retrieve the correct binary object using its blob address.
  2. Existing key-value entity requests function against the chosen Cosmos API.
  3. Typical reads use sensible item sizes and updates avoid unnecessary rewriting.
  4. Stored blobs are encrypted and unauthorized retrieval requests are denied.

Explanation

Correct Answer

D:

Stored blobs are encrypted and unauthorized retrieval requests are denied. This is the directly observable result for Storage encryption and access controls; encryption at rest and access authorization address different risks.

Incorrect Answers

A:

Authorized clients retrieve the correct binary object using its blob address. This supports Blob storage object and container hierarchy, not confirmation of Storage encryption and access controls. The relevant evidence is that stored blobs are encrypted and unauthorized retrieval requests are denied.

B:

Existing key-value entity requests function against the chosen Cosmos API. This supports Cosmos DB API for Table compatibility, not confirmation of Storage encryption and access controls. The relevant evidence is that stored blobs are encrypted and unauthorized retrieval requests are denied.

C:

Typical reads use sensible item sizes and updates avoid unnecessary rewriting. This supports Cosmos DB document embedded versus referenced data, not confirmation of Storage encryption and access controls. The relevant evidence is that stored blobs are encrypted and unauthorized retrieval requests are denied.

Question 338

A table has a surrogate primary key but needs a separate unique tax identifier. Which principle BEST explains the correct Unique index versus primary key design decision?

  1. SQL row order is not guaranteed without ordering clauses.
  2. A table can enforce uniqueness on nonprimary attributes.
  3. Read scale can separate query consumption from primary writes but may have replication lag.
  4. Geo-replicated SQL designs may use asynchronous replication and have possible lag.

Explanation

Correct Answer

B:

A table can enforce uniqueness on nonprimary attributes. In this case the applicable decision is to apply a UNIQUE constraint or index on the additional business key.

Incorrect Answers

A:

SQL row order is not guaranteed without ordering clauses. That concept explains SQL ORDER BY pagination stability; the situation instead concerns Unique index versus primary key. Relying solely on application checks allows races that create duplicates.

C:

Read scale can separate query consumption from primary writes but may have replication lag. That concept explains Azure SQL read scale and reporting replicas; the situation instead concerns Unique index versus primary key. Relying solely on application checks allows races that create duplicates.

D:

Geo-replicated SQL designs may use asynchronous replication and have possible lag. That concept explains Azure SQL active geo-replication tradeoff; the situation instead concerns Unique index versus primary key. Relying solely on application checks allows races that create duplicates.

Question 339

A project manager assigns database recovery and dashboards to one unreviewed role. Select THREE statements that correctly describe the Separation of data roles in a migration implementation and how it can be verified.

  1. Design intentional historical snapshots or slowly changing dimensions for analytics.
  2. Assume every person who writes SELECT is automatically accountable for all backups.
  3. Monitor database capacity connections health and alerts with response procedures.
  4. Different data roles collaborate but have distinct primary responsibilities.
  5. Database is recoverable pipelines are reliable and reports use curated facts.
  6. Allocate DBA data-engineer and data-analyst tasks according to their responsibilities.

Explanation

Correct Answers

D:

Different data roles collaborate but have distinct primary responsibilities. This supports why the action and evidence together address Separation of data roles in a migration.

E:

Database is recoverable pipelines are reliable and reports use curated facts. This is directly observable success evidence for Separation of data roles in a migration.

F:

Allocate DBA data-engineer and data-analyst tasks according to their responsibilities. This is an appropriate action for the Separation of data roles in a migration case. Different data roles collaborate but have distinct primary responsibilities.

Incorrect Answers

A:

Design intentional historical snapshots or slowly changing dimensions for analytics. This implements Historical dimensions versus current operational truth instead of the required Separation of data roles in a migration function. Different data roles collaborate but have distinct primary responsibilities.

B:

Assume every person who writes SELECT is automatically accountable for all backups. This is not a safe or appropriate Separation of data roles in a migration implementation. Confusing roles leaves important ingestion or backup tasks unowned.

C:

Monitor database capacity connections health and alerts with response procedures. This implements DBA monitoring capacity and alerts instead of the required Separation of data roles in a migration function. Different data roles collaborate but have distinct primary responsibilities.

Question 340

An online booking application requires ACID transactions and SQL joins. If the relevant Azure SQL Database managed relational app safeguard is skipped, which failure is MOST directly associated with that omission?

  1. Overpartitioning can create costly metadata operations.
  2. Treating a high-rate stream as an hourly CSV export delays detection.
  3. Moving to a document key-value store may lose required relational constraint enforcement.
  4. Choosing only Blob REST storage breaks an application requiring SMB file operations.

Explanation

Correct Answer

C:

Moving to a document key-value store may lose required relational constraint enforcement. Azure SQL Database is a managed SQL relational service. A suitable check is to test SQL queries transaction rollback and service configuration.

Incorrect Answers

A:

Overpartitioning can create costly metadata operations. This failure is associated with Data engineer partition and file layout; it is not the primary failure in the stated Azure SQL Database managed relational app scenario. Azure SQL Database is a managed SQL relational service.

B:

Treating a high-rate stream as an hourly CSV export delays detection. This failure is associated with Event streaming continual processing; it is not the primary failure in the stated Azure SQL Database managed relational app scenario. Azure SQL Database is a managed SQL relational service.

D:

Choosing only Blob REST storage breaks an application requiring SMB file operations. This failure is associated with Azure Files SMB shared directories; it is not the primary failure in the stated Azure SQL Database managed relational app scenario. Azure SQL Database is a managed SQL relational service.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests