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 60

Question 590

At Silverfield Commerce retail branches generate uneven volumes of key-value updates. The team proposes this approach: Pick sensible partition keys for Table Storage based on common access patterns and partition distribution. Which technical principle explains the choice?

  1. Partition keys determine entity grouping and affect efficient lookup and potential hot partitions.
  2. Archived blob data requires rehydration before normal online access and has special retention/cost constraints.
  3. Cosmos DB automatically indexes data under its policy; excluding unnecessary paths can reduce index maintenance for writes.
  4. SAS credentials can grant defined resource operations and expiry without granting the recipient broad storage account administration.

Answer & Explanations

Correct answer: A

A.

Partition keys determine entity grouping and affect efficient lookup and potential hot partitions. This principle supports the intervention: Pick sensible partition keys for Table Storage based on common access patterns and partition distribution. The relevant scenario is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates. Verify the result by: Query one tenant's fictional records by partition and row key while measuring request behavior.

B.

Archived blob data requires rehydration before normal online access and has special retention/cost constraints. That explains a separate situation: At Cedarbank Records files legally retained for a decade are rarely requested. The current case is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates. The actual mechanism is: Partition keys determine entity grouping and affect efficient lookup and potential hot partitions.

C.

Cosmos DB automatically indexes data under its policy; excluding unnecessary paths can reduce index maintenance for writes. That explains a separate situation: At Silvercrest Logistics rapid telemetry writes rarely query most optional JSON properties. The current case is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates. The actual mechanism is: Partition keys determine entity grouping and affect efficient lookup and potential hot partitions.

D.

SAS credentials can grant defined resource operations and expiry without granting the recipient broad storage account administration. That explains a separate situation: At Silverlake Media a partner needs temporary read access to one approved asset. The current case is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates. The actual mechanism is: Partition keys determine entity grouping and affect efficient lookup and potential hot partitions.

Question 591

At Silverfield Commerce retail branches generate uneven volumes of key-value updates. After implementing this approach—Pick sensible partition keys for Table Storage based on common access patterns and partition distribution—which result would most directly confirm success?

  1. Query one tenant's fictional records by partition and row key while measuring request behavior.
  2. Create test objects with different prefixes and verify only the approved eligible prefix changes tier.
  3. Attempt a controlled deletion of a test retained object and verify policy prevents it.
  4. Compare a representative query and insert workload before and after adjusting a test indexing policy.

Answer & Explanations

Correct answer: A

A.

Query one tenant's fictional records by partition and row key while measuring request behavior. This tests the targeted action: Pick sensible partition keys for Table Storage based on common access patterns and partition distribution. The reason is: Partition keys determine entity grouping and affect efficient lookup and potential hot partitions. The reported case is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates.

B.

Create test objects with different prefixes and verify only the approved eligible prefix changes tier. This tests a separate situation: At Westlake Finance statement exports move from hot to cool after an approved interval. The observed case is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates. Use this acceptance check instead: Query one tenant's fictional records by partition and row key while measuring request behavior.

C.

Attempt a controlled deletion of a test retained object and verify policy prevents it. This tests a separate situation: At Harborland Securities trade evidence requires enforced retention. The observed case is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates. Use this acceptance check instead: Query one tenant's fictional records by partition and row key while measuring request behavior.

D.

Compare a representative query and insert workload before and after adjusting a test indexing policy. This tests a separate situation: At Silvercrest Logistics rapid telemetry writes rarely query most optional JSON properties. The observed case is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates. Use this acceptance check instead: Query one tenant's fictional records by partition and row key while measuring request behavior.

Question 592

At Silverfield Commerce retail branches generate uneven volumes of key-value updates. Which shortcut most directly threatens the intended data outcome?

  1. Assume locally redundant copies within one site protect against every regional disaster.
  2. Assume a relational T-SQL stored procedure runs unchanged against every Cosmos DB API.
  3. Put daily application assets directly into archive tier to minimize storage price alone.
  4. Put all high-volume independent tenants into one constant partition key without considering load.

Answer & Explanations

Correct answer: D

A.

