Databricks DATABRICKS Practice Questions

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 11

While investigating a performance issue, you realized that you have too many small files for a given table, which command are you going to run to fix this issue

Question 12

Create a sales database using the DBFS location

'dbfs:/mnt/delta/databases/sales.db/'

CREATE DATABASE sales FORMAT DELTA LOCATION

'dbfs:/mnt/delta/databases/sales.db/'’

CREATE DATABASE sales USING LOCATION

'dbfs:/mnt/delta/databases/sales.db/'

CREATE DATABASE sales LOCATION

'dbfs:/mnt/delta/databases/sales.db/'

The sales database can only be created in Delta lake

CREATE DELTA DATABASE sales LOCATION

'dbfs:/mnt/delta/databases/sales.db/'

Question 13

What is the type of table created when you issue SQL DDL command CREATE TABLE sales (id int, units int)

Question 14

How to determine if a table is a managed table vs external table?

Run IS_MANAGED(‘table_name’) function

All external tables are stored in data lake, managed tables are stored in DELTA lake

All managed tables are stored in unity catalog

Run SQL command DESCRIBE EXTENDED table_name and check type

A. Run SQL command SHOW TABLES to see the type of the table

Question 15

Which of the below SQL commands creates a session scoped temporary view?

CREATE OR REPLACE TEMPORARY VIEW view_name

AS SELECT * FROM table_name

CREATE OR REPLACE LOCAL TEMPORARY VIEW view_name

AS SELECT * FROM table_name

CREATE OR REPLACE GLOBAL TEMPORARY VIEW view_name

AS SELECT * FROM table_name

CREATE OR REPLACE VIEW view_name

AS SELECT * FROM table_name

CREATE OR REPLACE LOCAL VIEW view_name

AS SELECT * FROM table_name

Question 16

Drop the customers database and associated tables and data, all of the tables inside the database are managed tables. Which of the following SQL commands will help you accomplish this?

DROP DATABASE customers FORCE

DROP DATABASE customers CASCADE

DROP DATABASE customers INCLUDE

All the tables must be dropped first before dropping database

DROP DELTA DATABSE customers

Question 17

Define an external SQL table by connecting to a local instance of an SQLite database using JDBC

Question 18

When defining external tables using formats CSV, JSON, TEXT, BINARY any query on the external tables caches the data and location for performance reasons, so within a given spark session any new files that may have arrived will not be available after the initial query. How can we address this limitation?

Question 19

Which of the following table constraints that can be enforced on Delta lake tables are supported?

Primary key, foreign key, Not Null, Check Constraints

Primary key, Not Null, Check Constraints

Default, Not Null, Check Constraints

Not Null, Check Constraints

Unique, Not Null, Check Constraints

Question 20

The data engineering team is looking to add a new column to the table, but the QA team would like to test the change before implementing in production, which of the below options allow you to quickly copy the table from Prod to the QA environment, modify and run the tests?

Update History

Update History