Databricks-Certified-Data-Engineer-Professional Exam Question 71

A data engineer is working on a Databricks notebook that requires several third-party Python libraries. Some of these are available on PyPI, while others are custom-developed and stored as local.wheel (.whl) and source (.tar.gz) files in an S3 bucket. The goal is to ensure all dependencies are installed and correctly available across multiple jobs running on any automated cluster in a Unity Catalog-enabled workspace. The engineer needs to install the required dependencies in a way that ensures a consistent environment setup across interactive notebooks and jobs and complies with workspace security policies (no internet access). Which approach should the engineer use to install and manage these dependencies while also ensuring reproducibility and compliance?
  • Databricks-Certified-Data-Engineer-Professional Exam Question 72

    The DevOps team has configured a production workload as a collection of notebooks scheduled to run daily using the Jobs UI. A new data engineering hire is onboarding to the team and has requested access to one of these notebooks to review the production logic.
    What are the maximum notebook permissions that can be granted to the user without allowing accidental changes to production code or data?
  • Databricks-Certified-Data-Engineer-Professional Exam Question 73

    To reduce storage and compute costs, the data engineering team has been tasked with curating a series of aggregate tables leveraged by business intelligence dashboards, customer-facing applications, production machine learning models, and ad hoc analytical queries.
    The data engineering team has been made aware of new requirements from a customer-facing application, which is the only downstream workload they manage entirely. As a result, an aggregate table used by numerous teams across the organization will need to have a number of fields renamed, and additional fields will also be added.
    Which of the solutions addresses the situation while minimally interrupting other teams in the organization without increasing the number of tables that need to be managed?
  • Databricks-Certified-Data-Engineer-Professional Exam Question 74

    A data engineer wants to refactor the following DLT code, which includes multiple table definitions with very similar code.

    In an attempt to programmatically create these tables using a parameterized table definition, the data engineer writes the following code.

    The pipeline runs an update with this refactored code, but generates a different DAG showing incorrect configuration values for these tables.
    How can the data engineer fix this?
  • Databricks-Certified-Data-Engineer-Professional Exam Question 75

    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?