Databricks · Databricks Data Analyst Associate
Catalog Explorer and Unity Catalog objects
Databricks Data Analyst Associate · Lesson 2 of 18 · 9:12
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Analyst Associate exam. In this lesson: browsing catalogs, schemas, and objects in Catalog Explorer (columns, sample data, details, permissions, history, and lineage), managed and external tables, UNDROP, standard and dynamic views, and metric views queried with the MEASURE function. Includes three original practice questions.
Preview the topics
- A store manager asks which groups can read the gold sales table, and wants the finance group added, with read access only. The analyst prefers the interface to SQL. Where should the analyst go?
- Each regional manager at Cobbleway must see only the sales of their own region, from one shared object, and the data must stay current without any copy. What should the analyst create?
- Three dashboards at Cobbleway compute revenue in three different ways, and each team wants revenue by region, by month, or by store. Which object gives everyone one definition of revenue?