Databricks-Certified-Data-Engineer-Professional問題集、Databricks実際の試験問題

質問 1

A job runs four independent tasks (X, Y, Z, W) in parallel to process regional sales data. The Data Engineering team recently updated its cluster policy to ban cost-prohibitive instance types. Task Y now fails due to the newly enforced cluster policy restricting the use of a specific instance type.
A data engineer needs to resolve the failure quickly without disrupting the other tasks. How should the data engineer resolve the failure of tasks?

A. Delete the failed run, disable the cluster policy, and re-execute all tasks.

B. Use "Repair run", override the cluster configuration for Task Y to use a permitted instance type, and let Databricks re-run only Task Y.

C. Edit the global cluster policy to allow the restricted instance type, then re-run the entire job.

D. Manually create a new cluster for Task Y, update the job configuration, and trigger a full re-run.

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 2

A data engineering team is setting up deployment automation. To deploy workspace assets remotely using the Databricks CLI command, they must configure it with proper authentication.
Which authentication approach will provide the highest level of security?

A. Use a shared user account and its OAuth client secret.

B. Use a service principal ID and its OAuth client secret.

C. Use a service principal with OAuth token federation.

D. Use a service principal and its Personal Access Token.

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 3

A data engineering workspace was automatically enabled for Unity Catalog, creating a workspace catalog. New team members report they can create tables in the default schema but cannot access table in other schemas within the same workspace catalog. Why are the new team members unable to access tables in other schemas?

A. Workspace users receive USE CATALOG and specific privileges on default schema only.

B. Tables in other schemas require additional BROWSEprivileges that new users don't receive automatically

C. New users only receive CREATE TABLE privileges on the default schema.

D. Workspace catalog permissions are not subject to inheritance rules.

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 4

A data engineer inherits a Delta table with historical partitions by country that are badly skewed.
Queries often filter by high-cardinality customer_id and vary across dimensions over time. The engineer wants a strategy that avoids a disruptive full rewrite, reduces sensitivity to skewed partitions, and sustains strong query performance as access patterns evolve. Which two actions should the data engineer take? (Choose two.)

A. Depend solely on optimized writes; Databricks will automatically replace partitioning with clustering over time.

B. Periodically run OPTIMIZE table_name.

C. Switch from static partitioning to liquid clustering and select initial clustering keys that reflect common filters such as customer_id.

D. Keep existing partitions and rely on bin-packing OPTIMIZE only; ZORDER and clustering are unnecessary for multi-dimensional filters.

E. Disable data skipping statistics to avoid maintenance overhead; rely on adaptive query execution instead.

正解: B,C

解説: (PassTest メンバーにのみ表示されます)

質問 5

The security team is exploring whether or not the Databricks secrets module can be leveraged for connecting to an external database.
After testing the code with all Python variables being defined with strings, they upload the password to the secrets module and configure the correct permissions for the currently active user. They then modify their code to the following (leaving all other variables unchanged).

Which statement describes what will happen when the above code is executed?

A. The connection to the external table will fail; the string "redacted" will be printed.

B. An interactive input box will appear in the notebook; if the right password is provided, the connection will succeed and the encoded password will be saved to DBFS.

C. The connection to the external table will succeed; the string value of password will be printed in plain text.

D. The connection to the external table will succeed; the string "redacted" will be printed.

E. An interactive input box will appear in the notebook; if the right password is provided, the connection will succeed and the password will be printed in plain text.

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 6

The view updates represents an incremental batch of all newly ingested data to be inserted or updated in the customers table.
The following logic is used to process these records.

Which statement describes this implementation?

A. The customers table is implemented as a Type 2 table; old values are overwritten and new customers are appended.

B. The customers table is implemented as a Type 0 table; all writes are append only with no changes to existing values.

C. The customers table is implemented as a Type 1 table; old values are overwritten by new values and no history is maintained.

D. The customers table is implemented as a Type 2 table; old values are maintained but marked as no longer current and new values are inserted.

