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

 

Question 141

Which Azure Databricks feature is used to provide centralized governance and access control for data assets?

1. Spark UI
2. Git folders
3. Cluster logs
4. Unity Catalog

Correct Answer: 4

Explanation

Unity Catalog provides centralized governance and access control for data assets across Azure Databricks. It can govern catalogs, schemas, tables, views, volumes, external locations, and other supported securable objects. Administrators can assign privileges to users, groups, and service principals according to organizational requirements. Unity Catalog also supports capabilities related to auditing and data discovery. Spark UI is primarily used for monitoring Spark execution, Git folders support source-control workflows, and cluster logs provide operational information about compute resources. Therefore, Unity Catalog is the appropriate feature when an organization needs a centralized framework for managing permissions and governance across its data environment.

Question 142

Which operation is appropriate for synchronizing records between a source dataset and a Delta target table?

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

Correct Answer: 1

Explanation

MERGE is designed to synchronize a target Delta table with a source dataset based on specified matching conditions. It can update existing records when a match is found and insert new records when there is no matching target record. Depending on the conditions, MERGE can also perform delete operations. This makes it useful for incremental data processing, change data capture, and maintaining current-state datasets. VACUUM removes obsolete files, DESCRIBE returns metadata, and OPTIMIZE improves the physical organization of table files. Therefore, MERGE is the appropriate operation when source records need to be conditionally inserted, updated, or deleted in a Delta table.

Question 143

Which feature is designed to automatically process new files arriving in cloud storage?

1. Delta Sharing
2. SQL warehouse
3. Auto Loader
4. Cluster policy

Correct Answer: 3

Explanation

Auto Loader provides scalable incremental ingestion for files arriving in cloud storage. Instead of repeatedly processing all files in a directory, Auto Loader tracks discovered files and focuses on newly arriving data. This makes it particularly useful for continuously growing file-based data sources. It can also integrate with Structured Streaming and support schema inference and supported schema evolution scenarios. Delta Sharing is intended for sharing data, SQL warehouses provide SQL compute, and cluster policies govern compute configuration. Auto Loader therefore directly addresses the requirement to automatically discover and process newly arriving files while supporting scalable data engineering pipelines.

Question 144

Which Unity Catalog object represents a collection of schemas and provides the highest level of the standard three-level namespace?

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

Correct Answer: 2

Explanation

A catalog is the highest level of the standard Unity Catalog three-level namespace. The hierarchy is typically catalog, schema, and object. A catalog can contain multiple schemas, and those schemas can contain tables, views, volumes, and other supported objects. This structure allows organizations to organize data according to business domains, environments, or governance boundaries. A volume provides governed file access, a table stores structured data, and an external location represents a governed cloud storage path. Therefore, a catalog is the correct object when the requirement is to group schemas and establish the top level of the Unity Catalog namespace.

Question 145

Which Delta Lake feature allows a user to retrieve a previous version of a table?

1. Schema evolution
2. Auto Loader
3. Partition pruning
4. Time travel

Correct Answer: 4

Explanation

Delta Lake time travel allows users to access previous versions of a table by specifying a historical version or timestamp, subject to the availability of the required transaction history and data files. This capability is useful for auditing, debugging, reproducing historical analytical results, and investigating changes to datasets. Delta Lake maintains transaction information that records changes made to the table over time. Schema evolution manages changes in table structure, Auto Loader provides incremental file ingestion, and partition pruning improves query efficiency. Therefore, time travel is the feature specifically designed to retrieve or query earlier versions of Delta table data.

Question 146

Which Structured Streaming capability helps control state retention when events arrive later than expected?

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

Correct Answer: 2

Explanation

Watermarking helps Structured Streaming manage state when events arrive late. A watermark establishes an event-time threshold that allows the streaming engine to determine how long state should be retained for late-arriving records. This is particularly important for stateful operations such as aggregations, joins, and deduplication. Once the watermark advances, older state can eventually be removed according to the operation’s semantics, helping control resource usage. Checkpoints serve a different purpose by storing streaming progress and state for recovery. Catalogs organize data assets, while volumes provide governed file access. Therefore, watermarking is the appropriate capability for managing late events and state retention.

Question 147

Which privilege allows a user to read rows from a Unity Catalog table?

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

Correct Answer: 1

Explanation

The SELECT privilege provides permission to read data from a supported Unity Catalog table. The user must also have any required parent-level permissions, such as access to the relevant catalog and schema. SELECT is specifically associated with reading data and does not by itself allow a user to modify or create objects. MODIFY is used for supported data-changing operations, CREATE TABLE permits table creation when the necessary permissions are available, and USE CATALOG provides access to a catalog namespace. Therefore, SELECT is the appropriate privilege when a user needs to query rows from an existing Unity Catalog table.

