Online Access Free Databricks-Certified-Data-Engineer-Professional Practice Test

A data pipeline uses Structured Streaming to ingest data from kafka to Delta Lake. Data is being stored in a bronze table, and includes the Kafka_generated timesamp, key, and value. Three months after the pipeline is deployed the data engineering team has noticed some latency issued during certain times of the day.
A senior data engineer updates the Delta Table's schema and ingestion logic to include the current timestamp (as recoded by Apache Spark) as well the Kafka topic and partition. The team plans to use the additional metadata fields to diagnose the transient processing delays.
Which limitation will the team face while diagnosing this problem?

• A.New fields not be computed for historic records.
• B.Updating the table schema requires a default value provided for each file added.
  Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from
• C.Updating the table schema will invalidate the Delta transaction log metadata.
• D.New fields cannot be added to a production Delta table.
• E.Spark cannot capture the topic partition fields from the kafka source.

Although the Databricks Utilities Secrets module provides tools to store sensitive credentials and avoid accidentally displaying them in plain text users should still be careful with which credentials are stored here and which users have access to using these secrets.
Which statement describes a limitation of Databricks Secrets?

• A.The Databricks REST API can be used to list secrets in plain text if the personal access token has proper credentials.
• B.Because the SHA256 hash is used to obfuscate stored secrets, reversing this hash will display Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from the value in plain text.
• C.Iterating through a stored secret and printing each character will display secret contents in plain text.
• D.Secrets are stored in an administrators-only table within the Hive Metastore; database administrators have permission to query this table by default.
• E.Account administrators can see all secrets in plain text by logging on to the Databricks Accounts console.

Assuming that the Databricks CLI has been installed and configured correctly, which Databricks CLI command can be used to upload a custom Python Wheel to object storage mounted with the DBFS for use with a production job?

• A.configure
• B.jobs
• C.fs
• D.libraries
• E.workspace

A Delta table of weather records is partitioned by date and has the below schema:
date DATE, device_id INT, temp FLOAT, latitude FLOAT, longitude FLOAT
To find all the records from within the Arctic Circle, you execute a query with the below filter:
latitude > 66.3
Which statement describes how the Delta engine identifies which files to load?

• A.The Parquet file footers are scanned for min and max statistics for the latitude column
• B.The Delta log is scanned for min and max statistics for the latitude column
• C.The Hive metastore is scanned for min and max statistics for the latitude column
• D.All records are cached to attached storage and then the filter is applied Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from
• E.All records are cached to an operational database and then the filter is applied

A Delta Lake table was created with the below query:
Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

Realizing that the original query had a typographical error, the below code was executed:
ALTER TABLE prod.sales_by_stor RENAME TO prod.sales_by_store
Which result will occur after running the second command?

• A.All related files and metadata are dropped and recreated in a single ACID transaction.
• B.The table reference in the metastore is updated and no data is changed.
• C.A new Delta transaction log Is created for the renamed table.
• D.The table name change is recorded in the Delta transaction log.
• E.The table reference in the metastore is updated and all data files are moved.