• SQL commands are used to append rows to an existing delta table:

• Learn about OPTIMIZE

• CREATE DATABASE command —

• DROP DATABASE

• constraints that can be enforced on Delta lake tables are supported?

• DEEP CLONE vs SHADOW CLONE

• Spark’s structured stream supports the below write mode

• cloudFiles.SchemLocation, checkpointLocation

• A DELTA LIVE TABLE pipelines can be scheduled to run in two different modes, what are these two different modes?

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

• Use databricks cluster pool feature to reduce the startup time

• CI/CD in databricks

• Databricks repo - allows you to add comment and select changes you want to commit instead of databrucks allow you for merge and conflict resoliution
• DROP database and all associated tables and views
  • DROP DATABASE db CASCADE
• Read from a SQLLITE DB

CREATE TABLE users_jdbc
USING org.apache.spark.sql.jdbc
OPTIONS
	(
		url='jdbc:sqlite:/sample_db',
		dbtable='users'
	)

-- Template
CREATE TABLE <jdbcTable>
USING org.apache.spark.sql.jdbc or JDBC
OPTIONS (
    url = "jdbc:<databaseServerType>://<jdbcHostname>:<jdbcPort>",
    dbtable " = <jdbcDatabase>.atable",
    user = "<jdbcUsername>",
    password = "<jdbcPassword>"
)

• REFRESH TABLE to remove cache from external table