Exit DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Databricks Certified Data Engineer Professional
Question 5 of 5
0% complete
Q5 Single choice

A platform engineer is creating catalogs and schemas for the development team to use.

The engineer has created an initial catalog, catalog_A, and initial schema, schema_A. The engineer has
also granted USE CATALOG, USE

SCHEMA, and CREATE TABLE to the development team so that the engineer can begin populating the schema with new tables.

Despite being owner of the catalog and schema, the engineer noticed that they do not have access to the underlying tables in Schema_A.

What explains the engineer's lack of access to the underlying tables?

  • A

    The platform engineer needs to execute a REFRESH statement as the table permissions did not automatically update for owners.

  • B

    Users granted with USE CATALOG can modify the owner's permissions to downstream tables.

  • C

    The owner of the schema does not automatically have permission to tables within the schema, but can grant them to themselves at anypoint.

  • D

    Permissions explicitly given by the table creator are the only way the Platform Engineer could access the underlying tables in their schema.