Free DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Web TestEngine Demo

Q5 Single choice

A data analyst is working in a Databricks workspace with Unity Catalog enabled. While using a shared SQL Warehouse, the analyst runs the following query:

SELECT * FROM sales_data;

This query results in a "TABLE_OR_VIEW_NOT_FOUND" error, even though:

The table sales_data exists in the reporting schema of the corp_data catalog. The analyst has SELECT and USAGE privileges on the corp_data.reporting.sales_data table. Another user running the same query in a notebook attached to a cluster is able to retrieve results without fully qualifying the table.

Which action helps the analyst to resolve the issue without rewriting the query?

A
Set the spark.databricks.sql.initial.catalog.namespace Spark configuration in the cluster attached to the SQL Warehouse.
B
Run the following command to set the default catalog and schema for the current session: USE CATALOG corp_data; USE SCHEMA reporting;
C
Modify the workspace-level catalog default so that all SQL Warehouses automatically point to corp_data.reporting.
D
Set spark.sql.default.database to corp_data.reporting.sales_data in the SQL Warehouse runtime configuration.

DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Web TestEngine demo