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 41

Which of the following is true, when building a Databricks SQL dashboard?

A dashboard can only use results from one query

Only one visualization can be developed with one query result

A dashboard can only connect to one schema/Database

More than one visualization can be developed using a single query result

A dashboard can only have one refresh schedule

Question 42

A newly joined team member John Smith in the Marketing team currently has access read access to sales tables but does not have access to update the table, which of the following commands help you accomplish this?

GRANT UPDATE ON TABLE table_name TO [email protected]

GRANT USAGE ON TABLE table_name TO [email protected]

GRANT MODIFY ON TABLE table_name TO [email protected]

GRANT UPDATE TO TABLE table_name ON [email protected]

GRANT MODIFY TO TABLE table_name ON [email protected]

Question 43

A new user who currently does not have access to the catalog or schema is requesting access to the customer table in sales schema, but the customer table contains sensitive information, so you have decided to create view on the table excluding columns that are sensitive and granted access to the view GRANT SELECT ON view_name to [email protected] but when the user tries to query the view, gets the error view does not exist. What is the issue preventing user to access the view and how to fix it?

User requires SELECT on the underlying table

User requires to be put in a special group that has access to PII data

User has to be the owner of the view

User requires USAGE privilege on Sales schema

User needs ADMIN privilege on the view

Question 44

How do you access or use tables in the unity catalog?

schema_name.table_name

schema_name.catalog_name.table_name

catalog_name.table_name

catalog_name.database_name.schema_name.table_name

catalog_name.schema_name.table_name

Question 45

How do you upgrade an existing workspace managed table to a unity catalog table?

ALTER TABLE table_name SET UNITY_CATALOG = TRUE

Create table catalog_name.schema_name.table_name

as select * from hive_metastore.old_schema.old_table

Create table table_name as select * from hive_metastore.old_schema.old_table

Create table table_name format = UNITY as select * from old_table_name

Create or replace table_name format = UNITY using deep clone old_table_name

Question 46

Which of the statements is correct when choosing between lakehouse and Datawarehouse?

Traditional Data warehouses have special indexes which are optimized for Machine learning

Traditional Data warehouses can serve low query latency with high reliability for BI workloads

SQL support is only available for Traditional Datawarehouse’s, Lakehouses support Python and Scala

Traditional Data warehouses are the preferred choice if we need to support ACID, Lakehouse does not support ACID.

Lakehouse replaces the current dependency on data lakes and data warehouses uses an open standard storage format and supports low latency BI workloads.

Question 47

Where are Interactive notebook results stored in Databricks product architecture?

Question 48

Which of the following statements are true about a lakehouse?

Lakehouse only supports Machine learning workloads and Data warehouses support BI workloads

Lakehouse only supports end-to-end streaming workloads and Data warehouses support Batch workloads

Lakehouse does not support ACID

Lakehouse do not support SQL

Lakehouse supports Transactions

Question 49

Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?

Question 50

When investigating a data issue you realized that a process accidentally updated the table, you want to query the same table with yesterday's version of the data so you can review what the prior version looks like, what is the best way to query historical data so you can do your analysis?

SELECT * FROM TIME_TRAVEL(table_name) WHERE time_stamp = 'timestamp'

TIME_TRAVEL FROM table_name WHERE time_stamp = date_sub(current_date(), 1)

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

DISCRIBE HISTORY table_name AS OF date_sub(current_date(), 1)

SHOW HISTORY table_name AS OF date_sub(current_date(), 1)

Update History

Update History