Databricks DATABRICKS Practice Questions - Page 6

The latest changes and updates from the administration for this exam.

verified

Latest Update: May 14 2026

All questions are working fine.

All Questions (225)bookmarkBookmarked (0)

All225Show all accessible questions in this exam.Missed225Questions you haven't attempted yet.Incorrect0Questions you answered incorrectly on your last attempt.

Question 51

While investigating a data issue, you wanted to review yesterday's version of the table using below command, while querying the previous version of the table using time travel you realized that you are no longer able to view the historical data in the table and you could see it the table was updated yesterday based on the table history(DESCRIBE HISTORY table_name) command what could be the reason why you can not access this data?

SELECT * FROM table_name TIMESTAMP AS OF date_sub(current_date(), 1)

You currently do not have access to view historical data

By default, historical data is cleaned every 180 days in DELTA

A command VACUUM table_name RETAIN 0 was ran on the table

Time travel is disabled

Time travel must be enabled before you query previous data

Question 52

You have accidentally deleted records from a table called transactions, what is the easiest way to restore the records deleted or the previous state of the table? Prior to deleting the version of the table is 3 and after delete the version of the table is 4.

Question 53

Create a schema called bronze using location ‘/mnt/delta/bronze’, and check if the schema exists before creating.

CREATE SCHEMA IF NOT EXISTS bronze LOCATION '/mnt/delta/bronze'

CREATE SCHEMA bronze IF NOT EXISTS LOCATION '/mnt/delta/bronze'

if IS_SCHEMA('bronze'): CREATE SCHEMA bronze LOCATION '/mnt/delta/bronze'

Schema creation is not available in metastore, it can only be done in Unity catalog UI

Cannot create schema without a database

Question 54

How do you check the location of an existing schema in Delta Lake?

Run SQL command SHOW LOCATION schema_name

Check unity catalog UI

Use Data explorer

Run SQL command DESCRIBE SCHEMA EXTENDED schema_name

Schemas are internally in-store external hive meta stores like MySQL or SQL Server

Question 55

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

Question 56

When you drop a managed table using SQL syntax DROP TABLE table_name how does it impact metadata, history, and data stored in the table?

Drops table from meta store, drops metadata, history, and data in storage.

Drops table from meta store and data from storage but keeps metadata and history in storage

Drops table from meta store, meta data and history but keeps the data in storage

Drops table but keeps meta data, history and data in storage

Drops table and history but keeps meta data and data in storage

Question 57

The team has decided to take advantage of table properties to identify a business owner for each table, which of the following table DDL syntax allows you to populate a table property identifying the business owner of a table

Question 58

Data science team has requested they are missing a column in the table called average price, this can be calculated using units sold and sales amt, which of the following SQL statements allow you to reload the data with additional column

Question 59

You are working on a process to load external CSV files into a delta table by leveraging the COPY INTO command, but after running the command for the second time no data was loaded into the table name, why is that?

COPY INTO only works one time data load

Run REFRESH TABLE sales before running COPY INTO

COPY INTO did not detect new files after the last load

Use incremental = TRUE option to load new files

COPY INTO does not support incremental load, use AUTO LOADER

Question 60

What is the main difference between the below two commands?

INSERT OVERWRITE replaces data by default, CREATE OR REPLACE replaces data and Schema by default

INSERT OVERWRITE replaces data and schema by default, CREATE OR REPLACEreplaces data by default

INSERT OVERWRITE maintains historical data versions by default, CREATE OR REPLACEclears the historical data versions by default

INSERT OVERWRITE clears historical data versions by default, CREATE OR REPLACE maintains the historical data versions by default

Both are same and results in identical outcomes

Update History

Update History