Question 148

Which operation is primarily used to compact small files and improve the physical layout of a Delta table?

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

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 because of frequent incremental writes, streaming workloads, or numerous small batch operations. A large number of small files can increase file-management overhead and negatively affect query performance. OPTIMIZE addresses this physical-layout issue without changing the logical meaning of the table’s records. GRANT manages permissions, VACUUM removes obsolete files, and SHOW GRANTS displays privilege information. Therefore, OPTIMIZE is the appropriate operation when a Delta table needs file compaction and improved physical organization.

Question 149

Which Unity Catalog object is intended for governed access to files such as CSV, JSON, images, and other non-tabular data?

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

Correct Answer: 2

Explanation

A volume provides governed access to file-based data through Unity Catalog. It can be used for files such as CSV, JSON, images, machine-learning artifacts, and other non-tabular content. Volumes allow organizations to apply centralized access controls to files while maintaining governance through Unity Catalog. A catalog provides a top-level namespace, a schema organizes objects inside a catalog, and a view contains reusable query logic. Therefore, a volume is the appropriate object when data engineers need governed access to non-tabular files. This capability is useful when file-based assets need to be managed alongside structured data within the same governed environment.

Question 150

Which Delta Lake operation removes obsolete data files according to the configured retention settings?

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

Correct Answer: 4

Explanation

VACUUM removes obsolete data files from a Delta table according to the applicable retention configuration. It is primarily a storage-maintenance operation that helps reduce the amount of unused data occupying cloud storage. VACUUM should be used carefully because historical table versions may depend on older files, and removing those files can affect time-travel availability. MERGE modifies records based on matching conditions, OPTIMIZE reorganizes and compacts data files, and SELECT reads table data. Therefore, VACUUM is the appropriate operation when the objective is to clean up obsolete Delta files while following the table’s retention requirements.

Question 151

Which approach helps ensure that a data pipeline can be safely rerun without producing duplicate business records?

1. Idempotent processing
2. Disabling checkpoints
3. Removing validation
4. Reprocessing all source files

Correct Answer: 1

Explanation

Idempotent processing ensures that executing the same input multiple times does not create unintended additional effects. This is important in data engineering because jobs may be retried after failures, files may be delivered more than once, or streaming systems may encounter temporary interruptions. Stable business keys, deduplication, MERGE operations, and appropriate checkpointing can help create idempotent pipelines. Disabling checkpoints can reduce recovery capabilities, removing validation weakens data quality, and repeatedly processing all source files can increase duplication risks. Therefore, idempotent processing is a key design principle for creating reliable data pipelines that can safely handle retries and repeated input.

Question 152

Which architecture pattern commonly uses Bronze, Silver, and Gold layers to progressively refine data?

1. Star schema
2. Client-server architecture
3. Medallion architecture
4. Hub-and-spoke architecture

Correct Answer: 3

Explanation

The medallion architecture organizes data into progressively refined layers commonly called Bronze, Silver, and Gold. Bronze generally contains raw or minimally processed source data. Silver applies cleansing, validation, standardization, and deduplication. Gold contains curated and business-ready datasets designed for reporting, analytics, and downstream consumption. This approach helps separate ingestion from transformation and business use while improving maintainability and traceability. A star schema is a dimensional modeling approach, while client-server and hub-and-spoke architectures address different system structures. Therefore, the medallion architecture is the pattern associated with progressively refining raw data into cleaned and business-ready datasets.

Question 153

Which feature can restrict the values displayed in a sensitive column based on the user’s access rights?

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

Correct Answer: 4

Explanation

Column masking provides a way to control how sensitive values are presented to users. A configured masking policy can allow authorized users to see the original value while returning a masked or transformed value to users who should not have direct access to the sensitive information. This is useful for protecting personal, financial, or confidential business data while keeping the underlying table available for broader analytical workloads. Partition pruning and file compaction are performance-related techniques, while Auto Loader handles incremental ingestion. Therefore, column masking is the appropriate feature when access requirements differ for sensitive values stored within the same column.

Question 154

Which Unity Catalog privilege is used to access a schema namespace?

1. USE SCHEMA
2. SELECT
3. MODIFY
4. READ VOLUME

Correct Answer: 1

Explanation

