Databricks Databricks-Certified-Professional-Data-Engineer 실제 시험문제 및 답변

문제1
A workspace admin has created a new catalog called finance_data and wants to delegate permission management to a finance team lead without giving them full admin rights.
Which privilege should be granted to the finance team lead?

A. Make the finance team lead a metastore admin.

B. MANAGE privilege on the finance_data catalog.

C. GRANT OPTION privilege on the finance_data catalog.

D. ALL PRIVILEGES on the finance_data catalog.

정답: B

설명: (ExamPassdump 회원만 볼 수 있음)

문제2
What statement is true regarding the retention of job run history?

A. It is retained for 30 days, during which time you can deliver job run logs to DBFS or S3

B. It is retained for 60 days, after which logs are archived

C. It is retained for 90 days or until the run-id is re-used through custom run configuration

D. It is retained until you export or delete job run logs

E. t is retained for 60 days, during which you can export notebook run results to HTML

정답: E

문제3
A data engineer has created a new cluster using shared access mode with default configurations. The data engineer needs to allow the development team access to view the driver logs if needed.
What are the minimal cluster permissions that allow the development team to accomplish this?

A. CAN VIEW

B. CAN RESTART

C. CAN ATTACH TO

D. CAN MANAGE

정답: A

설명: (ExamPassdump 회원만 볼 수 있음)

문제4
A healthcare analytics team is implementing a dimensional model in Delta Lake for patient care analysis.
They have a date dimension table and are evaluating design options to ensure it supports a wide range of time- based analyses.
Which design approach for the date dimension will support efficient time-based querying and aggregation?

A. Store the date as a string in the format YYYY-MM-DD for readability.

B. Create separate dimension tables for different calendar systems (fiscal, academic, etc.).

C. Store only the date value and calculate all time attributes dynamically in queries.

D. Pre-calculate attributes like fiscal_period, quarter, month_name, day_of_week, and holiday.

정답: D

설명: (ExamPassdump 회원만 볼 수 있음)

문제5
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.

정답: E

설명: (ExamPassdump 회원만 볼 수 있음)

문제6
Which statement describes Delta Lake optimized writes?

A. Optimized writes logical partitions instead of directory partitions partition boundaries are only represented in metadata fewer small files are written.

B. An asynchronous job runs after the write completes to detect if files could be further compacted; yes, an OPTIMIZE job is executed toward a default of 1 GB.

C. A shuffle occurs prior to writing to try to group data together resulting in fewer files instead of each executor writing multiple files based on directory partitions.

D. Before a job cluster terminates, OPTIMIZE is executed on all tables modified during the most recent job.

정답: C

설명: (ExamPassdump 회원만 볼 수 있음)

문제7
An upstream system has been configured to pass the date for a given batch of data to the Databricks Jobs API as a parameter. The notebook to be scheduled will use this parameter to load data with the following code:
df = spark.read.format( " parquet " ).load(f " /mnt/source/(date) " )
Which code block should be used to create the date Python variable used in the above code block?

A. input_dict = input()
date= input_dict[ " date " ]

B. date = dbutils.notebooks.getParam( " date " )

C. date = spark.conf.get( " date " )

D. dbutils.widgets.text( " date " , " null " )
date = dbutils.widgets.get( " date " )

E. import sys
date = sys.argv[1]

정답: D

설명: (ExamPassdump 회원만 볼 수 있음)

문제8
Given the following error traceback:
AnalysisException: cannot resolve ' heartrateheartrateheartrate ' given input columns:
[spark_catalog.database.table.device_id, spark_catalog.database.table.heartrate, spark_catalog.database.table.mrn, spark_catalog.database.table.time] The code snippet was:
display(df.select(3* " heartrate " ))
Which statement describes the error being raised?

A. There is no column in the table named heartrateheartrateheartrate.

B. There is a type error because a DataFrame object cannot be multiplied.

C. There is a type error because a column object cannot be multiplied.

D. There is a syntax error because the heartrate column is not correctly identified as a column.

정답: A

설명: (ExamPassdump 회원만 볼 수 있음)

문제9
A data engineer wants to ingest a large collection of image files (JPEG and PNG) from cloud object storage into a Unity Catalog-managed table for analysis and visualization.
Which two configurations and practices are recommended to incrementally ingest these images into the table?
(Choose 2 answers)

