Free Databricks Databricks-Certified-Data-Analyst-Associate Exam Dumps Questions & Answers

A data analyst has come across a column in a table that contains personally identifiable information (PII). The data analyst should not have access to this type of PII data.
How should the data analyst proceed?

• A.Stop working with the data and notify their supervisor to ensure the data is handled following organizational and legal best practices.
• B.Drop the column containing PII data and continue with the project without notifying anybody.
• C.Stop working with the data and delete the table and any existing metadata or data files.
• D.Stop working with the data and proceed with the project using other data.

A data analyst has two data sources that are providing similar but complementary information. The analyst wants to combine these sources of data into a single, comprehensive dataset for ongoing use for their team in a variety of different projects.
Which term is used to describe this type of work?

• A.Last-mile ETL
• B.Data testing
• C.Data blending
• D.Ad-hoc improvements

A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

• A.They can reduce the cluster size of the SQL endpoint.
• B.They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
• C.They can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.
• D.They can turn on the Auto Stop feature for the SQL endpoint.
• E.They can set up the dashboard's SQL endpoint to be serverless.

What is used as a compute resource for Databricks SQL?

• A.SQL warehouses
• B.Single-node clusters
• C.Standard clusters
• D.Downstream BI tools integrated with Databricks SQL

Where can an admin or data owner grant database, table, and view permissions to a group?

• A.Settings
• B.SQL Warehouses
• C.Dashboard
• D.Data