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

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;

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.

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.

Select an option, then click Submit answer.

• ○ Visualization scale can be changed.
• ○ Data Labels can be formatted.
• ○ Colors can be changed.
• ○ Borders can be added.
• ○ Tooltips can be formatted.

Select an option, then click Submit answer.

• ○

  

• ○

  

• ○

  

• ○

  

Select an option, then click Submit answer.

• ○ Save the SQL statement as a Dashboard
• ○ Save the SQL statement within a Notebook
• ○ Save the SQL statement as a Query
• ○ Save the SQL statement in the Query History page

Select an option, then click Submit answer.

• ○ products.1
• ○ products.0
• ○ products[0]
• ○ products[1]