A. Use the pathGlobFilter option to select only image files (e.g., " *.jpg,*.png " ).

B. Use Auto Loader and set cloudFiles.format to " BINARYFILE " .

C. Use Auto Loader and set cloudFiles.format to " TEXT " .

D. Use Auto Loader and set cloudFiles.format to " IMAGE " .

E. Move files to a volume and read with SQL editor.

정답: A,B

설명: (ExamPassdump 회원만 볼 수 있음)

문제10
Which statement describes the correct use of pyspark.sql.functions.broadcast?

A. It marks a column as small enough to store in memory on all executors, allowing a broadcast join.

B. It caches a copy of the indicated table on all nodes in the cluster for use in all future queries during the cluster lifetime.

C. It marks a DataFrame as small enough to store in memory on all executors, allowing a broadcast join.

D. It caches a copy of the indicated table on attached storage volumes for all active clusters within a Databricks workspace.

E. It marks a column as having low enough cardinality to properly map distinct values to available partitions, allowing a broadcast join.

정답: C

설명: (ExamPassdump 회원만 볼 수 있음)

문제11
Given the following error traceback (from display(df.select(3* " heartrate " ))) which shows AnalysisException: cannot resolve ' heartrateheartrateheartrate ' , which statement describes the error being raised?

A. There is no column in the table named heartrateheartrateheartrate.

B. There is a type error because a DataFrame object cannot be multiplied.

C. There is a type error because a column object cannot be multiplied.

D. There is a syntax error because the heartrate column is not correctly identified as a column.

정답: A

설명: (ExamPassdump 회원만 볼 수 있음)

문제12
Which statement regarding spark configuration on the Databricks platform is true?

A. Spark configuration properties set for an interactive cluster with the Clusters UI will impact all notebooks attached to that cluster.

B. The Databricks REST API can be used to modify the Spark configuration properties for an interactive cluster without interrupting jobs.

C. When the same spar configuration property is set for an interactive to the same interactive cluster.

D. Spark configuration set within an notebook will affect all SparkSession attached to the same interactive cluster

정답: A

설명: (ExamPassdump 회원만 볼 수 있음)

문제13
A data governance team at a large enterprise is improving data discoverability across its organization. The team has hundreds of tables in their Databricks Lakehouse with thousands of columns that lack proper documentation. Many of these tables were created by different teams over several years, with missing context about column meanings and business logic. The data governance team needs to quickly generate comprehensive column descriptions for all existing tables to meet compliance requirements and improve data literacy across the organization. They want to leverage modern capabilities to automatically generate meaningful descriptions rather than manually documenting each column, which would take months to complete.
Which approach should the team use in Databricks to automatically generate column comments and descriptions for existing tables?

A. Use the DESCRIBE TABLE command to extract existing schema information and manually write descriptions based on column names and data types.

B. Use Delta Lake's DESCRIBE HISTORY command to analyze table evolution and infer column purposes from historical changes.

C. Navigate to the table in Databricks Catalog Explorer, select the table schema view, and use the AI Generate option which leverages artificial intelligence to automatically create meaningful column descriptions based on column names, data types, sample values, and data patterns.

D. Write custom PySpark code using df.describe() and df.schema to programmatically generate basic statistical descriptions for each column.

정답: C

설명: (ExamPassdump 회원만 볼 수 있음)

문제14
A data engineer is tasked with ensuring that a Delta table in Databricks continuously retains deleted files for
15 days (instead of the default 7 days), in order to permanently comply with the organization's data retention policy.
Which code snippet correctly sets this retention period for deleted files?

A. from delta.tables import *
deltaTable = DeltaTable.forPath(spark, " /mnt/data/my_table " )
deltaTable.deletedFileRetentionDuration = " interval 15 days "

B. spark.sql( " VACUUM my_table RETAIN 15 HOURS " )

C. spark.sql( " ALTER TABLE my_table SET TBLPROPERTIES ( ' delta.deletedFileRetentionDuration '
= ' interval 15 days ' ) " )

D. spark.conf.set( " spark.databricks.delta.deletedFileRetentionDuration " , " 15 days " )

정답: C

설명: (ExamPassdump 회원만 볼 수 있음)

최신Databricks Certified Professional Data Engineer - Databricks-Certified-Professional-Data-Engineer무료샘플문제

자격증의 중요성:

ExamPassdump 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: