Free Access Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-12-11.q54 Practice Test (Page 5)

Question 16

You are currently working on a project that requires the use of SQL and Python in a given note-book, what would be your approach

A.Create two separate notebooks, one for SQL and the second for Python

B.A single notebook can support multiple languages, use the magic command to switch between the two.

C.Use an All-purpose cluster for python, SQL endpoint for SQL

D.Use job cluster to run python and SQL Endpoint for SQL

Question 17

Which of the below SQL commands create a Global temporary view?

A.1.CREATE OR REPLACE TEMPORARY VIEW view_name
2. AS SELECT * FROM table_name

B.1. CREATE OR REPLACE LOCAL TEMPORARY VIEW view_name
2. AS SELECT * FROM table_name

C.1. CREATE OR REPLACE GLOBAL TEMPORARY VIEW view_name
2. AS SELECT * FROM table_name
(Correct)

D.1.CREATE OR REPLACE VIEW view_name
2. AS SELECT * FROM table_name

E.1. CREATE OR REPLACE LOCAL VIEW view_name
2. AS SELECT * FROM table_name

Question 18

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

Question 19

if you run the command VACUUM transactions retain 0 hours? What is the outcome of this command?

A.Command will be successful, but no data is removed

B.Command will fail if you have an active transaction running

C.Command will fail, you cannot run the command with retentionDurationcheck enabled

D.Command will be successful, but historical data will be removed

E.Command runs successful and compacts all of the data in the table

Question 20

Which of the following two options are supported in identifying the arrival of new files, and incre-mental data from Cloud object storage using Auto Loader?

A.Directory listing, File notification

B.Checking pointing, watermarking

C.Writing ahead logging, read head logging

D.File hashing, Dynamic file lookup

E.Checkpointing and Write ahead logging

Other Version: 2983Databricks.Databricks-Certified-Professional-Data-Engineer.v2025-11-20.q139; 1854Databricks.Databricks-Certified-Professional-Data-Engineer.v2025-10-30.q132; 2433Databricks.Databricks-Certified-Professional-Data-Engineer.v2024-03-27.q76

Latest Upload: 135InsuranceLicensing.InsNV_Health02.v2026-10-23.q44; 207Juniper.JN0-452.v2026-10-23.q141; 266EC-COUNCIL.312-38.v2026-10-22.q321; 134WGU.Health-Fitness-and-Wellness.v2026-10-21.q14; 168ISACA.COBIT-Design-and-Implementation.v2026-10-21.q57; 187NACE.NACE-CIP2-001.v2026-10-21.q36; 244Cisco.400-007.v2026-10-21.q176; 214F5.301a.v2026-10-21.q97; 176Oracle.1z0-1195-26.v2026-10-19.q18; 168Salesforce.Salesforce-Slack-Administrator.v2026-10-19.q126

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File