Databricks-DE-Assoc Practice Test 3 — 30 Questions

Question 1

Refer to the exhibit. An engineer applies these configurations to a cluster. What is the primary benefit of enabling the Databricks IO Cache for a workload that involves repeatedly reading the same Delta tables?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

It speeds up repeated reads by caching data on local SSDs.. The Databricks IO Cache (also known as the disk cache) accelerates data reads by caching remote data on the local SSDs of the worker nodes. For workloads that frequently query the same tables, this eliminates the latency and network overhead of repeatedly fetching data from cloud object storage. This is particularly effective for read-heavy analytical workloads, enabling significantly faster query execution times by leveraging high-speed local disk I/O.

Answer

It enables ACID transactions for non-Delta tables.

Answer

It automatically scales the cluster based on disk usage.

Answer

It forces the cluster to store all data in memory.

Question 2

A data engineer is analyzing a Spark job that is failing with 'Out of Memory' (OOM) errors. Which configuration parameter should be tuned to increase the amount of memory allocated to the execution of joins and aggregations?

Accepted Answer

spark.memory.fraction. Spark's memory management divides heap memory into storage and execution. Joins and aggregations occur in the execution memory. When these operations process large datasets that exceed the allocated execution memory, Spark may fail with OOM. Tuning the memory fraction configuration allows the engineer to shift the balance between storage (for caching) and execution, providing more headroom for complex shuffle-heavy operations like joins and group-by aggregations.

Answer

spark.executor.cores

Answer

spark.sql.shuffle.partitions

Answer

spark.driver.memory

Question 3

Which THREE of the following are benefits of using Unity Catalog over the legacy Hive Metastore?

Accepted Answer

Support for data lineage at the column level.. Unity Catalog provides a unified, centralized governance layer that spans all workspaces, clouds, and regions. Unlike the legacy Hive Metastore, which is often siloed and lacks granular control, Unity Catalog offers robust auditing, data lineage, and simplified access management. These features are vital for modern enterprises managing complex, multi-workspace environments that require consistent security postures and comprehensive visibility into data movement and usage patterns.

Answer

Automated data replication to other cloud vendors.

Answer

Automatic hardware upgrades for all clusters.

Question 4

Which of the following is a fundamental principle of implementing effective CI/CD for Databricks workflows?

Accepted Answer

Using environment variables to manage service endpoints and authentication secrets.. Effective CI/CD requires separating code logic from environment-specific configurations. By parameterizing job settings and using environment-specific variables, teams ensure that the same code can be deployed safely across development, testing, and production. This practice minimizes errors during promotion and allows for automated testing cycles, which are essential for maintaining a robust, stable, and scalable data platform in any enterprise Databricks environment.

Answer

Deploying code from a local laptop directly to the production cluster.

Answer

Merging all development code into the main branch every few months.

Answer

Ignoring unit testing until the code is fully deployed in production.

Question 5

A data engineer is tasked with securing sensitive PII data in Unity Catalog. Which THREE actions are recommended to ensure robust security and compliance?

Accepted Answer

Apply Dynamic Data Masking to columns containing PII.. Implementing a defense-in-depth strategy is crucial for PII. Using Unity Catalog's fine-grained access controls, dynamic masking, and audit logs provides a layered approach to security. These tools allow organizations to restrict access, obscure sensitive values, and maintain a verifiable trail of who accessed what data, which is essential for meeting regulatory requirements and minimizing the risk of unauthorized data breaches.

Answer

Grant SELECT access to all users to ensure data accessibility.

Answer

Store all PII data in the root metastore directory for easy access.

Question 6

A streaming job using Structured Streaming is lagging significantly behind the 'current time'. Which THREE of the following could be the root cause of this processing latency?

Accepted Answer

The trigger interval is set to a time shorter than the processing time of the batch.. Streaming latency often stems from resource contention, inefficient state management, or micro-batch trigger configurations. When the input rate exceeds the processing rate, lag accumulates. Identifying these bottlenecks requires analyzing the Spark UI for processing time vs. batch time. Understanding these factors is vital for maintaining low-latency pipelines and ensuring that SLAs are met in production-grade streaming environments deployed on Databricks.

Answer

Using a fixed-size cluster with no auto-scaling enabled.

Answer

Using too few partitions in the input source.

Question 7

Which of the following describes the correct order of operations to configure a new external location in Unity Catalog?

Accepted Answer

Create credential, create location, grant privileges.. The process begins with creating a storage credential, which holds the cloud-specific security details (like an IAM role or service account). This credential is then used to define the external location, which points to a specific path in cloud storage. Finally, you grant the user or service the 'READ FILES' or 'WRITE FILES' privilege on the external location to permit interaction with the underlying data files within the Unity Catalog framework.

Answer

Grant privileges, create location, create credential.

Answer

Create location, grant privileges, create credential.

Answer

