Free Databricks Certified Data Analyst Associate Exam Databricks-Certified-Data-Analyst-Associate Exam Practice Test

A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative. The analysis team identifies table_bronze as the source of the duplication.Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?A)CREATE TABLE table_silver AS SELECT DISTINCT *FROM table_bronze;B)CREATE TABLE table_silver AS INSERT *FROM table_bronze;C)CREATE TABLE table_silver AS MERGE DEDUPLICATE *FROM table_bronze;D)INSERT INTO TABLE table_silver SELECT * FROM table_bronze;E)INSERT OVERWRITE TABLE table_silverSELECT * FROM table_bronze;

• Option A
• Option B
• Option C
• Option D
• Option E

A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard.Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?

• Delta Lake
• Databricks Notebooks
• Tableau
• Databricks Machine Learning
• Databricks SQL

A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.The Alert does not work.Which of the following describes why the Alert does not work?

• Alerts don't work with queries that access tables.
• Queries that return results based on dates cannot be used with Alerts.
• The wrong query parameter is being used. Alerts only work with Date and Time query parameters.
• Queries that use query parameters cannot be used with Alerts.
• The wrong query parameter is being used. Alerts only work with drogdown list query parameters, not dates.

A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?

• Reduce the SQL endpoint cluster size
• Increase the SQL endpoint cluster size
• Turn off the Auto stop feature
• Increase the minimum scaling value
• Use a Serverless SQL endpoint

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?

• Data blending
• Last-mile
• Data testing
• Last-mile ETL
• Data enhancement

Which of the following benefits of using Databricks SQL is provided by Data Explorer?

• It can be used to run UPDATE queries to update any tables in a database.
• It can be used to view metadata and data, as well as view/change permissions.
• It can be used to produce dashboards that allow data exploration.
• It can be used to make visualizations that can be shared with stakeholders.
• It can be used to connect to third party Bl cools.

Which of the following statements describes descriptive statistics?

• A branch of statistics that uses summary statistics to quantitatively describe and summarize data.
• A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.
• A branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values.
• A branch of statistics that uses summary statistics to categorically describe and summarize data.
• A branch of statistics that uses quantitative variables that must take on an uncountable set of values.

A data team has been given a series of projects by a consultant that need to be implemented in the Databricks Lakehouse Platform.Which of the following projects should be completed in Databricks SQL?

• Testing the quality of data as it is imported from a source
• Tracking usage of feature variables for machine learning projects
• Combining two data sources into a single, comprehensive dataset
• Segmenting customers into like groups using a clustering algorithm
• Automating complex notebook-based workflows with multiple tasks

Which of the following describes how Databricks SQL should be used in relation to other business intelligence (BI) tools like Tableau, Power BI, and looker?

• As an exact substitute with the same level of functionality
• As a substitute with less functionality
• As a complete replacement with additional functionality
• As a complementary tool for professional-grade presentations
• As a complementary tool for quick in-platform Bl work

An analyst writes a query that contains a query parameter. They then add an area chart visualization to the query. While adding the area chart visualization to a dashboard, the analyst chooses "Dashboard Parameter" for the query parameter associated with the area chart.Which of the following statements is true?

• The area chart will use whatever is selected in the Dashboard Parameter while all or the other visualizations will remain changed regardless of their parameter use.
• The area chart will use whatever is selected in the Dashboard Parameter along with all of the other visualizations in the dashboard that use the same parameter.
• The area chart will use whatever value is chosen on the dashboard at the time the area chart is added to the dashboard.
• The area chart will use whatever value is input by the analyst when the visualization is added to the dashboard. The parameter cannot be changed by the user afterwards.
• The area chart will convert to a Dashboard Parameter.