Changed Databricks-Certified-Data-Analyst-Associate Exam Questions

The reason the alert is not functioning as expected is because Databricks SQL Alerts do not support query parameters. This limitation applies to all types of parameters, including date parameters.

Here’s why:

Alerts require static, deterministic query results so they can compare values consistently during scheduled executions.

When a query includes parameters (e.g., a date range parameter), its results may change based on user input or the default value set in the query editor.

However, Databricks SQL Alerts will always use the default value set for the parameter at the time the alert is created. This means the alert doesn’t dynamically adapt to new date ranges and will not reflect changes unless the query is manually updated.

As a result, if the business logic behind the alert depends on changing date ranges or any user input, the alert will not trigger correctly, or may never trigger at all.

Therefore, the correct explanation contradicts Option B, which is incorrect in saying that alerts cannot work with date-based queries at all. In fact, they can—as long as the query is static (i.e., without parameters).

Option A is correct. The model being tuned is a Spark ML model, which is already distributed. SparkTrials is intended to distribute independent single-machine trials across Spark workers. For distributed ML algorithms such as Spark MLlib/Spark ML, Hyperopt should run trials from the driver so each trial can access the full cluster resources. Therefore, SparkTrials() should be changed to Trials(). Official Databricks documentation explains that this setup works for distributed machine learning algorithms including Apache Spark MLlib, and the Databricks notebook guidance states that SparkTrials is incompatible for that distributed-training pattern because each trial must be evaluated on the driver node.

In Databricks, to determine the owner of a managed table, you can utilize the Catalog Explorer feature. The steps are as follows:​

Access Catalog Explorer:

In your Databricks workspace, click on the Catalog icon in the sidebar to open Catalog Explorer.​

Navigate to the Table:

Within Catalog Explorer, browse through the catalog and schema to locate the specific managed table whose ownership you wish to verify.​

View Table Details:

Click on the table name to open its details page.​

Identify the Owner:

On the table ' s details page, review the Owner field, which displays the principal (user, service principal, or group) that owns the table.​

This method provides a straightforward way to ascertain the ownership of managed tables within the Databricks environment. Understanding table ownership is essential for managing permissions and ensuring proper access control.​

 An external table is a table that is defined in the metastore, but its data is stored outside of the Databricks environment, such as in S3, ADLS, or GCS. When an external table is dropped, only the metadata is deleted from the metastore, but the data files are not affected. This is different from a managed table, which is a table whose data is stored in the Databricks environment, and whose data files are deleted when the table is dropped. To delete the data files of an external table, the analyst needs to specify the PURGE option in the DROP TABLE command, or manually delete the files from the storage system. References: DROP TABLE, Drop Delta table features, Best practices for dropping a managed Delta Lake table