Free Access Databricks.Databricks-Certified-Professional-Data-Engineer.v2026-11-02.q167 Practice Test (Page 4)

Question 11

The Databricks workspace administrator has configured interactive clusters for each of the data engineering groups. To control costs, clusters are set to terminate after 30 minutes of inactivity. Each user should be able to execute workloads against their assigned clusters at any time of the day.
Assuming users have been added to a workspace but not granted any permissions, which of the following describes the minimal permissions a user would need to start and attach to an already configured cluster.

A."Can Manage" privileges on the required cluster

B.Workspace Admin privileges, cluster creation allowed. "Can Attach To" privileges on the required cluster

C.Cluster creation allowed. "Can Attach To" privileges on the required cluster

D."Can Restart" privileges on the required cluster

E.Cluster creation allowed. "Can Restart" privileges on the required cluster

Question 12

You have noticed the Data scientist team is using the notebook versioning feature with git integra-tion, you have recommended them to switch to using Databricks Repos, which of the below reasons could be the reason the why the team needs to switch to Databricks Repos.

A.Databricks Repos allows multiple users to make changes

B.Databricks Repos allows merge and conflict resolution

C.Databricks Repos has a built-in version control system

D.Databricks Repos automatically saves changes

E.Databricks Repos allow you to add comments and select the changes you want to commit.

Question 13

A data team ' s Structured Streaming job is configured to calculate running aggregates for item sales to update a downstream marketing dashboard. The marketing team has introduced a new field to track the number of times this promotion code is used for each item. A junior data engineer suggests updating the existing query as follows: Note that proposed changes are in bold.

Which step must also be completed to put the proposed query into production?

A.Increase the shuffle partitions to account for additional aggregates

B.Specify a new checkpointlocation

C.Run REFRESH TABLE delta, /item_agg '

D.Remove .option (mergeSchema ' , true ' ) from the streaming write

Question 14

A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above
format regardless of whether a table already exists with this name?

A.1. CREATE OR REPLACE TABLE table_name AS
2. SELECT id STRING, birthDate DATE, avgRating FLOAT USING DELTA

B.1. CREATE OR REPLACE TABLE table_name ( id STRING, birthDate DATE, avgRating FLOAT )

C.1. CREATE TABLE table_name AS
2. SELECT id STRING, birthDate DATE, avgRating FLOAT

D.1. CREATE OR REPLACE TABLE table_name
2. WITH COLUMNS ( id STRING, birthDate DATE, avgRating FLOAT ) USING DELTA

E.1. CREATE TABLE IF NOT EXISTS table_name ( id STRING, birthDate DATE, avgRating FLOAT )

Question 15

A team of data engineer are adding tables to a DLT pipeline that contain repetitive expectations for many of the same data quality checks.
One member of the team suggests reusing these data quality rules across all tables defined for this pipeline.
What approach would allow them to do this?

A.Maintain data quality rules in a Delta table outside of this pipeline's target schema, providing the schema name as a pipeline parameter.

B.Use global Python variables to make expectations visible across DLT notebooks included in the same pipeline.

C.Add data quality constraints to tables in this pipeline using an external job with access to pipeline configuration files.

D.Maintain data quality rules in a separate Databricks notebook that each DLT notebook of file.

Other Version: 3041Databricks.Databricks-Certified-Professional-Data-Engineer.v2025-11-20.q139; 1900Databricks.Databricks-Certified-Professional-Data-Engineer.v2025-10-30.q132; 2487Databricks.Databricks-Certified-Professional-Data-Engineer.v2024-03-27.q76; 2084Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-12-11.q54

Latest Upload: 158Microsoft.MB-820.v2026-11-04.q131; 142F5.402.v2026-11-04.q51; 244EC-COUNCIL.712-50.v2026-11-03.q200; 178PaloAltoNetworks.NGFW-Engineer.v2026-11-03.q111; 175Cisco.350-501.v2026-11-03.q520; 136CIRO.CIRE.v2026-11-03.q40; 155Guidewire.InsuranceSuite-Analyst.v2026-11-02.q41; 150Salesforce.Analytics-Admn-201.v2026-11-02.q49; 143NetworkAppliance.NS0-901.v2026-11-02.q37; 172ITIL.ITIL-4-Foundation.v2026-11-02.q128

Question 11

Question 12

Question 13

Question 14

Question 15

Download PDF File