Understand Catalogs, Schemas, Managed and External Tables, Access Controls, Views, Certified Tables, and Lineage Within the Catalog Explorer Interface. DATA-ANALYST-ASSOCIATE Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   What is a view in Databricks?

   • AA virtual table based on a SQL query.
   • BA physical copy of data stored in a separate location.
   • CA table that is only accessible to the table owner.
   • DA table that is automatically updated with new data.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A data analyst is looking for a certified table that contains customer data. They open Catalog Explorer and see a list of catalogs. What is the most efficient way to find certified tables?

   • AUse the search bar and filter by certification status.
   • BAsk the data steward for a list of certified tables.
   • CCheck the lineage of each table to see if it is certified.
   • DBrowse through each catalog and schema to look for the certification badge.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company has three departments (Finance, Sales, and Engineering) that each need to store and query data in Databricks. The data engineering team wants to organize data so that each department can manage its own tables without affecting the others, and the security team wants to grant access at the highest possible level to minimize permission management overhead. What should the data engineering team create in the Databricks Unity Catalog hierarchy?

   • ACreate one table per department in a single schema, using table names prefixed with the department name.
   • BCreate one external location per department and reference it directly in queries without using catalogs or schemas.
   • CCreate one schema per department in a single shared catalog, with tables inside each schema.
   • DCreate one catalog per department, with schemas inside each catalog for different data domains.
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A data analyst frequently runs a query that joins the 'customers' and 'orders' tables and filters for active customers. They want to save this query so other analysts can use it without writing the join logic themselves. What should the analyst create in Catalog Explorer?

   • AA new managed table that stores the result of the query.
   • BA view that encapsulates the join and filter logic.
   • CAn external table that references the query result.
   • DA certified table that marks the query as trusted.
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A data engineer is migrating a set of tables from an external location to managed tables in Unity Catalog. They want to ensure that after the migration, the data is managed by Databricks and that lineage is preserved. What is the best approach?

   • ACreate new managed tables and copy the data from the external tables, then drop the external tables.
   • BDrop the external tables and recreate them as managed tables with the same name.
   • CCreate a view on top of the external tables and then convert the view to a managed table.
   • DAlter the external tables to become managed tables by removing the LOCATION property.
   Reveal Solution Discussion Select an answer first