최신 Databricks-Certified-Data-Engineer-Professional 무료덤프 - Databricks Certified Data Engineer Professional

문제1

A junior data engineer has been asked to develop a streaming data pipeline with a grouped aggregation using DataFrame df. The pipeline needs to calculate the average humidity and average temperature for each non-overlapping five-minute interval. Events are recorded once per minute per device.
Streaming DataFrame df has the following schema:
"device_id INT, event_time TIMESTAMP, temp FLOAT, humidity FLOAT"
Code block:
Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

Choose the response that correctly fills in the blank within the code block to complete this task.

A. "event_time"

B. lag("event_time", "10 minutes").alias("time")

C. window("event_time", "5 minutes").alias("time")

D. window("event_time", "10 minutes").alias("time")

E. to_interval("event_time", "5 minutes").alias("time")

정답: C

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

문제2

A data engineer needs to capture pipeline settings from an existing in the workspace, and use them to create and version a JSON file to create a new pipeline. Which command should the data engineer enter in a web terminal configured with the Databricks CLI?

A. Use list pipelines to get the specs for all pipelines; get the pipeline spec from the return results parse and use this to create a pipeline

B. Use the alone command to create a copy of an existing pipeline; use the get JSON command to get the pipeline definition; save this to git

C. Use the get command to capture the settings for the existing pipeline; remove the pipeline_id and rename the pipeline; use this in a create command

D. Stop the existing pipeline; use the returned settings in a reset command

정답: C

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

문제3

Which statement regarding stream-static joins and static Delta tables is correct?

A. Each microbatch of a stream-static join will use the most recent version of the static Delta table as of each microbatch.

B. Each microbatch of a stream-static join will use the most recent version of the static Delta table as of the job's initialization.

C. The checkpoint directory will be used to track state information for the unique keys present in the join.

D. Stream-static joins cannot use static Delta tables because of consistency issues.

E. The checkpoint directory will be used to track updates to the static Delta table.

정답: A

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

문제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 have full permissions on the prod database and can also assign permissions to other users or groups.

B. Group members are able to query and modify all tables and views in the prod database, but cannot create new tables or views.

C. Group members are able to query all tables and views in the prod database, but cannot create or edit anything in the database.

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 list all tables in the prod database but are not able to see the results of any queries on those tables.

정답: C

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

문제5

A new data engineer notices that a critical field was omitted from an application that writes its Kafka source to Delta Lake. This happened even though the critical field was in the Kafka source.
That field was further missing from data written to dependent, long-term storage. The retention threshold on the Kafka service is seven days. The pipeline has been in production for three months.
Which describes how Delta Lake can help to avoid data loss of this nature in the future?

A. Delta Lake schema evolution can retroactively calculate the correct value for newly added fields, as long as the data was in the original source.

B. Delta Lake automatically checks that all fields present in the source data are included in the ingestion layer.

C. Ingestine all raw data and metadata from Kafka to a bronze Delta table creates a permanent, replayable history of the data state.Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

D. The Delta log and Structured Streaming checkpoints record the full history of the Kafka producer.

E. Data can never be permanently dropped or deleted from Delta Lake, so data loss is not possible under any circumstance.

정답: C

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

문제6

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

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

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

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

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

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

정답: C

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

문제7

Which of the following is true of Delta Lake and the Lakehouse?

A. Views in the Lakehouse maintain a valid cache of the most recent versions of source tables at all times.

B. Delta Lake automatically collects statistics on the first 32 columns of each table which are leveraged in data skipping based on query filters.

C. Primary and foreign key constraints can be leveraged to ensure duplicate values are never entered into a dimension table.

D. Z-order can only be applied to numeric values stored in Delta Lake tables

E. Because Parquet compresses data row by row. strings will only be compressed when a character is repeated multiple times.

정답: B

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

문제8

The data engineering team is migrating an enterprise system with thousands of tables and views into the Lakehouse. They plan to implement the target architecture using a series of bronze, silver, and gold tables. Bronze tables will almost exclusively be used by production data engineering workloads, while silver tables will be used to support both data engineering and machine learning workloads. Gold tables will largely serve business intelligence and reporting purposes. While personal identifying information (PII) exists in all tiers of data, pseudonymization and anonymization rules are in place for all data at the silver and gold levels.
The organization is interested in reducing security concerns while maximizing the ability to collaborate across diverse teams.
Which statement exemplifies best practices for implementing this system?

A. Because all tables must live in the same storage containers used for the database they're created in, organizations should be prepared to create between dozens and thousands of databases depending on their data isolation requirements.

B. Working in the default Databricks database provides the greatest security when working with managed tables, as these will be created in the DBFS root.

C. Storinq all production tables in a single database provides a unified view of all data assets available throughout the Lakehouse, simplifying discoverability by granting all users view privileges on this database.

D. Because databases on Databricks are merely a logical construct, choices around database organization do not impact security or discoverability in the Lakehouse.

E. Isolating tables in separate databases based on data quality tiers allows for easy permissions management through database ACLs and allows physical separation of default storage locations for managed tables.

정답: E

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

문제9

Two of the most common data locations on Databricks are the DBFS root storage and external object storage mounted with dbutils.fs.mount().
Which of the following statements is correct?

A. The DBFS root is the most secure location to store data, because mounted storage volumes must have full public read and write permissions.

B. Neither the DBFS root nor mounted storage can be accessed when using %sh in a Databricks notebook.

C. DBFS is a file system protocol that allows users to interact with files stored in object storage using syntax and guarantees similar to Unix file systems.

D. By default, both the DBFS root and mounted data sources are only accessible to workspace administrators.

E. The DBFS root stores files in ephemeral block volumes attached to the driver, while mounted directories will always persist saved data to external storage between sessions.

정답: C

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

문제10

Spill occurs as a result of executing various wide transformations. However, diagnosing spill requires one to proactively look for key indicators.
Where in the Spark UI are two of the primary indicators that a partition is spilling to disk?

A. Query's detail screen and Job's detail screen

B. Stage's detail screen and Executor's log files

C. Driver's and Executor's log files

D. Stage's detail screen and Query's detail screen

E. Executor's detail screen and Executor's log files

정답: B

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

최신 Databricks-Certified-Data-Engineer-Professional 무료덤프 - Databricks Certified Data Engineer Professional

우리와 연락하기

유용한 링크

최신 업데이트