Databricks DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Online Practice Questions and Exam Preparation

Databricks DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Online Questions & Answers

• Question 1:

  A data analyst runs the following command:

  SELECT age, country FROM my_table WHERE age >= 75 AND country = 'canada';

  Which of the following tables represents the output of the above command?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  E. Option E

  ---

  Explanation/Reference:

• Question 2:

  A data analyst is attempting to drop a table my_table. The analyst wants to delete all table metadata and data.

  They run the following command:

  DROP TABLE IF EXISTS my_table;

  While the object no longer appears when they run SHOW TABLES, the data files still exist.

  Which of the following describes why the data files still exist and the metadata files were deleted?

  A. The table's data was larger than 10 GB
  B. The table did not have a location
  C. The table was external
  D. The table's data was smaller than 10 GB
  E. The table was managed
  C. The table was external

  ---

  Explanation/Reference:

  

• Question 3:

  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. Data blending
  B. Last-mile dashboarding
  C. Data testing
  D. Last-mile ETL
  E. Data enhancement
  D. Last-mile ETL

  ---

  Explanation/Reference:

• Question 4:

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

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

  ---

  Explanation/Reference:

• Question 5:

  Which of the following is a benefit of Databricks SQL using ANSI SQL as its standard SQL dialect?

  A. It has increased customization capabilities
  B. It is easy to migrate existing SQL queries to Databricks SQL
  C. It allows for the use of Photon's computation optimizations
  D. It is more performant than other SQL dialects
  E. It is more compatible with Spark's interpreters
  B. It is easy to migrate existing SQL queries to Databricks SQL

  ---

  Explanation/Reference:

• Question 6:

  Delta Lake stores table data as a series of data files, but it also stores a lot of other information. Which of the following is stored alongside data files when using Delta Lake?

  A. None of these
  B. Table metadata, data summary visualizations, and owner account information
  C. Table metadata
  D. Data summary visualizations
  E. Owner account information
  C. Table metadata

  ---

  Explanation/Reference:

  Reference: https://docs.databricks.com/en/delta/custom-metadata.html

• Question 7:

  In which of the following situations should a data analyst use higher-order functions?

  A. When custom logic needs to be applied to simple, unnested data
  B. When custom logic needs to be converted to Python-native code
  C. When custom logic needs to be applied at scale to array data objects
  D. When built-in functions are taking too long to perform tasks
  E. When built-in functions need to run through the Catalyst Optimizer
  C. When custom logic needs to be applied at scale to array data objects

  ---

  Explanation/Reference:

• Question 8:

  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?

  A. Delta Lake
  B. Databricks Notebooks
  C. Tableau
  D. Databricks Machine Learning
  E. Databricks SQL
  E. Databricks SQL

  ---

  Explanation/Reference:

• Question 9:

  A data analyst is processing a complex aggregation on a table with zero null values and their query returns the following result:

  

  Which of the following queries did the analyst run to obtain the above result?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  E. Option E

  ---

  Explanation/Reference:

• Question 10:

  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?

  A. 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.
  B. 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.
  C. The area chart will use whatever value is chosen on the dashboard at the time the area chart is added to the dashboard.
  D. 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.
  E. The area chart will convert to a Dashboard Parameter.
  B. 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.

  ---

  Explanation/Reference: