Online Access Free Databricks-Certified-Data-Analyst-Associate Practice Test

A data organization has a team of engineers developing data pipelines following the medallion architecture using Delta Live Tables. While the data analysis team working on a project is using gold-layer tables from these pipelines, they need to perform some additional processing of these tables prior to performing their analysis.
Which of the following terms is used to describe this type of work?

• A.Last-mile
• B.Data blending
• C.Data enhancement
• D.Data testing
• E.Last-mile ETL

Query History provides Databricks SQL users with a lot of benefits. A data analyst has been asked to share all of these benefits with their team as part of a training exercise. One of the benefit statements the analyst provided to their team is incorrect.
Which statement about Query History is incorrect?

• A.It can be used to debug queries.
• B.It can be used to troubleshoot slow running queries.
• C.It can be used to automate query execution on multiple warehouses (formerly endpoints).
• D.It can be used to view the query plan of queries that have run.

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

• A.A refresh schedule is not the same as an alert.
• B.You must have workspace administrator privileges to configure a refresh schedule
• C.A query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL Endpoint).
• D.Refresh schedules can be configured in the Query Editor.
• E.A query can be refreshed anywhere from 1 minute lo 2 weeks

How can a data analyst determine if query results were pulled from the cache?

• A.Go to the Alerts tab and check the Cache Status alert.
• B.Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.
• C.Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.
• D.Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.
• E.Go to the Queries tab and click on Cache Status. The status will be green if the results from the last run came from the cache.

Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

• A.Use Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
• B.Use Partner Connect's automated workflow to establish a cluster for Fivetran to interact with
• C.Use Workflows to establish a cluster for Fivetran to interact with
• D.Use Delta Live Tables to establish a cluster for Fivetran to interact with
• E.Use Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with