Online Access Free Databricks-Certified-Data-Analyst-Associate Exam Questions

A data analyst runs the following command:
INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;
What is the result of running this command?

• A.The suppliers table now contains both the data it had before the command was run and the data from the new suppliers table, including any duplicate data.
• B.The suppliers table now contains only the data from the new suppliers table.
• C.The suppliers table now contains the data from the new suppliers table, and the new suppliers table now contains the data from the suppliers table.
• D.The command fails because it is written incorrectly.
• E.The suppliers table now contains both the data it had before the command was run and the data from the new suppliers table, and any duplicate data is deleted.

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 testing
• D.Data enhancement
• E.Last-mile ETL

Which statement about visualizations is true?

• A.Different visualizations can be used to tell different stories about the data.
• B.All visualizations must use the same data in order to be included in the same Databricks SQL dashboard.
• C.Line charts are the preferred visualization type for categorical data.
• D.There is no difference between the bar chart and a histogram in Databricks SQL.

Which of the following is stored in the Databricks customer's cloud account?

• A.Databricks web application
• B.Notebooks
• C.Repos
• D.Cluster management metadata
• E.Data

A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every minute.
A data analyst has created a dashboard based on this gold-level data. The project stakeholders want to see the results in the dashboard updated within one minute or less of new data becoming available within the gold- level tables.
Which of the following cautions should the data analyst share prior to setting up the dashboard to complete this task?

• A.The streaming data is not an appropriate data source for a dashboard
• B.The dashboard cannot be refreshed that quickly
• C.The gold-level tables are not appropriately clean for business reporting
• D.The streaming cluster is not fault tolerant
• E.The required compute resources could be costly