Managing Data Questions
Practice questions for Managing Data topic in Databricks Certified Data Analyst Associate. 16 questions covering this domain.
An analyst wants to query data in a Unity Catalog table and also review its column descriptions and table-level comments. Which Databricks SQL command...
A data analyst is working with a Unity Catalog managed table and wants to revert a destructive `DELETE` operation that was run 30 minutes ago. Which a...
In Unity Catalog, what is the difference between a managed table and an external table regarding data lifecycle?
A data engineering team is managing a Unity Catalog external table backed by Parquet files in an S3 bucket. After running ETL pipelines that added, mo...
A data analyst runs a query that accidentally deletes 10,000 rows from a production Delta table. The table has been receiving new inserts for the past...
Which SQL command is used to permanently remove a table definition and its managed data files from Unity Catalog?
A data analyst needs to query data from a table and also see its partition columns, clustering information, and the physical storage location. Which S...
A table owner drops a Unity Catalog managed table. What happens to the underlying data files?
Analysts query an external Parquet table, but files in the backing cloud location were added and removed outside Databricks. Which command should refr...
Thirty minutes ago, a DELETE removed valid rows from a production Delta table. Since then, new rows have been inserted and must be preserved. What is ...
An analyst wants to inspect yesterday's version of a Delta table without changing the current table state. Which capability should they use?
Thirty minutes ago, a DELETE removed valid rows from a production Delta table. Since then, new rows have been inserted and those newer rows must be ke...
Analysts query an external Parquet table, but files in the backing cloud location were added and removed outside Databricks. Which command should be r...
Which SQL command returns table details such as partition columns, clustering information, and storage location in one place?
An analyst needs to inspect a Delta table exactly as it looked yesterday without changing the table's current state. Which capability should the analy...
What happens to the underlying data files when a Unity Catalog managed table is dropped?
Sign in to see all 16 questions
Create a free account to browse all questions — completely free during our launch phase.