What is the Databricks Delta command to display metadata?
MSCK DETAIL tablename
DESCRIBE DETAIL tableName
SHOW SCHEMA tablename
How do you perform UPSERT in a Delta dataset?
Use UPSERT INTO my-table
Use UPSERT INTO my-table /MERGE
Use MERGE INTO my-table USING data-to-upsert
What optimization does the following command perform: OPTIMIZE Students ZORDER BY Grade?
Creates an order-based index on the Grade field to improve filters against that field
Ensures that all data backing, for example, Grade=8 is colocated, then updates a graph that routes requests to the appropriate files
Ensures that all data backing, for example, Grade=8 is colocated, then rewrites the sorted data into new Parquet files
What size does OPTIMIZE compact small files to?
Around 100 MB
Around 1 GB
Around 500 MB
You must answer all questions before checking your work.
Need help? See our troubleshooting guide or provide specific feedback by reporting an issue.