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

문제1

The downstream consumers of a Delta Lake table have been complaining about data quality issues impacting performance in their applications. Specifically, they have complained that invalid latitude and longitude values in the activity_details table have been breaking their ability to use other geolocation processes.
A junior engineer has written the following code to add CHECK constraints to the Delta Lake table:

A senior engineer has confirmed the above logic is correct and the valid ranges for latitude and longitude are provided, but the code fails when executed.
Which statement explains the cause of this failure?

A. The activity details table already contains records that violate the constraints; all existing data must pass CHECK constraints in order to add them to an existing table.

B. The activity details table already exists; CHECK constraints can only be added during initial table creation.

C. Because another team uses this table to support a frequently running application, two-phase locking is preventing the operation from committing.

D. The current table schema does not contain the field valid coordinates; schema evolution will need to be enabled before altering the table to add a constraint.

E. The activity details table already contains records; CHECK constraints can only be added prior to inserting values into a table.

정답: A

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

문제2

A data engineer is performing a join operating to combine values from a static userlookup table with a streaming DataFrame streamingDF.
Which code block attempts to perform an invalid stream-static join?

A. streamingDF.join(userLookup, [ " user_id " ], how= " outer " )

B. userLookup.join(streamingDF, [ " user_id " ], how= " right " )

C. streamingDF.join(userLookup, [ " user_id"], how= " left " )

D. userLookup.join(streamingDF, [ " userid " ], how= " inner " )

E. streamingDF.join(userLookup, [ " userid " ], how= " inner " )

정답: B

설명: (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. The checkpoint directory will be used to track state information for the unique keys present in the join.

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

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

A data team is implementing an append-only Delta Lake pipeline that processes both batch and streaming data . They want to ensure that schema changes in the source data are automatically incorporated without breaking the pipeline.
Which configuration should the team use when writing data to the Delta table?

A. ignoreChanges = false

B. mergeSchema = true

C. overwriteSchema = true

D. validateSchema = false

정답: B

문제5

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. Create a new table for the analytics team using a CTAS statement.

B. Shallow clone the table for the analytics team.

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

D. Deep clone the table for the analytics team.

정답: B

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

문제6

In order to prevent accidental commits to production data, a senior data engineer has instituted a policy that all development work will reference clones of Delta Lake tables. After testing both deep and shallow clone, development tables are created using shallow clone.
A few weeks after initial table creation, the cloned versions of several tables implemented as Type 1 Slowly Changing Dimension (SCD) stop working. The transaction logs for the source tables show that vacuum was run the day before.
Why are the cloned tables no longer working?

A. Because Type 1 changes overwrite existing records, Delta Lake cannot guarantee data consistency for cloned tables.

B. The data files compacted by vacuum are not tracked by the cloned metadata; running refresh on the cloned table will pull in recent changes.

C. The metadata created by the clone operation is referencing data files that were purged as invalid by the vacuum command

D. Running vacuum automatically invalidates any shallow clones of a table; deep clone should always be used when a cloned table will be repeatedly queried.

정답: C

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

문제7

A data engineer is configuring Delta Sharing for a Databricks-to-Databricks scenario to optimize read performance. The recipient needs to perform time travel queries and streaming reads on shared sales data.
Which configuration will provide the optimal performance while enabling these capabilities?

A. Share the entire schema WITHOUT HISTORY and rely on recipient-side caching for performance.

B. Share tables WITHOUT HISTORY and enable partitioning for better query performance.

C. Share tables WITH HISTORY , ensure tables don't have partitioning enabled, and enable CDF before sharing.

D. Use the open sharing protocol instead of Databricks-to-Databricks sharing for better performance.

정답: C

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

문제8

A user wants to use DLT expectations to validate that a derived table report contains all records from the source, included in the table validation_copy.
The user attempts and fails to accomplish this by adding an expectation to the report table definition.
Which approach would allow using DLT expectations to validate all expected records are present in this table?

A. Define a SQL UDF that performs a left outer join on two tables, and check if this returns null values for report key values in a DLT expectation for the report table.

B. Define a temporary table that perform a left outer join on validation_copy and report, and define an expectation that no report key values are null

C. Define a function that performs a left outer join on validation_copy and report and report, and check against the result in a DLT expectation for the report table

D. Define a view that performs a left outer join on validation_copy and report, and reference this view in DLT expectations for the report table

정답: D

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

문제9

A table named user_ltv is being used to create a view that will be used by data analysis on various teams.
Users in the workspace are configured into groups, which are used for setting up data access using ACLs.
The user_ltv table has the following schema:

An analyze who is not a member of the auditing group executing the following query:

Which result will be returned by this query?

A. All age values less than 18 will be returned as null values all other columns will be returned with the values in user_ltv.

B. All columns will be displayed normally for those records that have an age greater than 17; records not meeting this condition will be omitted.

C. All columns will be displayed normally for those records that have an age greater than 18; records not meeting this condition will be omitted.

D. All records from all columns will be displayed with the values in user_ltv.

정답: C

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

문제10

The data science team has requested assistance in accelerating queries on free form text from user reviews.
The data is currently stored in Parquet with the below schema:
item_id INT, user_id INT, review_id INT, rating FLOAT, review STRING
The review column contains the full text of the review left by the user. Specifically, the data science team is looking to identify if any of 30 key words exist in this field.
A junior data engineer suggests converting this data to Delta Lake will improve query performance.
Which response to the junior data engineer s suggestion is correct?

A. Delta Lake statistics are only collected on the first 4 columns in a table.

B. Text data cannot be stored with Delta Lake.

C. The Delta log creates a term matrix for free text fields to support selective filtering.

D. Delta Lake statistics are not optimized for free text fields with high cardinality.

E. ZORDER ON review will need to be run to see performance gains.

정답: D

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

문제11

A CHECK constraint has been successfully added to the Delta table named activity_details using the following logic:

A batch job is attempting to insert new records to the table, including a record where latitude = 45.50 and longitude = 212.67.
Which statement describes the outcome of this batch insert?

A. The write will insert all records except those that violate the table constraints; the violating records will be reported in a warning log.

B. The write will include all records in the target table; any violations will be indicated in the boolean column named valid_coordinates.

C. The write will insert all records except those that violate the table constraints; the violating records will be recorded to a quarantine table.

D. The write will fail when the violating record is reached; any records previously processed will be recorded to the target table.

E. The write will fail completely because of the constraint violation and no records will be inserted into the target table.

정답: E

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

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

우리와 연락하기

유용한 링크

최신 업데이트