최신 Databricks-Certified-Data-Engineer-Professional 무료덤프 - Databricks 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 Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from information is critical to this decision?

A. Delta Lake time travel does not scale well in cost or latency to provide a long-term versioning solution.

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. Delta Lake only supports Type 0 tables; once records are inserted to a Delta Lake table, they cannot be modified.

E. Shallow clones can be combined with Type 1 tables to accelerate historic queries for long-term versioning.

정답: A

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

문제2

A junior data engineer seeks to leverage Delta Lake's Change Data Feed functionality to create a Type 1 table representing all of the values that have ever been valid for all rows in a bronze table created with the property delta.enableChangeDataFeed = true. They plan to execute the following code as a daily job:
Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

Which statement describes the execution and results of running the above query multiple times?

A. Each time the job is executed, only those records that have been inserted or updated since the last execution will be appended to the target table giving the desired result.

B. Each time the job is executed, newly updated records will be merged into the target table, overwriting previous values with the same primary keys.

C. Each time the job is executed, the differences between the original and current versions are calculated; this may result in duplicate entries for some records.

D. Each time the job is executed, the entire available history of inserted or updated records will be appended to the target table, resulting in many duplicate entries.

E. Each time the job is executed, the target table will be overwritten using the entire history of inserted or updated records, giving the desired result.

정답: D

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

문제3

Review the following error traceback:
Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

Which statement describes the error being raised?

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

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

C. There is no column in the table named heartrateheartrateheartrate

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

E. The code executed was PvSoark but was executed in a Scala notebook.

정답: C

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

문제4

Which configuration parameter directly affects the size of a spark-partition upon ingestion of data into Spark?

A. spark.sql.adaptive.coalescePartitions.minPartitionNum

B. spark.sql.files.maxPartitionBytes

C. spark.sql.adaptive.advisoryPartitionSizeInBytes

D. spark.sql.files.openCostInBytes

E. spark.sql.autoBroadcastJoinThreshold

정답: B

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

문제5

A Delta Lake table representing metadata about content from user has the following schema:
Based on the above schema, which column is a good candidate for partitioning the Delta Table?

A. Post_time

B. latitude

C. Date

D. User_id

E. Post_id

정답: C

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

문제6

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 회원만 볼 수 있음)

문제7

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 회원만 볼 수 있음)

문제8

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 회원만 볼 수 있음)

문제9

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 회원만 볼 수 있음)

문제10

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 Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from 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. 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.

B. 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.

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

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

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

정답: E

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

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

우리와 연락하기

유용한 링크

최신 업데이트