Free Access to Databricks.Databricks-Certified-Professional-Data-Engineer.v2026-02-09.q161 with Valid Practice Test (Page 24)

Question 111

Which of the following array functions takes input column return unique list of values in an array?

A.COLLECT_LIST
B.COLLECT_SET
C.COLLECT_UNION
D.ARRAY_INTERSECT
E.ARRAY_UNION

Question 112

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.

Correct Answer: C

In Databricks, catalogs, schemas (or databases), and tables are managed through the Unity Catalog or Hive Metastore, depending on the environment. Permissions and ownership within these structures are governed by access control lists (ACLs).
* Catalog and Schema Ownership:When a platform engineer creates a catalog (such as catalog_A) and schema (such as schema_A), they automatically become the owner of those entities. This ownership gives them control over granting permissions for those entities (i.e., granting the USE CATALOG and USE SCHEMA privileges to others). However, ownership of the catalog or schema doesnot automaticallyextend to ownership or permission of individual tables within that schema.
* Table Permissions:For tables within a schema, the permission model is more granular. The table creator (i.e., whoever creates the table) is automatically assigned as the owner of that table. In this case, the platform engineer owns the schema but does not automatically inherit permissions to any table created within the schema unless explicitly granted by the table's owner or unless they grant permissions to themselves.
* Why the Engineer Lacks Access:The platform engineer notices that they do not have access to the underlying tables in schema_A despite being the owner of the schema. This occurs because the schema's ownership does not cascade to the tables. The engineer must either:
* Grant permissions to themselves for the tables in schema_A, or
* Be granted permissions by whoever created the tables within the schema.
* Resolution:As the owner of the schema, the platform engineer can easily grant themselves the required permissions (such as SELECT, INSERT, etc.) for the tables in the schema. This explains why the owner of a schema may not automatically have access to the tables and must take explicit steps to acquire those permissions.
References
* Databricks Unity Catalog Documentation: Manage Permissions
* [Databricks Permissions and Ownership](https://docs.databricks.com/security/access-control
/workspace-acl.html#permissions

Question 113

Which of the following locations in Databricks product architecture hosts jobs/pipelines and queries?

A.Data plane
B.Control plane
C.Databricks Filesystem
D.JDBC data source
E.Databricks web application

Question 114

A streaming video analytics team ingests billions of events daily into a Unity Catalog-managed Delta table video_events. Analysts run ad-hoc point-lookup queries on columns like user_id, campaign_id, and region. The team manually runs OPTIMIZE video_events ZORDER BY (user_id, campaign_id, region), but still sees poor performance on recent data and dislikes the operational overhead. The team wants a hands-off way to keep hot columns co-located as query patterns evolve.

A.Schedule OPTIMIZE/ZORDER to run after each job to improve recent file performance.
B.Enable Delta caching.
C.Utilize Liquid Clustering (CLUSTER BY AUTO) and Predictive Optimization.
D.Enable auto-compaction (optimizeWrite and autoCompact).

Question 115

A table named user_ltv is being used to create a view that will be used by data analysis on various teams.
Users in the workspace are configured into groups, which are used for setting up data access using ACLs.
The user_ltv table has the following schema:

An analyze who is not a member of the auditing group executing the following query:

Which result will be returned by this query?

A.All columns will be displayed normally for those records that have an age greater than 18; records not meeting this condition will be omitted.
B.All columns will be displayed normally for those records that have an age greater than 17; records not meeting this condition will be omitted.
C.All age values less than 18 will be returned as null values all other columns will be returned with the values in user_ltv.
D.All records from all columns will be displayed with the values in user_ltv.

Question 111

Question 112

Question 113

Question 114

Question 115

Download PDF File