View Full Databricks Certified Data Engineer Associate Exam Dumps and Practice Test Dumps.

Question 321

A data engineer wants to make a table available for querying while storing it under a specific cloud storage path that is managed outside the default managed storage location. Which table type is appropriate?

1. External table
2. Temporary view
3. Materialized view
4. Managed table

Correct Answer: 1

Explanation

An external table stores its underlying data at a specified external storage location rather than relying on the default managed storage location for the catalog or schema. This can be useful when an organization already manages data in a particular cloud storage path and wants Unity Catalog to govern access to that data. Temporary views and materialized views are query objects, while managed tables have their storage lifecycle managed by the platform. Therefore, an external table is appropriate for this requirement.

Question 322

A team wants Databricks to manage both the metadata and underlying storage lifecycle of a newly created table. Which table type should they use?

1. External table
2. Managed table
3. Temporary view
4. CTE

Correct Answer: 2

Explanation

A managed table is controlled by the Databricks and Unity Catalog environment, including management of its underlying storage according to the configured catalog and schema storage settings. This differs from an external table, where the underlying data is stored at a separately specified location. Temporary views and CTEs do not represent managed physical table storage. Therefore, when the team wants the platform to manage the table and its associated storage lifecycle, a managed table is the appropriate choice.

Question 323

A data engineer wants to make a frequently queried result available as a physically maintained object so that users do not need to recompute the complete query every time. Which Databricks SQL object is appropriate?

1. Temporary view
2. Standard view
3. Materialized view
4. CTE

Correct Answer: 3

Explanation

A materialized view stores the results of its defining query and can be maintained as underlying data changes. This can improve performance for workloads that repeatedly query expensive transformations or aggregations. A standard view stores the query definition rather than a separately materialized result, while a temporary view has session-oriented scope. A CTE is an intermediate query construct rather than a persistent database object. Therefore, a materialized view is appropriate when maintaining query results can reduce repeated computation.

Question 324

A data engineer wants to define a reusable query object that presents data from one or more tables without creating a separately stored copy of the query results. Which object should be used?

1. Materialized view
2. Temporary table
3. Delta clone
4. View

Correct Answer: 4

Explanation

A view stores a SQL query definition that can be referenced as a logical table without maintaining a separate physical copy of its result data. This is useful for simplifying complex queries, exposing selected columns, or providing controlled interfaces to underlying tables. A materialized view maintains query results, while a Delta clone creates another table representation. A temporary table has different lifecycle and storage behavior. Therefore, a standard view is appropriate when the goal is reusable query logic without a separately stored result.

Question 325

A data engineer is deciding whether to partition a large table by customer_id. The table contains millions of customers, and most queries do not filter by customer_id. What concern should influence this decision?

1. High-cardinality partitioning can create too many small partitions
2. Partitioning always removes the need for indexes
3. Partitioning automatically encrypts the data
4. Partitioning prevents all shuffle operations

Correct Answer: 1

Explanation

Partitioning by a high-cardinality column such as customer_id can create a very large number of partitions, potentially resulting in many small files and inefficient storage layout. Partitioning is generally most useful when the partition column has appropriate cardinality and is frequently used to restrict the data scanned by queries. It does not automatically encrypt data, eliminate all shuffle operations, or replace every other optimization mechanism. Therefore, the risk of excessive small partitions is an important consideration in this scenario.

Question 326

A data engineer is designing a large table and wants to avoid creating an excessive number of tiny files caused by overly granular partitioning. Which design consideration is most relevant?

1. Partition on every column
2. Use high-cardinality identifiers as partitions
3. Choose partition columns carefully based on access patterns
4. Create a separate partition for every record

Correct Answer: 3

Explanation

Partition columns should be selected based on data characteristics and common query access patterns. Choosing appropriate columns can allow queries to skip irrelevant data without producing excessive numbers of small partitions. Partitioning every column or creating a partition for every record can result in inefficient storage layouts, while high-cardinality identifiers often create too many partitions. Therefore, selecting partition columns carefully according to the workload and data distribution is an important table-design consideration.

Question 327

A data engineer wants queries to avoid scanning files that cannot contain records matching a filter condition. Which Delta Lake capability can help reduce unnecessary file reads using stored file-level statistics?

1. Git integration
2. Data skipping
3. Service principals
4. Job retries

Correct Answer: 2

Explanation

