Databricks Certified Data Analyst Associate Exam: DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE

Which of the following layers of the medallion architecture is most commonly used by data analysts?

A. None of these layers are used by data analysts

B. Gold

C. All of these layers are used equally by data analysts

D. Silver

E. Bronze

After running DESCRIBE EXTENDED accounts.customers;, the following was returned:

Now, a data analyst runs the following command:

DROP accounts.customers;

Which of the following describes the result of running this command?

A. Running SELECT * FROM delta. `dbfs:/stakeholders/customers` results in an error.

B. Running SELECT * FROM accounts.customers will return all rows in the table.

C. All files with the .customers extension are deleted.

D. The accounts.customers table is removed from the metastore, and the underlying data files are deleted.

E. The accounts.customers table is removed from the metastore, but the underlying data files are untouched.

Which of the following statements about a refresh schedule is incorrect?

A. A query can be refreshed anywhere from 1 minute to 2 weeks.

B. Refresh schedules can be configured in the Query Editor.

C. A query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL Endpoint).

D. A refresh schedule is not the same as an alert.

E. You must have workspace administrator privileges to configure a refresh schedule.