Assume locally redundant copies within one site protect against every regional disaster. This concerns another issue: At Cedarbank Payments retained transaction exports require defined regional resilience. In the stated case—At Silverfield Commerce retail branches generate uneven volumes of key-value updates—reject: Put all high-volume independent tenants into one constant partition key without considering load. The safer response is: Pick sensible partition keys for Table Storage based on common access patterns and partition distribution.

B.

Assume a relational T-SQL stored procedure runs unchanged against every Cosmos DB API. This concerns another issue: At Cedarfield Apps developers build a new JSON-first profile service. In the stated case—At Silverfield Commerce retail branches generate uneven volumes of key-value updates—reject: Put all high-volume independent tenants into one constant partition key without considering load. The safer response is: Pick sensible partition keys for Table Storage based on common access patterns and partition distribution.

C.

Put daily application assets directly into archive tier to minimize storage price alone. This concerns another issue: At Pinefield Retail product images are fetched continuously by shoppers. In the stated case—At Silverfield Commerce retail branches generate uneven volumes of key-value updates—reject: Put all high-volume independent tenants into one constant partition key without considering load. The safer response is: Pick sensible partition keys for Table Storage based on common access patterns and partition distribution.

D.

Put all high-volume independent tenants into one constant partition key without considering load. The scenario is: At Silverfield Commerce retail branches generate uneven volumes of key-value updates. The likely failure is: A hotspot reduces throughput and query efficiency. Instead: Pick sensible partition keys for Table Storage based on common access patterns and partition distribution.

Question 593

At Oakridge Analytics Spark jobs work with folder-based lake partitions. Which design or Azure data approach best fits this requirement?

  1. Use a time-bounded, narrowly scoped shared access signature when temporary Blob Storage access is required.
  2. Pick sensible partition keys for Table Storage based on common access patterns and partition distribution.
  3. Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.
  4. Apply time-to-live settings to automatically expire Cosmos DB items when the application's retention policy permits deletion.

Answer & Explanations

Correct answer: C

A.

Use a time-bounded, narrowly scoped shared access signature when temporary Blob Storage access is required. This addresses a different situation: At Silverlake Media a partner needs temporary read access to one approved asset. The present case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. The relevant action here is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

B.

Pick sensible partition keys for Table Storage based on common access patterns and partition distribution. This addresses a different situation: At Pineport Logistics each region has a large independent group of shipment metadata records. The present case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. The relevant action here is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

C.

Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it. This works because: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes. The scenario is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. Verify the outcome by: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

D.

Apply time-to-live settings to automatically expire Cosmos DB items when the application's retention policy permits deletion. This addresses a different situation: At Pinebank Services temporary user sessions must disappear after a defined window. The present case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. The relevant action here is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

Question 594

At Oakridge Analytics Spark jobs work with folder-based lake partitions. The team proposes this approach: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it. Which technical principle explains the choice?

  1. A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes.
  2. Container or item TTL can remove expired records according to the configured lifetime and policy.
  3. Partition keys determine entity grouping and affect efficient lookup and potential hot partitions.
  4. Archived blob data requires rehydration before normal online access and has special retention/cost constraints.

Answer & Explanations

Correct answer: A

A.

A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes. This principle supports the intervention: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it. The relevant scenario is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. Verify the result by: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

B.

Container or item TTL can remove expired records according to the configured lifetime and policy. That explains a separate situation: At Pinebank Services temporary user sessions must disappear after a defined window. The current case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. The actual mechanism is: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes.

C.

Partition keys determine entity grouping and affect efficient lookup and potential hot partitions. That explains a separate situation: At Pineport Logistics each region has a large independent group of shipment metadata records. The current case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. The actual mechanism is: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes.

D.

Archived blob data requires rehydration before normal online access and has special retention/cost constraints. That explains a separate situation: At Cedarbank Records files legally retained for a decade are rarely requested. The current case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. The actual mechanism is: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes.

Question 595

At Oakridge Analytics Spark jobs work with folder-based lake partitions. After implementing this approach—Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it—which result would most directly confirm success?

  1. Update a fictional order item and verify the consumer receives the change once under idempotent processing.
  2. Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.
  3. Retrieve an older fictional monthly report directly and compare total expected storage and read costs.
  4. Upload and retrieve a synthetic image while an unauthenticated test request is denied by policy.

Answer & Explanations

Correct answer: B

A.