Data skipping uses file-level statistics to avoid reading files that cannot satisfy a query’s filtering conditions. When applicable, this reduces the amount of data that must be scanned and can improve query performance on large Delta tables. Git integration manages source code, service principals provide application identities, and job retries handle workflow failures. Therefore, data skipping is the capability directly related to reducing unnecessary file reads based on available file-level statistics.

Question 328

A data engineer needs to understand why a query is reading a large amount of data despite having a filter condition. Which information can help determine whether the filter can benefit from data skipping?

1. File-level statistics
2. Git commit messages
3. Job notification recipients
4. Service principal name

Correct Answer: 4

Explanation

File-level statistics can help determine whether Delta Lake can identify files that cannot contain records matching a filter. When useful statistics are available for the relevant columns, the engine may skip unnecessary files instead of scanning them. Git commit messages, notification recipients, and service principal names do not describe the physical data characteristics required for data skipping. Therefore, examining file-level statistics is relevant when investigating whether a filter can reduce the amount of data scanned.

Question 329

A data engineer needs to execute SQL queries interactively and wants a compute resource designed specifically for SQL workloads rather than general notebook development. Which resource should be used?

1. SQL warehouse
2. Git folder
3. Storage credential
4. Unity Catalog volume

Correct Answer: 1

Explanation

A SQL warehouse provides compute specifically for SQL workloads in Databricks. It can be used for interactive SQL queries, dashboards, and other SQL-based workloads without requiring users to manage a general-purpose notebook compute environment. Git folders are used for source control, storage credentials authenticate access to cloud storage, and Unity Catalog volumes govern file storage. Therefore, a SQL warehouse is the appropriate compute resource when the workload consists primarily of interactive SQL queries.

Question 330

A team wants to investigate previously executed SQL statements to identify when a particular query ran and examine information associated with its execution. Which Databricks capability should they inspect?

1. Unity Catalog volumes
2. Query history
3. Cluster policy
4. Storage credentials

Correct Answer: 2

Explanation

Query history provides information about previously executed queries and can help engineers investigate SQL activity. It can be useful when troubleshooting performance, identifying when a query was executed, or reviewing query-related details. Unity Catalog volumes manage files, cluster policies govern compute configurations, and storage credentials support governed cloud-storage access. Therefore, query history is the relevant Databricks capability when investigating previously executed SQL statements.

Question 331

A data engineer needs to identify a query that caused unusually high SQL warehouse resource usage and wants to investigate its execution details. What should be reviewed?

1. Query history and query execution information
2. Git branch permissions
3. Volume ownership only
4. Table comments only

Correct Answer: 1

Explanation

Query history and associated execution information can help identify resource-intensive SQL queries and investigate their behavior. Engineers can review query timing, execution characteristics, and other available information to determine which statements may have contributed to high resource usage. Git branch permissions and volume ownership address different areas of platform management, while table comments are documentation rather than execution diagnostics. Therefore, query history and execution information are the appropriate resources for investigating unusually expensive SQL queries.

Question 332

A data engineer needs to identify whether a SQL query was executed before or after a specific code deployment. Which information provides the necessary execution timeline?

1. Delta table schema
2. Query history
3. Cluster policy
4. Unity Catalog volume metadata

Correct Answer: 2

Explanation

Query history provides timestamps and information about executed SQL statements, making it useful for correlating query activity with other events such as code deployments. By comparing query execution times with deployment timestamps, engineers can investigate whether a query occurred before or after a particular change. Delta table schema describes data structure, cluster policies govern compute configurations, and volume metadata concerns governed files. Therefore, query history provides the execution timeline needed for this type of investigation.

Question 333

A data engineering team wants to maintain source code in a repository and use version control while developing Databricks notebooks collaboratively. Which capability supports this workflow?

1. Git folders
2. VACUUM
3. SQL warehouse
4. Data skipping

Correct Answer: 1

Explanation

Git folders integrate Databricks development with Git-based source control. They allow teams to work with notebooks and related files in repositories while using familiar version-control operations such as commits, branches, and reviews. VACUUM manages obsolete Delta files, SQL warehouses provide SQL compute, and data skipping improves query efficiency by avoiding unnecessary file reads. Therefore, Git folders are appropriate when a team wants collaborative Databricks development backed by source control.

Question 334

A developer wants to test a feature without changing the production branch until the implementation has been reviewed. Which Git practice should be used?

1. Delete the production branch
2. Modify production directly
3. Create a separate feature branch
4. Remove all previous commits

Correct Answer: 3

Explanation

