← Back to exam page

Free CERTIFIED-DATA-ANALYST-ASSOCIATE – Databricks CERTIFIED-DATA-ANALYST-ASSOCIATE Practice Test Question

Loading demo links...

Showing 1–3 of 7 questions

Question 1 (Topic 1)

A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist. Which of the following commands can the analyst use to complete the task without producing an error?

Select an option, then click Submit answer.

  • ○ DROP DATABASE database_name;
  • ○ DROP TABLE database_name.table_name;
  • ○ DELETE TABLE database_name.table_name;
  • ○ DELETE TABLE table_name FROM database_name;
  • ○ DROP TABLE table_name FROM database_name;
Question 2 (Topic 1)

A data analyst has been asked to count the number of customers in each region and has written the following query: If there is a mistake in the query, which of the following describes the mistake?

Select an option, then click Submit answer.

  • ○ The query is using count(*), which will count all the customers in the customers table, no matter the region.
  • ○ The query is missing a GROUP BY region clause.
  • ○ The query is using ORDER BY, which is not allowed in an aggregation.
  • ○ There are no mistakes in the query.
  • ○ The query is selecting region, but region should only occur in the ORDER BY clause.
Question 3 (Topic 1)

A data analyst has created a Query in Databricks SQL, and now they want to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard. Which of the following steps will they need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

Select an option, then click Submit answer.

  • ○ They will need to alter the Query to return two separate sets of results.
  • ○ They will need to add two separate visualizations to the dashboard based on the same Query.
  • ○ They will need to create two separate dashboards.
  • ○ They will need to decide on a single data visualization to add to the dashboard.
  • ○ They will need to copy the Query and create one data visualization per query.