Update a fictional order item and verify the consumer receives the change once under idempotent processing. This tests a separate situation: At Harborview Retail inventory changes feed a search-index updater. The observed case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. Use this acceptance check instead: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

B.

Organize fictional partitioned data under dated directories and verify directory-level move or access behavior. This tests the targeted action: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it. The reason is: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes. The reported case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions.

C.

Retrieve an older fictional monthly report directly and compare total expected storage and read costs. This tests a separate situation: At Silverbridge Insurance last year's claim attachments are accessed only occasionally. The observed case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. Use this acceptance check instead: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

D.

Upload and retrieve a synthetic image while an unauthenticated test request is denied by policy. This tests a separate situation: At Harborcrest Media hundreds of thousands of images need private object storage. The observed case is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. Use this acceptance check instead: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

Question 596

At Oakridge Analytics Spark jobs work with folder-based lake partitions. Which shortcut most directly threatens the intended data outcome?

  1. Assume a single-region local file database automatically delivers globally distributed consistency.
  2. Replace an SMB-dependent application's shared drive with a blob URL and expect identical file-lock behavior.
  3. Assume every rare-access object must be archived offline even when prompt retrieval is required.
  4. Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace.

Answer & Explanations

Correct answer: D

A.

Assume a single-region local file database automatically delivers globally distributed consistency. This concerns another issue: At Silverbrook Commerce customers in several continents update shopping preferences. In the stated case—At Oakridge Analytics Spark jobs work with folder-based lake partitions—reject: Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace. The safer response is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

B.

Replace an SMB-dependent application's shared drive with a blob URL and expect identical file-lock behavior. This concerns another issue: At Meadowfield Accounting two virtual machines share legacy report files through SMB. In the stated case—At Oakridge Analytics Spark jobs work with folder-based lake partitions—reject: Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace. The safer response is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

C.

Assume every rare-access object must be archived offline even when prompt retrieval is required. This concerns another issue: At Silverbridge Insurance last year's claim attachments are accessed only occasionally. In the stated case—At Oakridge Analytics Spark jobs work with folder-based lake partitions—reject: Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace. The safer response is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

D.

Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace. The scenario is: At Oakridge Analytics Spark jobs work with folder-based lake partitions. The likely failure is: Data engineering workflows may fail during partition maintenance. Instead: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

Question 597

At Cedarwood Research governed raw data is organized by project and ingestion date. Which design or Azure data approach best fits this requirement?

  1. Store large binary images and backups as blobs in Azure Blob Storage with appropriate container access policies.
  2. Apply least-privilege Azure RBAC and data-plane permissions to private storage containers.
  3. Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.
  4. Evaluate the Cosmos DB API for MongoDB when an existing application depends on supported MongoDB drivers and query behaviors.

Answer & Explanations

Correct answer: C

A.

Store large binary images and backups as blobs in Azure Blob Storage with appropriate container access policies. This addresses a different situation: At Harborcrest Media hundreds of thousands of images need private object storage. The present case is: At Cedarwood Research governed raw data is organized by project and ingestion date. The relevant action here is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

B.

Apply least-privilege Azure RBAC and data-plane permissions to private storage containers. This addresses a different situation: At Meadowcrest Banking one analytics service reads a restricted statements container. The present case is: At Cedarwood Research governed raw data is organized by project and ingestion date. The relevant action here is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

C.

Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it. This works because: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes. The scenario is: At Cedarwood Research governed raw data is organized by project and ingestion date. Verify the outcome by: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

D.

Evaluate the Cosmos DB API for MongoDB when an existing application depends on supported MongoDB drivers and query behaviors. This addresses a different situation: At Harborpoint Software an existing document app uses MongoDB clients. The present case is: At Cedarwood Research governed raw data is organized by project and ingestion date. The relevant action here is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

Question 598

At Cedarwood Research governed raw data is organized by project and ingestion date. The team proposes this approach: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it. Which technical principle explains the choice?

  1. The NoSQL API addresses JSON items through containers, partition keys and the service's own query model.
  2. Management-plane roles and data-access permissions do not automatically mean the same thing, so users need appropriate scoped data access.
  3. Cooler online tiers reduce capacity cost when data is seldom read, subject to minimum duration and access charges.
  4. A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes.

Answer & Explanations

Correct answer: D

A.