A separate feature branch allows developers to implement and test changes independently from the production branch. Once the work has been reviewed and validated, it can be merged through the team’s established deployment process. Directly modifying production increases the risk of introducing untested changes, while deleting branches or previous commits removes useful development history. Therefore, a feature branch provides an isolated environment for developing and reviewing changes before they are incorporated into production.

Question 335

A data engineer wants to compare changes made to a notebook over time and identify the commit that introduced a transformation change. Which source-control information is most useful?

1. Git commit history
2. SQL warehouse size
3. Delta table location
4. Cluster worker count

Correct Answer: 1

Explanation

Git commit history records source-code changes over time and can help identify when a transformation was introduced or modified. Engineers can review commits and compare changes to determine which modification may have affected a workflow. SQL warehouse size, Delta table location, and cluster worker count describe compute or storage characteristics rather than source-code evolution. Therefore, Git commit history is the most useful information when tracing notebook changes and identifying the commit associated with a transformation modification.

Question 336

A production workflow should use a non-human identity with only the permissions required to read a governed dataset. Which combination best supports this requirement?

1. Personal user account with administrator privileges
2. Service principal with appropriate SELECT permissions
3. Shared password stored in notebook code
4. Anonymous workspace access

Correct Answer: 2

Explanation

A service principal provides a non-human identity suitable for automated workloads, while appropriate SELECT permissions can limit its access to only the data it needs to read. This combination supports both automation and least-privilege access. Using a personal administrator account provides excessive privileges and creates dependency on an individual. Hard-coded passwords expose sensitive credentials, and anonymous access is unsuitable for governed production data. Therefore, a service principal with narrowly scoped SELECT access is appropriate.

Question 337

A data engineer needs to allow users to upload files into a governed storage area but does not want to expose direct cloud-storage credentials to them. Which capability is appropriate?

1. Unity Catalog volume
2. Spark action
3. Git branch
4. SQL CTE

Correct Answer: 1

Explanation

A Unity Catalog volume provides a governed location for file-based data and can be controlled through Unity Catalog permissions. This allows users to work with files while access is managed through the platform rather than requiring users to receive direct cloud-storage credentials. Spark actions execute computations, Git branches isolate source-code changes, and CTEs organize SQL queries. Therefore, a Unity Catalog volume is appropriate when users need controlled access to uploaded files without direct exposure to underlying storage credentials.

Question 338

A data engineer needs to access cloud storage through a centrally governed path while keeping authentication separate from notebook code. Which architecture is appropriate?

1. Notebook hard-coded access key
2. External location backed by a storage credential
3. Temporary view containing credentials
4. Git commit containing the secret

Correct Answer: 2

Explanation

An external location backed by a storage credential provides a governed mechanism for accessing cloud storage through Unity Catalog. The storage credential handles the authentication configuration, while the external location identifies the permitted storage path. This keeps authentication separate from notebook code and supports centralized administration. Hard-coded keys and credentials stored in views or Git commits can expose sensitive information and are not appropriate governance mechanisms. Therefore, the combination of external location and storage credential is the suitable architecture.

Question 339

A data engineer needs to enforce that a transaction amount must always be greater than or equal to zero. Which Delta table feature can reject records that violate this rule?

1. Git branch protection
2. Cluster policy
3. CHECK constraint
4. Query history

Correct Answer: 3

Explanation

A CHECK constraint can enforce a condition on data written to a Delta table. For example, a rule such as amount >= 0 can prevent records with negative transaction amounts from being accepted. This provides a table-level data-quality control that applies to writes affecting the constrained table. Git branch protection manages source-code workflows, cluster policies govern compute configurations, and query history records SQL activity. Therefore, a CHECK constraint is the appropriate feature for enforcing the transaction amount requirement.

Question 340

A data engineering team wants to use the same workflow implementation in development, testing, and production while changing only environment-specific resource names and settings. Which design best supports this goal?

1. Copy and manually rewrite the workflow for every environment
2. Hard-code production resources into the notebook
3. Keep separate unrelated codebases for each environment
4. Parameterize environment-specific configuration separately from workflow logic

Correct Answer: 4

Explanation

Separating environment-specific configuration from workflow logic allows the same implementation to be reused across development, testing, and production. Parameters or configuration can provide environment-specific values such as catalog names, schemas, storage paths, or other resources without requiring changes to the core transformation code. Maintaining separate codebases increases duplication and configuration drift, while hard-coding production settings reduces portability. Therefore, parameterized environment-specific configuration provides a more maintainable and repeatable deployment design.