Online Access Free Databricks-Certified-Professional-Data-Engineer Practice Test

A data engineer wants to enforce the principle of least privilege when configuring ACLs for Databricks jobs in a collaborative workspace.
Which approach should the data engineer use?

• A.Grant all users CAN MANAGE permission on all jobs to avoid access issues.
• B.Grant CAN RUN permission to everyone and CAN MANAGE to a single admin group.
• C.Use only folder-level permissions and avoid setting permissions on individual jobs.
• D.Assign users only the minimum permission level (e.g., CAN RUN or CAN VIEW) required for their role on each job.

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

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

A DLT pipeline includes the following streaming tables:
Raw_lot ingest raw device measurement data from a heart rate tracking device.
Bgm_stats incrementally computes user statistics based on BPM measurements from raw_lot.
How can the data engineer configure this pipeline to be able to retain manually deleted or updated records in the raw_iot table while recomputing the downstream table when a pipeline update is run?

• A.Set the SkipChangeCommits flag to true raw_lot
• B.Set the pipelines, reset, allowed property to false on raw_iot
• C.Set the skipChangeCommits flag to true on bpm_stats
• D.Set the pipelines, reset, allowed property to false on bpm_stats

A data team is implementing an append-only Delta Lake pipeline that processes both batch and streaming data . They want to ensure that schema changes in the source data are automatically incorporated without breaking the pipeline.
Which configuration should the team use when writing data to the Delta table?

• A.ignoreChanges = false
• B.overwriteSchema = true
• C.mergeSchema = true
• D.validateSchema = false

A platform team lead is responsible for automating SQL Warehouse usage attribution across business units.
They need to identify warehouse usage at the individual user level and share a daily usage report with an executive team that includes business leaders from multiple departments.
How should the platform lead generate an automated report that can be shared daily?

• A.Restrict users from running SQL queries unless they provide query details for attribution tracking.
• B.Let users run queries normally and have individual teams manually report usage to the executive team.
• C.Use system tables to capture audit and billing usage data and share the queries with the executive team for manual execution.
• D.Use system tables to capture audit and billing usage data and create a dashboard with a daily refresh schedule shared with the executive team.