Online Access Free Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-03-10.q102 Practice Test (Page 12)

Databricks-Certified-Professional-Data-Engineer Exam Question 51

Which of the following command can be used to drop a managed delta table and the underlying files in the storage?

A.DROP TABLE table_name CASCADE

B.DROP TABLE table_name

C.Use DROP TABLE table_name command and manually delete files using com-mand dbutils.fs.rm("/path",True)

D.DROP TABLE table_name INCLUDE_FILES

E.DROP TABLE table and run VACUUM command

Databricks-Certified-Professional-Data-Engineer Exam Question 52

You are working on a table called orders which contains data for 2021 and you have the second table called orders_archive which contains data for 2020, you need to combine the data from two tables and there could be a possibility of the same rows between both the tables, you are looking to combine the results from both the tables and eliminate the duplicate rows, which of the following SQL statements helps you accomplish this?

A.SELECT * FROM orders UNION SELECT * FROM orders_archive
(Correct)

B.SELECT * FROM orders INTERSECT SELECT * FROM orders_archive

C.SELECT * FROM orders UNION ALL SELECT * FROM orders_archive

D.SELECT * FROM orders_archive MINUS SELECT * FROM orders

E.SELECT distinct * FROM orders JOIN orders_archive on order.id = or-ders_archive.id

Databricks-Certified-Professional-Data-Engineer Exam Question 53

identifies if its needs to be converted to Fahrenheit or Celcius with a one-word letter F or C?
select udf_convert(60,'C') will result in 15.5
select udf_convert(10,'F') will result in 50

A.1. CREATE UDF FUNCTION udf_convert(temp DOUBLE, measure STRING)
2. RETURNS DOUBLE
3. RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
4. ELSE (temp - 33 ) * 5/9
5. END

B.1.CREATE UDF FUNCTION udf_convert(temp DOUBLE, measure STRING)
2. RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
3. ELSE (temp - 33 ) * 5/9
4. END

C.1.CREATE FUNCTION udf_convert(temp DOUBLE, measure STRING)
2.RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
3. ELSE (temp - 33 ) * 5/9
4. END

D.1.CREATE FUNCTION udf_convert(temp DOUBLE, measure STRING)
2.RETURNS DOUBLE
3.RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
4. ELSE (temp - 33 ) * 5/9
5. END
(Correct)

E.1.CREATE USER FUNCTION udf_convert(temp DOUBLE, measure STRING)
2.RETURNS DOUBLE
3.RETURN CASE WHEN measure == 'F' then (temp * 9/5) + 32
4. ELSE (temp - 33 ) * 5/9
5.END

Databricks-Certified-Professional-Data-Engineer Exam Question 54

You are still noticing slowness in query after performing optimize which helped you to resolve the small files problem, the column(transactionId) you are using to filter the data has high cardinality and auto incrementing number. Which delta optimization can you enable to filter data effectively based on this column?

A.Create BLOOM FLTER index on the transactionId

B.Perform Optimize with Zorder on transactionId
(Correct)

C.transactionId has high cardinality, you cannot enable any optimization.

D.Increase the cluster size and enable delta optimization

E.Increase the driver size and enable delta optimization

Databricks-Certified-Professional-Data-Engineer Exam Question 55

You are asked to write a python function that can read data from a delta table and return the Data-Frame, which of the following is correct?

A.Python function cannot return a DataFrame

B.Write SQL UDF to return a DataFrame

C.Write SQL UDF that can return tabular data

D.Python function will result in out of memory error due to data volume

E.Python function can return a DataFrame

Other Version: 1311Databricks.Databricks-Certified-Professional-Data-Engineer.v2025-06-26.q60; 1940Databricks.Databricks-Certified-Professional-Data-Engineer.v2024-11-21.q117; 663Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-10-09.q24; 702Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-02-09.q22; 1001Databricks.Databricks-Certified-Professional-Data-Engineer.v2022-09-06.q21

Latest Upload: 121Databricks.Databricks-Certified-Data-Analyst-Associate.v2025-12-22.q27; 126SAP.C_ARSOR_2404.v2025-12-22.q38; 121LinuxFoundation.CKS.v2025-12-22.q76; 122ISACA.CISA-CN.v2025-12-21.q601; 124Nutanix.NCP-CN.v2025-12-21.q49; 119Fortinet.FCSS_LED_AR-7.6.v2025-12-21.q42; 127Cloudera.CDP-3002.v2025-12-21.q157; 213Microsoft.AZ-400.v2025-12-21.q278; 273ISACA.CISM.v2025-12-21.q445; 125CompTIA.DA0-002.v2025-12-21.q55

Databricks-Certified-Professional-Data-Engineer Exam Question 51

Databricks-Certified-Professional-Data-Engineer Exam Question 52

Databricks-Certified-Professional-Data-Engineer Exam Question 53

Databricks-Certified-Professional-Data-Engineer Exam Question 54

Databricks-Certified-Professional-Data-Engineer Exam Question 55

Download PDF File