Databricks Certified Data Engineer Professional Sample Questions:

1. When a new Databricks project starts, the central IP team provisions the required infrastructure using Terraform and a Service Principal. This includes creating a Databricks workspace, a Unity Catalog linked to an External Location, and a Databricks group containing all project team members. Project teams must store all assets - e.g., tables and volumes, as Managed assets in Unity Catalog. This model hides infrastructure complexity while giving teams autonomy within their catalog. They can create and manage schemas, tables, volumes, and related objects but cannot rename, delete, or change catalog permissions, those remain under IT's control. Which rights should the project group be granted to enable this model?

A) The group should be made OWNER of the catalog.
B) The group needs to have ALL PRIVILEGES on the catalog.
C) The group needs to have ALL PRIVILEGES and the MANAGE on the catalog.
D) The group needs to have USE CATALOG and USE SCHEMA on the catalog.

2. A platform engineer needs to report the resource consumption, categorized by SKU tier, across all workspaces. The engineer decides to use the system.billing.usage system table to create a query. Which SQL query will accurately return the daily usage by product?

A)

B)

C)

D)

3. 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 owner of the schema does not automatically have permission to tables within the schema, but can grant them to themselves at any point.
B) Permissions explicitly given by the table creator are the only way the Platform Engineer could access the underlying tables in their schema.
C) Users granted with USE CATALOG can modify the owner's permissions to downstream tables.
D) The platform engineer needs to execute a REFRESH statement as the table permissions did not automatically update for owners.

4. Which REST API call can be used to review the notebooks configured to run as tasks in a multi- task job?

A) /jobs/runs/get
B) /jobs/runs/list
C) /jobs/runs/get-output
D) /jobs/list
E) /jobs/get

5. A large company seeks to implement a near real-time solution involving hundreds of pipelines with parallel updates of many tables with extremely high volume and high velocity data.
Which of the following solutions would you implement to achieve this requirement?

A) Configure Databricks to save all data to attached SSD volumes instead of object storage, increasing file I/O significantly.
B) Partition ingestion tables by a small time duration to allow for many data files to be written in parallel.
C) Use Databricks High Concurrency clusters, which leverage optimized cloud storage connections to maximize data throughput.
D) Store all tables in a single database to ensure that the Databricks Catalyst Metastore can load balance overall throughput.
E) Isolate Delta Lake tables in their own storage containers to avoid API limits imposed by cloud vendors.

Solutions: