Pass the Databricks Databricks Certification Databricks-Certified-Data-Engineer-Associate Questions and answers with CertsForce

 A serverless SQL endpoint is a compute resource that is automatically managed by Databricks and scales up or down based on the workload. A serverless SQL endpoint can be used to run queries and dashboards without requiring manual configuration or management. A serverless SQL endpoint is only active when it is needed and shuts down automatically when idle, minimizing the total running time and cost. A serverless SQL endpoint can be created and assigned to a dashboard using the Databricks SQL UI or the SQL Analytics API. References:

Create a serverless SQL endpoint

Assign a SQL endpoint to a dashboard

SQL Analytics API

The processingTime option specifies a time-based trigger interval for fixed interval micro-batches. This means that the query will execute a micro-batch to process data every 5 seconds, regardless of how much data is available. This option is suitable for near-real time processing workloads that require low latency and consistent processing frequency. The other options are either invalid syntax (A, C), default behavior (B), or experimental feature (E). References: Databricks Documentation - Configure Structured Streaming trigger intervals, Databricks Documentation - Trigger.

 To append a new record to an existing Delta table, you can use the INSERT INTO statement with the VALUES clause. This statement will insert one or more rows into the table with the specified values. Option A is the only code block that follows this syntax correctly. Option B is incorrect, as it uses the UNION operator, which will return a new table that is the union of two tables, not append to an existing table. Option C is incorrect, as it uses the INSERT VALUES statement, which is not a valid SQL syntax. Option D is incorrect, as it uses the UPDATE statement, which will modify existing rows in the table, not append new rows. Option E is incorrect, as it uses the UPDATE VALUES statement, which is also not a valid SQL syntax. References: Insert data into a table using SQL | Databricks on AWS, Insert data into a table using SQL - Azure Databricks, Delta Lake Quickstart - Azure Databricks

 To grant full permissions on a table to a user or a group, you can use the GRANT ALL PRIVILEGES ON TABLE statement. This statement will grant all the possible privileges on the table, such as SELECT, CREATE, MODIFY, DROP, ALTER, etc. Option A is the only code block that follows this syntax correctly. Option B is incorrect, as it does not grant all the possible privileges on the table, but only a subset of them. Option C is incorrect, as it only grants the SELECT privilege on the table, which is not enough to fully manage the project. Option D is incorrect, as it grants the USAGE privilege on the table, which is not a valid privilege for tables. Option E is incorrect, as it grants all the privileges on the table team to the user or group sales, which is the opposite of what the question asks. References: Grant privileges on a table using SQL | Databricks on AWS, Grant privileges on a table using SQL - Azure Databricks, SQL Privileges - Databricks

Databricks recommends managed tables when you want the platform to control both the table metadata and the underlying storage lifecycle. For Unity Catalog managed tables, Databricks manages storage layout and applies platform-managed optimization features over time. Databricks also documents that when you drop a managed table , the underlying cloud data is deleted automatically after the managed retention period, which simplifies cleanup and reduces storage administration. That behavior matches the requirement exactly. External tables, by contrast, are used when you want to retain direct control over the storage path and lifecycle. Databricks explicitly states that dropping an external table removes only the metadata and does not delete the underlying files . Foreign tables are for federation scenarios against external systems, not for Bronze ingestion storage managed by Databricks. Temporary views also do not provide the desired governed lifecycle. Because the team wants Databricks-managed storage, managed retention, and simplified lifecycle handling, managed tables are the correct choice for these Bronze ingestion tables.

=========

Delta Sharing is an open protocol developed by Databricks that enables secure, real-time sharing of data across organizations without requiring recipients to have a Databricks account. It is specifically designed for scenarios where external partners need read-only access to data stored in Delta format. With Delta Sharing, data providers create a share and grant access to recipients via a secure mechanism (such as a profile file or URL-based access), ensuring that the data cannot be modified by the consumer. This approach eliminates the need for data duplication or manual file transfers, maintaining data freshness and governance. Option B is incorrect because Unity Catalog governs internal access within an organization, not external sharing without accounts. Option C is inefficient and breaks data lineage and freshness. Option D violates security best practices by granting excessive permissions. Delta Sharing ensures fine- grained access control, auditability, and secure external collaboration , making it the correct solution for this requirement.

=========

This question’s options do not include the most precise Unity Catalog answer, which would normally be the MANAGE privilege on the schema, because Databricks documents that MANAGE allows a principal to grant and revoke privileges on an object without automatically granting all data-access privileges on that object. However, since MANAGE is not one of the answer choices, the best available answer is D, Schema Owner . Databricks states that schema owners can grant and revoke permissions on the schema, and schema-level administration is a documented responsibility of the schema owner. Option A is incorrect because USE CATALOG and USE SCHEMA only allow object access/navigation and do not confer privilege-management rights. Option B is too broad because a catalog owner governs the entire catalog scope, not just one schema. Option C is too narrow because a table owner controls only one table, not various objects across a schema. So, among the choices provided, Schema Owner is the closest Databricks-aligned answer, though the cleanest real-world implementation would be MANAGE on the schema .

=========

To grant full privileges on a table such as ' sales ' to a group like ' team ' , the correct SQL command in Databricks is:

GRANT ALL PRIVILEGES ON TABLE sales TO team;

This command assigns all available privileges, including SELECT, INSERT, UPDATE, DELETE, and any other data manipulation or definition actions, to the specified team. This is typically necessary when a team needs full control over a table to manage and manipulate it as part of a project or ongoing maintenance.