USE SCHEMA provides access to a schema namespace in Unity Catalog. It is generally required when users need to work with tables, views, volumes, or other objects contained within that schema, along with the necessary permissions on the parent catalog and individual objects. SELECT grants read access to supported data objects, MODIFY provides supported data-changing permissions, and READ VOLUME provides read access to files in a volume. Unity Catalog uses hierarchical access control, so users may need privileges at multiple levels. Therefore, USE SCHEMA is the appropriate privilege when the requirement is specifically to access a schema namespace.

Question 155

Which Databricks capability can orchestrate multiple tasks and define dependencies between them?

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 multiple tasks, establish dependencies between those tasks, configure schedules or triggers, and specify retry behavior. This makes it possible to automate complex data engineering workflows in a controlled sequence. For example, an ingestion task can run before a transformation task, followed by validation and reporting tasks. Unity Catalog handles governance, Delta Sharing provides data-sharing capabilities, and external locations govern cloud storage paths. Therefore, Lakeflow Jobs is the appropriate capability when a data engineering solution requires automated task orchestration and dependency management.

Question 156

Which feature allows a Structured Streaming query to apply custom processing logic to each micro-batch?

1. OPTIMIZE
2. VACUUM
3. foreachBatch
4. GRANT

Correct Answer: 3

Explanation

foreachBatch allows custom logic to be executed against each micro-batch generated by a Structured Streaming query. This provides flexibility when a streaming workload needs to use batch-oriented processing logic or interact with a destination that is more naturally handled through batch operations. A common example is applying custom logic or performing a Delta MERGE for each micro-batch. OPTIMIZE manages Delta file organization, VACUUM removes obsolete files, and GRANT manages permissions. Therefore, foreachBatch is the appropriate Structured Streaming feature when custom processing needs to be applied separately to each micro-batch while maintaining the overall streaming workflow.

Question 157

Which feature allows users to access a previous state of a Delta table for auditing or troubleshooting?

1. Time travel
2. Auto Loader
3. Cluster policy
4. Volume

Correct Answer: 1

Explanation

Time travel allows users to query or inspect previous states of a Delta table using historical versions or timestamps, subject to retention and file availability. It can be useful for auditing changes, troubleshooting unexpected results, reproducing previous analyses, and investigating how table contents changed over time. Delta Lake maintains transaction history that records changes to the table, enabling historical access when the required files remain available. Auto Loader is used for incremental file ingestion, cluster policies govern compute configuration, and volumes provide governed file access. Therefore, time travel is the appropriate feature for accessing historical states of Delta table data.

Question 158

Which feature can help standardize and restrict the configuration options available when users create Databricks compute resources?

1. Materialized view
2. Cluster policy
3. Time travel
4. Auto Loader

Correct Answer: 4

Explanation

Cluster policies allow administrators to control and standardize compute configuration settings in Azure Databricks. A policy can restrict values or define permitted ranges for settings such as runtime versions, node types, autoscaling parameters, and other supported compute options. This helps organizations maintain consistent configurations and enforce operational or governance requirements. Materialized views manage maintained query results, time travel provides historical Delta table access, and Auto Loader handles incremental file ingestion. Therefore, cluster policies are the appropriate feature when administrators need to control how users configure and provision Databricks compute resources.

Question 159

Which Spark operation redistributes data across partitions and can change the number of partitions in a DataFrame?

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

Correct Answer: 3

Explanation

REPARTITION redistributes records across Spark partitions and can increase or decrease the number of partitions according to the specified configuration. It generally involves a shuffle, which means data can move between executors. This can be useful when a workload needs a different level of parallelism or a more suitable partition distribution before subsequent transformations or joins. COALESCE can reduce the number of partitions with less shuffling in appropriate situations, while CACHE stores computed results and VACUUM manages obsolete Delta files. Therefore, REPARTITION is the appropriate Spark operation when the requirement is to redistribute data and explicitly control partition count.

Question 160

Which capability can be used to inspect the privileges assigned to users or groups on a Unity Catalog object?

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

Correct Answer: 2

Explanation

SHOW GRANTS can display privileges assigned to principals on supported Unity Catalog securable objects. It is useful for administrators and data engineers who need to verify access permissions, troubleshoot authorization problems, or audit how privileges have been assigned. Unity Catalog uses a hierarchical permission model, so inspecting grants at relevant catalog, schema, table, volume, or other object levels can help identify why a user can or cannot perform an operation. OPTIMIZE improves Delta file organization, VACUUM removes obsolete files, and MERGE changes table records. Therefore, SHOW GRANTS is the appropriate capability for inspecting assigned Unity Catalog permissions.