A data engineering team needs a compute resource that automatically shuts down between scheduled runs to control cost and only runs a single nightly ETL notebook. Which Azure Databricks compute type is the most appropriate choice?
Set Up Configure Environment
Question · Easy
Wedding seating, as a LEFT JOIN
Short
You want clusters that can be reused across the team to access Unity Catalog data while supporting multiple concurrent users with data isolation between them. Which cluster access mode should you configure?
Question · Medium
Chapter 1: Azure Databricks Architecture & Compute Selection
1.1 DP-750 Exam Overview & Azure Databricks Lakehouse Architecture
Study guide
Which compute feature setting in Azure Databricks accelerates SQL and DataFrame workloads using a native vectorized engine written in C++?
Tech Exam Prep Podcast
Listen on Spotify
Podcast
A team wants new clusters to start faster by drawing pre-initialized cloud VMs from a ready pool. Which compute performance setting addresses this?
An administrator wants to restrict which cluster configurations users can create, for example limiting node types and forcing auto-termination after 30 minutes. What is the recommended mechanism?
Which statement correctly describes the Unity Catalog object hierarchy for the three-level namespace?
1.2 Compute Types & Workload Matching
In Unity Catalog, which object combines a cloud storage path with a storage credential to authorize access to a broad area of Azure Data Lake Storage?
When configuring a storage credential in Azure Databricks to access ADLS Gen2 without storing secrets, which credential type follows Microsoft's recommended security practice?
A data engineer needs to install a custom Python wheel so that it is available to all notebooks running on a specific job cluster. Where should the library be configured?
Which Azure Databricks compute is purpose-built to run Databricks SQL queries and power BI dashboards against Delta tables?
1.3 Cluster Access Modes, Standard/Dedicated, & Serverless Compute
A team must follow a naming convention that isolates production from development data and supports external sharing. Which Unity Catalog practice best supports this isolation requirement?
Which privilege on the Unity Catalog metastore is required to register a new external location's storage credential?
Question · Hard
A workspace administrator wants users to be able to access non-tabular files (such as model artifacts and images) under a governed cloud path with Unity Catalog access control. Which object should they create?
Which Azure Databricks runtime selection consideration is most important when a team relies on liquid clustering for new Delta tables?
Chapter 2: Compute Configuration, Performance & Cost Management
2.1 Autoscaling, Databricks Pools, & Node Type Selection
A job repeatedly processes spiky, variable-sized batches. To balance cost and performance, which compute performance configuration is most appropriate?
Which statement about serverless compute and Unity Catalog access is correct?
An engineer wants to grant another teammate the ability to attach to and run notebooks on a specific all-purpose cluster, but not manage it. Which compute permission should be assigned?
Which constraint applies to an Azure Data Lake Storage Gen2 account used as a Unity Catalog external location?
2.2 Photon Vectorized Engine & Cost Governance with Cluster Policies
To allow a user to read data from a table in Unity Catalog, which combination of privileges must they hold along the namespace path?
Secure Govern Unity Catalog
Which statement about Unity Catalog GRANT statements and identity is correct?
A governance team wants masking and filtering rules that apply automatically to any table tagged as containing PII across an entire catalog, without configuring each table individually. Which Unity Catalog feature should they use?
Which statement accurately describes how row filters and column masks interact with base table privileges in Unity Catalog?
2.3 Library Management: Workspace, Compute-Scoped, Notebook, & Init Scripts
An organization needs to securely share live Delta tables with an external partner who does not use Databricks, without copying or duplicating the data. Which Unity Catalog capability supports this?
Where does Unity Catalog expose operational data such as audit logs, billable usage, and lineage as queryable tables?
A data steward wants to transfer ownership of a Unity Catalog table to a governance group. Which approach is correct?
Which Unity Catalog tool lets users browse the three-level namespace, view table schemas and sample data, manage permissions, and trace lineage graphs in one UI?
2.4 Auto-Termination, Budget Alerts, & Tagging for Cost Allocation
An auditor needs a complete record of who accessed which Unity Catalog objects over the past 90 days. Which feature provides this automatically captured record?
To improve data discovery, a team wants every governed table and key columns to carry human-readable descriptions and business comments. Which Unity Catalog capability supports this?
Which object in Unity Catalog sits directly under the metastore rather than inside the three-level catalog.schema.table namespace?
A regulation requires that personal data be physically removed after a fixed period. Which Unity Catalog governance feature lets you enforce automatic data retention on objects?
2.5 Databricks Runtime & ML Runtime Selection, and Compute Access Permissions
Which governed control restricts which rows of a table a user can see by applying a SQL user-defined function that returns FALSE for rows the user is not authorized to view?
A platform architect wants a catalog-level masking rule that table owners cannot remove or bypass. Which approach guarantees this?
Following least-privilege guidance, who should receive the CREATE EXTERNAL LOCATION privilege in Unity Catalog?
What is the correct fully qualified way to reference a table named orders in schema sales within catalog prod in Unity Catalog?
Chapter 3: Unity Catalog Storage Infrastructure & Workspace Setup
3.1 Unity Catalog 3-Level Namespace & Metastore Architecture
A security team wants to ensure that an external location is only usable from the production workspace and not from development workspaces. Which Unity Catalog feature accomplishes this?
Which identity provider does Azure Databricks integrate with to manage users and groups that are then synchronized to the account for Unity Catalog grants?
Which ingestion mechanism incrementally and efficiently processes only new files as they arrive in cloud storage, tracking which files have already been ingested?
Prepare Process Data
Loading more…