Create credential, grant privileges, create location.

Question 8

Refer to the exhibit. A data engineer is configuring an IAM policy for a Databricks storage credential. Which of the following is the most significant security risk in this configuration?

Accepted Answer

The policy allows access to all objects in the bucket rather than using specific prefixes.. The policy uses overly permissive resource definitions and potentially excessive actions if not scoped correctly. In production environments, adhering to the principle of least privilege is critical. Granting broad 's3:ListBucket' or 's3:GetObject' access to an entire bucket without specific prefix scoping can lead to data exfiltration risks or unauthorized access to non-production data stored in the same bucket.

Answer

The policy restricts access to only a single file.

Answer

The policy lacks an explicit 'Deny' statement for all other resources.

Answer

The policy is missing a condition to require multi-factor authentication (MFA).

Question 9

An engineer has a large table that is frequently joined with small dimension tables. To optimize this, which optimization technique should be applied to the join operation?

Accepted Answer

Use a Broadcast Hash Join.. Broadcasting small tables prevents the 'shuffle' of the larger table. By sending a copy of the dimension table to every executor, Spark can perform the join locally, significantly reducing network overhead. This is a fundamental optimization for star schemas in Databricks. Knowing when and how to force broadcast joins allows engineers to dramatically speed up analytical queries by minimizing the movement of massive datasets across the cluster network.

Answer

Implement a Shuffle Hash Join.

Answer

Increase the number of shuffle partitions.

Answer

Enable Z-Ordering on the join key.

Question 10

Which component of Databricks CI/CD is responsible for executing automated tests on code before it is merged into the main branch?

Accepted Answer

The CI/CD runner (e.g., GitHub Actions, Jenkins).. CI/CD runners or build servers (like GitHub Actions, GitLab CI, or Jenkins) are the components responsible for triggering automated testing. By running tests in an isolated environment during the pull request process, these tools ensure that only validated code is merged. This 'fail-fast' approach is critical for maintaining code quality, reducing regression risks, and providing developers with immediate feedback on their changes before they ever impact the production pipeline.

Answer

The Databricks Delta Lake storage layer.

Answer

The Unity Catalog governance framework.

Answer

The Databricks SQL Warehouse.

Question 11

Refer to the exhibit. A data engineer encounters this error while trying to list tables in a schema. Based on the error, what must the engineer do to resolve it?

Accepted Answer

Grant 'USE CATALOG' privilege on the catalog to the user.. The error indicates that the user lacks the 'USE CATALOG' privilege, which is the foundational permission required to even browse objects within a specific catalog in Unity Catalog. This is a critical concept because Unity Catalog enforces a hierarchical security model where access must be granted from the root down to the table level, ensuring that users cannot bypass organizational security boundaries by guessing table names or paths.

Answer

Grant 'SELECT' privilege on the table to the user.

Answer

Increase the cluster's worker node count.

Answer

Upgrade the workspace to the Premium tier.

Question 12

When designing an ingestion strategy for a Delta Lake architecture, which TWO advantages does Delta Lake provide over traditional Parquet tables for incoming data?

Accepted Answer

ACID transactions ensure partial writes do not occur during failures.. Delta Lake enhances the standard Parquet format by adding a transaction log that enables ACID compliance and efficient metadata handling. These features are vital for ingestion as they prevent data corruption and allow for advanced operations like schema evolution and time travel, which are not possible with standard Parquet files on cloud storage.

Answer

Native support for sub-second streaming latency from any source.

Answer

Automatic indexing of all string columns for faster search queries.

Answer

Support for data encryption at rest using proprietary algorithms.

Question 13

A data engineer is evaluating whether to use Auto Loader or the COPY INTO command for a new ingestion pipeline. Which TWO features are unique to Auto Loader compared to COPY INTO?

Accepted Answer

Native support for schema evolution through schemaEvolutionMode.. Auto Loader and COPY INTO both offer idempotent loading, but Auto Loader is built on Structured Streaming. This allows it to provide more advanced features like automatic schema evolution and a notification mode that uses cloud services to detect new files. Understanding these differences is crucial for selecting the right tool based on volume and schema complexity.

Answer

The ability to perform incremental loads by tracking processed files.

Answer

Support for ingesting data from cloud object storage like S3 or ADLS.

Answer

Requirement for a Delta Lake table as the final destination.

Question 14

A data engineer is designing a pipeline on Databricks to process streaming data. Which architectural component acts as the unified storage layer, allowing both batch and streaming workloads to access the same underlying data files in a data lake?

Accepted Answer

Delta Lake. The Databricks Intelligence Platform leverages the Lakehouse architecture, which combines the best elements of data lakes and data warehouses. Delta Lake is the critical component that sits on top of object storage, providing ACID transactions, schema enforcement, and time travel. By using Delta Lake, the platform ensures that data consistency is maintained across concurrent streaming and batch processes, which is fundamental for reliable data engineering at scale.