E. The customers table is implemented as a Type 3 table; old values are maintained as a new column alongside the current value.

正解: D

質問 7

A view is registered with the following code:

Both users and orders are Delta Lake tables.
Which statement describes the results of querying recent_orders?

A. All logic will execute when the view is defined and store the result of joining tables to the DBFS; this stored data will be returned when the view is queried.

B. All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query finishes.

C. Results will be computed and cached when the view is defined; these cached results will incrementally update as new records are inserted into source tables.

D. All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query began.

正解: D

質問 8

The following table consists of items found in user carts within an e-commerce website.

The following MERGE statement is used to update this table using an updates view, with schema evolution enabled on this table.

How would the following update be handled?

A. The new nested field is added to the target schema, and files underlying existing records are updated to include NULL values for the new field.

B. The update throws an error because changes to existing columns in the target schema are not supported.

C. The new restored field is added to the target schema, and dynamically read as NULL for existing unmatched records.

D. The update is moved to separate ''restored'' column because it is missing a column expected in the target schema.

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 9

The data architect has mandated that all tables in the Lakehouse should be configured as external (also known as "unmanaged") Delta Lake tables.
Which approach will ensure that this requirement is met?

A. When data is saved to a table, make sure that a full file path is specified alongside the Delta format.

B. When the workspace is being configured, make sure that external cloud object storage has been mounted.

C. When tables are created, make sure that the EXTERNAL keyword is used in the CREATE TABLE statement.

D. When configuring an external data warehouse for all table storage, leverage Databricks for all ELT.

E. When a database is being created, make sure that the LOCATION keyword is used.

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 10

A company stores account transactions in a Delta Lake table. The company needs to apply frequent account-level correlations (e.g., UPDATE statements) but wants to avoid rewriting entire Parquet files for each change to reduce file churn and improve write performance. Which Delta Lake feature should they enable?

A. Enable change data feed on the Delta table

B. Partition the Delta table by account_id

C. Enable automatic file compaction on writes

D. Enable deletion vectors on the Delta table

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 11

A query is taking too long to run. After investigating the Spark UI, the data engineer discovered a significant amount of disk spill. The compute instance being used has a core-to-memory ratio of
1:2. What are the two steps the data engineer should take to minimize spillage? (Choose two.)

A. Choose a compute instance with more disk space.

B. Choose a compute instance with more network bandwidth.

C. Increase spark.sql.files.maxPartitionBytes.

D. Choose a compute instance with a higher core-to-memory ratio.

E. Reduce spark.sql.files.maxPartitionBytes.

正解: D,E

解説: (PassTest メンバーにのみ表示されます)

質問 12

Each configuration below is identical to the extent that each cluster has 400 GB total of RAM 160 total cores and only one Executor per VM.
Given an extremely long-running job for which completion must be guaranteed, which cluster configuration will be able to guarantee completion of the job in light of one or more VM failures?

A. - Total VMs: 16
- 25 GB per Executor
- 10 Cores / Executor

B. - Total VMs: 1
- 400 GB per Executor
- 160 Cores/Executor

C. - Total VMs: 4
- 100 GB per Executor
- 40 Cores / Executor

D. - Total VMs: 8
- 50 GB per Executor
- 20 Cores / Executor

E. - Total VMs: 2
- 200 GB per Executor
- 80 Cores / Executor

正解: A

質問 13

An analytics team wants to run a short-term experiment in Databricks SQL on the customer transactions Delta table (about 20 billion records) created by the data engineering team. Which strategy should the data engineering team use to ensure minimal downtime and no impact on the ongoing ETL processes?

A. Shallow clone the table for the analytics team.

B. Create a new table for the analytics team using a CTAS statement.

C. Give the analytics team direct access to the production table.

D. Deep clone the table for the analytics team.

正解: A

解説: (PassTest メンバーにのみ表示されます)

Databricks Certified Data Engineer Professional - Databricks-Certified-Data-Engineer-Professional 模擬練習