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

Prepare Your Databricks Databricks-Certified-Professional-Data-Engineer Exam Questions with Free online Databricks-Certified-Professional-Data-Engineer Practice Test. Get Brilliant Databricks Certified Professional Data Engineer Exam Results with Valid Databricks Certified Professional Data Engineer Exam Dumps.

Page: 1 / 40

Total 198 Questions | Updated On: May 13, 2024

Add To Cart

Question 1

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 : date = spark.conf.get("date")

B : input_dict = input() date= input_dict["date"]

C : import sys date = sys.argv[1]

D : date = dbutils.notebooks.getParam("date")

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

Answer: E

Question 2

The Databricks workspace administrator has configured interactive clusters for each of the data engineering

groups. To control costs, clusters are set to terminate after 30 minutes of inactivity. Each user should be able to

execute workloads against their assigned clusters at any time of the day.

Assuming users have been added to a workspace but not granted any permissions, which of the following

describes the minimal permissions a user would need to start and attach to an already configured cluster.

A : "Can Manage" privileges on the required cluster

B : Workspace Admin privileges, cluster creation allowed, "Can Attach To" privileges on the required cluster

C : Cluster creation allowed, "Can Attach To" privileges on the required cluster

D : "Can Restart" privileges on the required cluster

E : Cluster creation allowed, "Can Restart" privileges on the required cluster

Answer: A

Question 3

A data engineer wants to use Databricks REST API to retrieve the metadata of a job run using its run_id.

Which of the following REST API calls achieves this requirement ?

A : Send POST request to the endpoint ‘api/2.1/jobs/runs/get’

B : Send GET request to the endpoint ‘api/2.1/jobs/runs/get’

C : Send POST request to the endpoint ‘api/2.1/jobs/runs/get-output’

D : Send GET request to the endpoint ‘api/2.1/jobs/runs/get-output’

E : Send GET request to the endpoint ‘api/2.1/jobs/runs/get-metadata’

Answer: B

Question 4

Which of the following statements best describes Delta Lake Auto Compaction?

A : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job with Z-Ordering toward a file size of 128 MB

B : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job without Z-Ordering toward a file size of 128 MB

C : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job with Z-Ordering toward a file size of 1 GB.

D : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job without Z-Ordering toward a file size of 1 GB.

E : None of the above statements correctly describe Delta Lake Auto Compaction.

Answer: B

Question 5

The data engineering team maintains the following code:

Assuming that this code produces logically correct results and the data in the source table has been deduplicated and validated, which statement describes what will occur when this code is executed?

A : The silver_customer_sales table will be overwritten by aggregated values calculated from all records in the gold_customer_lifetime_sales_summary table as a batch job.

B : A batch job will update the gold_customer_lifetime_sales_summary table, replacing only those rows that have different values than the current version of the table, using customer_id as the primary key.

C : The gold_customer_lifetime_sales_summary table will be overwritten by aggregated values calculated from all records in the silver_customer_sales table as a batch job.

D : An incremental job will leverage running information in the state store to update aggregate values in the gold_customer_lifetime_sales_summary table.

E : An incremental job will detect if new rows have been written to the silver_customer_sales table; if new rows are detected, all aggregates will be recalculated and used to overwrite the gold_customer_lifetime_sales_summary table.

Answer: E

Page: 1 / 40

Total 198 Questions | Updated On: May 13, 2024

Add To Cart