Answer

Unity Catalog

Answer

Databricks SQL

Answer

Photon Engine

Question 15

When using Auto Loader to ingest data, why is it recommended to provide a 'schemaLocation' rather than manually defining the entire schema in the code?

Accepted Answer

To allow Auto Loader to persist and evolve the schema over time.. Auto Loader uses the schemaLocation to store inferred schemas and track changes over time. This allows for schema inference and evolution, which are critical for handling unpredictable data sources. Without this location, the stream cannot persist the state of the schema, making it impossible to use the automatic evolution features provided by Databricks.

Answer

To improve the performance of the initial file listing process.

Answer

To bypass the need for a checkpoint location for the stream.

Answer

To encrypt the data schema for security and compliance reasons.

Question 16

A data engineer needs to optimize the layout of a massive Delta Lake table that suffers from poor query performance due to a large number of small files and unsorted data records. Which TWO operations should the engineer execute to resolve these performance bottlenecks?

Accepted Answer

Execute the OPTIMIZE command to compact small files into larger files.. Optimizing a Delta table requires addressing both small file consolidation and multidimensional physical organization. Running OPTIMIZE compacts small files into larger, uniform file sizes, while combining it with Liquid Clustering or Z-Ordering organizes data records physically to maximize data skipping during filter queries. Together, these maintenance operations significantly reduce read input/output overhead across cloud object storage.

Answer

Execute the VACUUM command with a retention period of zero hours.

Answer

Run REPARTITION on the Delta table using the Spark DataFrame API directly.

Answer

Enable predictive optimization on the Databricks Unity Catalog managed table.

Question 17

A data engineer is working on a Delta Lake table that has accumulated millions of small files due to frequent streaming updates. This fragmentation has significantly degraded query performance. Which operation should the engineer execute to optimize file layout without altering table data?

Accepted Answer

Invoke the OPTIMIZE command to compact small parquet files into larger files using bin-packing.. Running the OPTIMIZE command on a Delta table compacts many small files into larger, optimized files using the bin-packing algorithm. This directly addresses fragmentation issues caused by frequent streaming micro-batches, improving read efficiency and scan speeds. Data engineers frequently schedule optimization jobs as part of bronze-to-silver and silver-to-gold maintenance pipelines in production environments to maintain optimal query performance and reduce cloud storage request latency.

Answer

Execute REFRESH TABLE to update the file metadata cache across all cluster worker nodes.

Answer

Run the VACUUM command with a retention threshold of zero hours to purge all historical data files.

Answer

Execute ALTER TABLE SET TBLPROPERTIES to enable automatic file compaction on every write transaction.

Question 18

An engineer needs to identify the root cause of a job failure. Which THREE of the following are valid locations or methods to investigate the logs?

Accepted Answer

Cluster event logs. Troubleshooting in Databricks requires access to various log levels. The cluster event log captures infrastructure-level changes, driver logs provide application execution details, and executor logs offer task-specific debugging info. Using these three sources provides a holistic view, covering everything from cluster startup issues to specific code-level exceptions. This multi-layered approach is essential for isolating whether a problem is infrastructure-related, configuration-based, or rooted in the logic of the transformation code itself.

Answer

Notebook workspace browser history

Answer

Databricks account profile settings

Question 19

Refer to the exhibit. A data engineer is attempting to run a VACUUM command on a table, but the command fails with an error indicating that the retention period is too short. Given the configuration, what is the most appropriate action the engineer should take to safely remove files older than 7 days?

Accepted Answer

Execute VACUUM table_name RETAIN 168 HOURS.. The configuration restricts the vacuuming of files to ensure Time Travel remains available. Databricks prevents setting a retention period shorter than the log retention to avoid data loss. To safely vacuum, the engineer must temporarily adjust the configuration or ensure the retention period respects the safety threshold. Understanding these safety constraints is critical for data lifecycle management and cost control in cloud storage environments.

Answer

Set 'spark.databricks.delta.retentionDurationCheck.enabled' to false.

Answer

Delete the underlying parquet files directly from cloud storage.

Answer

Run the OPTIMIZE command followed by REFRESH TABLE.

Question 20

A data engineer needs to share a table in Unity Catalog with external partners who do not have access to the Databricks workspace. Which feature should the data engineer configure?

Accepted Answer

Create a Delta Sharing recipient and publish tables to a sharing share object.. Delta Sharing enables secure data sharing with external organizations without requiring recipients to have access to your Databricks workspace or even be on the same cloud platform. It leverages cloud object storage credentials and open protocols to ensure governed data exchange.

Answer

Configure cross-workspace table linking using standard Spark mount points.

Answer

Create a shared Unity Catalog metastore and provision external IAM database users.

Answer

Export the Delta table files to CSV format and upload them to a public cloud bucket.