最新のCertified-Data-Engineer-Professional問題集で試験を準備する

Databricks Certified-Data-Engineer-Professional 試験概要:

Databricks Certified-Data-Engineer-Professional 試験シラバストピック:

Databricks Certified Data Engineer Professional 認定 Certified-Data-Engineer-Professional 試験問題：

問題 #1

A data architect has heard about lake's built-in versioning and time travel capabilities. For auditing purposes they have a requirement to maintain a full of all valid street addresses as they appear in the customers table.
The architect is interested in implementing a Type 1 table, overwriting existing records with new values and relying on Delta Lake time travel to support long-term auditing. A data engineer on the project feels that a Type 2 table will provide better performance and scalability. Which piece of information is critical to this decision?

A. Delta Lake only supports Type 0 tables; once records are inserted to a Delta Lake table, they cannot be modified.
B. Delta Lake time travel cannot be used to query previous versions of these tables because Type 1 changes modify data files in place.
C. Data corruption can occur if a query fails in a partially completed state because Type 2 tables requires setting multiple fields in a single update.
D. Shallow clones can be combined with Type 1 tables to accelerate historic queries for long-term versioning.
E. Delta Lake time travel does not scale well in cost or latency to provide a long-term versioning solution.

問題 #2

A junior data engineer has manually configured a series of jobs using the Databricks Jobs UI.
Upon reviewing their work, the engineer realizes that they are listed as the "Owner" for each job.
They attempt to transfer "Owner" privileges to the "DevOps" group, but cannot successfully accomplish this task.
Which statement explains what is preventing this privilege transfer?

A. Other than the default "admins" group, only individual users can be granted privileges on jobs.
B. Only workspace administrators can grant "Owner" privileges to a group.
C. The creator of a Databricks job will always have "Owner" privileges; this configuration cannot be changed.
D. A user can only transfer job ownership to a group if they are also a member of that group.
E. Databricks jobs must have exactly one owner; "Owner" privileges cannot be assigned to a group.

問題 #3

A data engineer is building a customer data pipeline in Lakeflow Spark Declarative Pipelines. The source is a cloud-based event stream with limited retention containing inserts, updates, and deletes for customer records. These changes are being applied using the AUTO CDC INTO syntax to maintain an SCD Type 1 table as the target table, customer_dim. How should the data engineer build a downstream job that streams from the customer_dim table to only act on updates and delete events, processing data incrementally?

A. Streaming from customer_dim table would only be possible in the case of SCD 2 retention.
B. Use ignoreChanges flag while streaming from customer_dim to avoid breaking the pipeline during updates and deletes.
C. Read change data feed from customer_dim table and apply filters to incrementally act on the change events.
D. When stored as SCD 1, the target of AUTO CDC INTO includes updates and deletes. Streaming from customer_dim can fail due to these operations. Instead, build another stream from the original source.

問題 #4

The data architect has decided that once data has been ingested from external sources into the Databricks Lakehouse, table access controls will be leveraged to manage permissions for all production tables and views.
The following logic was executed to grant privileges for interactive queries on a production database to the core engineering group.
GRANT USAGE ON DATABASE prod TO eng;
GRANT SELECT ON DATABASE prod TO eng;
Assuming these are the only privileges that have been granted to the eng group and that these users are not workspace administrators, which statement describes their privileges?

A. Group members are able to query and modify all tables and views in the prod database, but cannot create new tables or views.
B. Group members have full permissions on the prod database and can also assign permissions to other users or groups.
C. Group members are able to list all tables in the prod database but are not able to see the results of any queries on those tables.
D. Group members are able to create, query, and modify all tables and views in the prod database, but cannot define custom functions.
E. Group members are able to query all tables and views in the prod database, but cannot create or edit anything in the database.

問題 #5

What describes a primary technical challenge in ensuring consistent PII masking across all nodes in large-scale, distributed Databricks batch and streaming pipelines?

A. PII masking is only required for direct identifiers.
B. Masking functions must be standardized and managed through Unity Catalog, with enforcement applied across all relevant datasets to avoid any data inconsistency.
C. Native masking in Databricks automatically synchronizes with all downstream external Databricks systems.
D. Dynamic data masking is applied only at rest, so it does not affect query performance.

解説：