The NoSQL API addresses JSON items through containers, partition keys and the service's own query model. That explains a separate situation: At Cedarfield Apps developers build a new JSON-first profile service. The current case is: At Cedarwood Research governed raw data is organized by project and ingestion date. The actual mechanism is: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes.

B.

Management-plane roles and data-access permissions do not automatically mean the same thing, so users need appropriate scoped data access. That explains a separate situation: At Meadowcrest Banking one analytics service reads a restricted statements container. The current case is: At Cedarwood Research governed raw data is organized by project and ingestion date. The actual mechanism is: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes.

C.

Cooler online tiers reduce capacity cost when data is seldom read, subject to minimum duration and access charges. That explains a separate situation: At Silverbridge Insurance last year's claim attachments are accessed only occasionally. The current case is: At Cedarwood Research governed raw data is organized by project and ingestion date. The actual mechanism is: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes.

D.

A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes. This principle supports the intervention: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it. The relevant scenario is: At Cedarwood Research governed raw data is organized by project and ingestion date. Verify the result by: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

Question 599

At Cedarwood Research governed raw data is organized by project and ingestion date. After implementing this approach—Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it—which result would most directly confirm success?

  1. Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.
  2. Attempt a controlled deletion of a test retained object and verify policy prevents it.
  3. Mount a synthetic file share from two approved hosts and verify both can read a test document.
  4. Insert a fictional JSON profile and execute a supported Cosmos DB for NoSQL query over its fields.

Answer & Explanations

Correct answer: A

A.

Organize fictional partitioned data under dated directories and verify directory-level move or access behavior. This tests the targeted action: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it. The reason is: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes. The reported case is: At Cedarwood Research governed raw data is organized by project and ingestion date.

B.

Attempt a controlled deletion of a test retained object and verify policy prevents it. This tests a separate situation: At Harborland Securities trade evidence requires enforced retention. The observed case is: At Cedarwood Research governed raw data is organized by project and ingestion date. Use this acceptance check instead: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

C.

Mount a synthetic file share from two approved hosts and verify both can read a test document. This tests a separate situation: At Meadowfield Accounting two virtual machines share legacy report files through SMB. The observed case is: At Cedarwood Research governed raw data is organized by project and ingestion date. Use this acceptance check instead: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

D.

Insert a fictional JSON profile and execute a supported Cosmos DB for NoSQL query over its fields. This tests a separate situation: At Cedarfield Apps developers build a new JSON-first profile service. The observed case is: At Cedarwood Research governed raw data is organized by project and ingestion date. Use this acceptance check instead: Organize fictional partitioned data under dated directories and verify directory-level move or access behavior.

Question 600

At Cedarwood Research governed raw data is organized by project and ingestion date. Which shortcut most directly threatens the intended data outcome?

  1. Re-export the entire container for every notification and assume no duplicate updates can occur.
  2. Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace.
  3. Put daily application assets directly into archive tier to minimize storage price alone.
  4. Put all high-volume independent tenants into one constant partition key without considering load.

Answer & Explanations

Correct answer: B

A.

Re-export the entire container for every notification and assume no duplicate updates can occur. This concerns another issue: At Harborview Retail inventory changes feed a search-index updater. In the stated case—At Cedarwood Research governed raw data is organized by project and ingestion date—reject: Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace. The safer response is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

B.

Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace. The scenario is: At Cedarwood Research governed raw data is organized by project and ingestion date. This undermines the mechanism: A hierarchical namespace supports file and directory-oriented operations that differ from flat blob-name prefixes. Instead: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

C.

Put daily application assets directly into archive tier to minimize storage price alone. This concerns another issue: At Pinefield Retail product images are fetched continuously by shoppers. In the stated case—At Cedarwood Research governed raw data is organized by project and ingestion date—reject: Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace. The safer response is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

D.

Put all high-volume independent tenants into one constant partition key without considering load. This concerns another issue: At Pineport Logistics each region has a large independent group of shipment metadata records. In the stated case—At Cedarwood Research governed raw data is organized by project and ingestion date—reject: Assume every normal blob prefix has exactly the same atomic directory operations as a hierarchical namespace. The safer response is: Enable hierarchical namespace for Azure Data Lake Storage Gen2 when directory semantics and analytics engines require it.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests