View Full Microsoft DP-750 Exam Dumps and Practice Test Dumps.

 

Question 181

Which Azure Databricks feature provides centralized governance for data and AI assets across workspaces?

1. Unity Catalog
2. Auto Loader
3. Spark UI
4. Cluster policy

Correct Answer: 1

Explanation

Unity Catalog provides centralized governance for supported data and AI assets across Azure Databricks environments. It enables administrators to manage permissions for catalogs, schemas, tables, views, volumes, external locations, and other securable objects. This centralized approach helps organizations apply consistent access-control policies and improve visibility into governed assets. Unity Catalog can also support auditing and data discovery requirements. Auto Loader is focused on incremental file ingestion, Spark UI is used for monitoring Spark execution, and cluster policies control compute configurations. Therefore, Unity Catalog is the appropriate feature when centralized governance and access management are required across Databricks workspaces.

Question 182

Which feature enables incremental ingestion of newly arriving files from cloud storage?

1. Time travel
2. Auto Loader
3. OPTIMIZE
4. Column masking

Correct Answer: 2

Explanation

Auto Loader is designed for scalable incremental ingestion of files that arrive in cloud storage. Instead of repeatedly processing an entire directory, it tracks files that have already been discovered and focuses on newly arriving data. This makes it particularly useful for continuously growing file-based sources. Auto Loader can work with Structured Streaming and supports capabilities such as schema inference and supported schema evolution scenarios. Time travel provides historical Delta table access, OPTIMIZE improves Delta file organization, and column masking protects sensitive values. Therefore, Auto Loader is the appropriate capability when a data pipeline needs to automatically discover and process newly arriving files.

Question 183

Which Delta Lake capability allows a data engineer to access an earlier version of a table?

1. Time travel
2. Auto Loader
3. Watermarking
4. Partition pruning

Correct Answer: 1

Explanation

Time travel allows users to query or inspect earlier versions of a Delta table by using historical versions or timestamps, subject to the availability of transaction history and required data files. This capability can support auditing, troubleshooting, reproducibility, and investigation of historical data changes. Delta Lake maintains transaction information that records modifications to the table, which makes historical versions accessible when retention requirements have not removed the necessary files. Auto Loader manages file ingestion, watermarking handles late-arriving streaming data, and partition pruning improves query efficiency. Therefore, time travel is the feature specifically intended for accessing previous states of Delta table data.

Question 184

Which Structured Streaming capability helps limit the amount of state retained for late-arriving events?

1. Checkpoint
2. Volume
3. Watermark
4. Catalog

Correct Answer: 3

Explanation

A watermark helps Structured Streaming manage state associated with events that arrive later than their expected event time. It establishes an event-time threshold that allows the streaming engine to determine how long state should be retained for certain stateful operations. This is useful for aggregations, joins, and deduplication workloads where delayed events can otherwise cause state to grow continuously. Checkpoints serve a different purpose by recording streaming progress and recovery information. Volumes provide governed access to files, while catalogs organize governed data assets. Therefore, watermarking is the appropriate capability when the objective is to control state retention while processing late-arriving streaming events.

Question 185

Which Delta Lake operation is used to synchronize a target table with source records using matching conditions?

1. VACUUM
2. MERGE
3. OPTIMIZE
4. DESCRIBE

Correct Answer: 2

Explanation

MERGE allows a source dataset to be synchronized with a target Delta table according to a specified matching condition. When a source record matches a target record, the operation can update the target. When no match exists, the source record can be inserted. Appropriate conditions can also support delete actions. This makes MERGE particularly useful for incremental data processing, change data capture, and maintaining current-state tables. VACUUM removes obsolete files, OPTIMIZE improves physical file organization, and DESCRIBE provides metadata information. Therefore, MERGE is the appropriate operation when a pipeline needs to apply conditional inserts, updates, or deletes to a Delta target.

Question 186

Which feature records the progress and state of a Structured Streaming query for recovery?

1. Checkpoint
2. Schema evolution
3. Time travel
4. Volume

Correct Answer: 1

Explanation

A checkpoint stores progress and state information for a Structured Streaming query. If the streaming workload fails or is restarted, the checkpoint allows processing to continue from the recorded state rather than treating all available input as completely new. Checkpointing is especially important for stateful streaming operations and reliable incremental processing. The checkpoint location should be persistent and associated appropriately with the streaming query. Schema evolution handles changes in incoming data structure, time travel provides historical Delta versions, and volumes provide governed file access. Therefore, checkpointing is the feature responsible for preserving streaming progress and supporting recovery after interruptions.

Question 187

Which architecture organizes data into Bronze, Silver, and Gold layers?

1. Star schema
2. Medallion architecture
3. Client-server architecture
4. Event-driven architecture

Correct Answer: 2

Explanation

The medallion architecture organizes data into progressively refined layers, commonly known as Bronze, Silver, and Gold. Bronze generally contains raw or minimally processed source data. Silver applies cleansing, validation, standardization, and deduplication to create more reliable datasets. Gold contains curated data intended for reporting, analytics, and downstream business use. This layered approach separates ingestion from transformation and business-facing consumption. A star schema is a dimensional modeling technique, while client-server and event-driven architectures describe broader application or system patterns. Therefore, the medallion architecture is the appropriate design when a data platform needs clearly separated raw, refined, and curated data layers.

Question 188

Which Unity Catalog privilege allows a principal to access a catalog namespace?

1. SELECT
2. MODIFY
3. CREATE TABLE
4. USE CATALOG

Correct Answer: 4

Explanation

USE CATALOG provides access to a catalog namespace in Unity Catalog. It is generally required before users can work with schemas and objects contained within that catalog, along with the appropriate permissions at lower levels. SELECT grants read access to supported data objects, MODIFY provides supported data-changing permissions, and CREATE TABLE controls table creation when the required parent permissions are available. Unity Catalog uses hierarchical permissions, so users may need access at the catalog, schema, and object levels depending on the operation. Therefore, USE CATALOG is the appropriate privilege when the requirement is access to a catalog namespace.

Question 189

Which feature can protect sensitive column values by returning different representations to different users?

1. Column masking
2. Partition pruning
3. Auto Loader
4. File compaction

Correct Answer: 1

Explanation

Column masking can protect sensitive values by applying rules that determine what different users are allowed to see. Authorized users may receive the original value, while users without the required access can receive a masked or transformed representation. This provides fine-grained data protection without requiring separate copies of the entire dataset for different audiences. Partition pruning improves query efficiency, Auto Loader manages incremental file ingestion, and file compaction improves physical storage organization. Therefore, column masking is the appropriate feature when a data engineer needs to restrict visibility of sensitive column values based on authorization or user context.

Question 190

Which operation is used to compact small Delta files and improve the physical organization of table data?

1. SHOW GRANTS
2. VACUUM
3. OPTIMIZE
4. MERGE

Correct Answer: 3

Explanation

OPTIMIZE improves the physical organization of Delta table data and can compact multiple small files into fewer larger files. Small files can accumulate through frequent writes, streaming workloads, or many small batch operations. A high number of small files can increase file-management overhead and negatively affect query performance. OPTIMIZE addresses this physical layout issue without changing the logical purpose of the table. SHOW GRANTS displays permissions, VACUUM removes obsolete files, and MERGE synchronizes records between source and target datasets. Therefore, OPTIMIZE is the appropriate operation when the goal is to reduce small-file overhead and improve Delta table file organization.

Question 191

Which Unity Catalog object is intended for governed access to non-tabular files?

1. Schema
2. Volume
3. Catalog
4. View

Correct Answer: 2

Explanation

A volume provides governed access to files through Unity Catalog. It is useful for non-tabular content such as CSV files, JSON documents, images, machine-learning artifacts, and other file-based data. Volumes allow organizations to apply centralized permissions and governance to these files while keeping them within the Databricks data-management framework. A schema organizes objects within a catalog, a catalog provides a higher-level namespace, and a view stores reusable query logic. Therefore, a volume is the appropriate Unity Catalog object when users need governed access to files that are not necessarily represented as relational tables.

Question 192

Which Delta Lake maintenance operation removes obsolete files according to retention settings?

1. MERGE
2. SELECT
3. OPTIMIZE
4. VACUUM

Correct Answer: 4

Explanation

VACUUM removes obsolete data files from a Delta table according to applicable retention settings. It helps manage cloud-storage consumption by cleaning up files that are no longer required by the table under its retention policy. Data engineers should consider the effect of file removal on historical access because time travel can depend on older files remaining available. MERGE changes records, SELECT reads table data, and OPTIMIZE reorganizes and compacts files. Therefore, VACUUM is the appropriate maintenance operation when the requirement is to remove obsolete Delta files while respecting the table’s configured retention behavior.

Question 193

Which design principle helps ensure that retrying a pipeline does not create unintended duplicate records?

1. Idempotent processing
2. Removing checkpoints
3. Increasing file count
4. Disabling validation

Correct Answer: 1

Explanation

Idempotent processing means that processing the same input multiple times produces the same intended result rather than creating additional unintended effects. This is important for reliable data pipelines because workloads can fail and be retried, source systems can resend data, and streaming applications can encounter temporary interruptions. Stable keys, deduplication logic, MERGE operations, and suitable checkpoint management can contribute to an idempotent design. Removing checkpoints can weaken streaming recovery, increasing file count does not address duplicates, and disabling validation can reduce data quality. Therefore, idempotent processing is a fundamental design principle for building pipelines that can safely handle retries and repeated inputs.

Question 194

Which Databricks capability can define task dependencies, schedules, retries, and notifications for data workloads?

1. Unity Catalog
2. Lakeflow Jobs
3. Delta Sharing
4. External location

Correct Answer: 2

Explanation

Lakeflow Jobs provides workflow orchestration capabilities for Databricks workloads. It allows data engineers to define tasks, establish dependencies, configure schedules or triggers, set retry behavior, and configure operational notifications. This supports automated execution of multi-step data engineering pipelines. For example, an ingestion task can run first, followed by transformation, validation, and publishing tasks. Unity Catalog provides governance, Delta Sharing supports secure data sharing, and external locations govern access to cloud storage paths. Therefore, Lakeflow Jobs is the appropriate capability for orchestrating complex workloads that require task sequencing, scheduling, and operational controls.

Question 195

Which Spark operation can redistribute records and explicitly set a new number of partitions?

1. CACHE
2. REPARTITION
3. GRANT
4. VACUUM

Correct Answer: 2

Explanation

REPARTITION redistributes records across Spark partitions and can explicitly set the number of partitions for a dataset. It generally causes a shuffle, meaning records can move across executors. This can be useful when a workload requires a different level of parallelism or needs a more suitable distribution before operations such as joins or aggregations. Because shuffling can be expensive, repartitioning should be used when the expected performance or processing benefits justify the additional cost. CACHE stores computed results, GRANT manages permissions, and VACUUM removes obsolete Delta files. Therefore, REPARTITION is the appropriate operation for redistributing data and changing partition count.

Question 196

Which Structured Streaming feature allows custom logic to be executed separately for every micro-batch?

1. foreachBatch
2. Watermark
3. Checkpoint
4. Auto Loader

Correct Answer: 1

Explanation

foreachBatch allows custom processing logic to be applied to each micro-batch generated by a Structured Streaming query. This is useful when a streaming pipeline needs to perform operations that are more naturally implemented using batch-oriented logic. For example, a data engineer can use foreachBatch to apply custom transformations or perform a Delta MERGE for each micro-batch. Watermarks manage event-time state and late-arriving data, checkpoints preserve streaming progress, and Auto Loader discovers newly arriving files. Therefore, foreachBatch is the appropriate feature when custom processing needs to run independently for each micro-batch of a Structured Streaming workload.

Question 197

Which technique can reduce the amount of data scanned when a query filters on a table’s partitioning column?

1. Time travel
2. Column masking
3. Partition pruning
4. Schema evolution

Correct Answer: 3

Explanation

Partition pruning allows a query engine to skip partitions that cannot contain records matching a filter condition. For example, if a table is partitioned by date and a query requests a limited date range, unrelated partitions can potentially be excluded from the scan. This reduces the amount of data read and processed and can improve query performance. Time travel provides access to historical Delta versions, column masking controls sensitive-value visibility, and schema evolution manages structural changes. Therefore, partition pruning is the appropriate performance technique when query filters align with the table’s partitioning columns and allow unnecessary partitions to be eliminated.

Question 198

Which Unity Catalog object represents a governed cloud storage path used for external data?

1. External location
2. Volume
3. Catalog
4. View

Correct Answer: 1

Explanation

An external location represents a governed cloud storage path in Unity Catalog and is associated with a storage credential. It allows administrators to control access to external storage through Unity Catalog permissions rather than distributing storage credentials directly to individual users. External locations are commonly used with external tables and other governed data stored outside managed table storage. A volume provides governed file access, a catalog groups schemas, and a view provides reusable query logic. Therefore, an external location is the appropriate Unity Catalog object when a specific cloud storage path needs centralized governance and controlled access.

Question 199

Which feature allows a data pipeline to accommodate supported changes in the structure of incoming data?

1. Time travel
2. Schema evolution
3. VACUUM
4. Watermarking

Correct Answer: 2

Explanation

Schema evolution allows supported changes in incoming data structures to be incorporated into a data pipeline without requiring the entire ingestion process to be redesigned. A common example is a source system adding a new column to incoming records. Depending on the configuration and technology being used, schema evolution can allow the pipeline and target Delta table to adapt to such changes. Time travel provides historical table access, VACUUM removes obsolete files, and watermarking manages late-arriving streaming data. Therefore, schema evolution is the appropriate capability when the primary requirement is to handle supported structural changes in incoming datasets.

Question 200

Which command can be used to inspect privileges granted on a Unity Catalog securable object?

1. OPTIMIZE
2. MERGE
3. VACUUM
4. SHOW GRANTS

Correct Answer: 4

Explanation

SHOW GRANTS provides information about privileges assigned to users, groups, and other principals for supported Unity Catalog securable objects. It is useful when administrators or data engineers need to verify access configuration, troubleshoot authorization issues, or review governance assignments. Unity Catalog uses hierarchical permissions, so examining grants at relevant catalog, schema, table, volume, or other object levels can help identify access requirements. OPTIMIZE manages Delta file organization, MERGE applies conditional data changes, and VACUUM removes obsolete files. Therefore, SHOW GRANTS is the appropriate command when the objective is to inspect permissions assigned to a Unity Catalog object.