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

• Question 41:

  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?

  A. As an exact substitute with the same level of functionality

  B. As a substitute with less functionality

  C. As a complete replacement with additional functionality

  D. As a complementary tool for professional-grade presentations

  E. As a complementary tool for quick in-platform BI work

  Correct Answer: E

• Question 42:

  A data analyst has recently joined a new team that uses Databricks SQL, but the analyst has never used Databricks before. The analyst wants to know where in Databricks SQL they can write and execute SQL queries.

  On which of the following pages can the analyst write and execute SQL queries?

  A. Data page

  B. Dashboards page

  C. Queries page

  D. Alerts page

  E. SQL Editor page

  Correct Answer: E

  Reference: https://docs.databricks.com/en/sql/language-manual/index.html

• Question 43:

  Which of the following layers of the medallion architecture is most commonly used by data analysts?

  A. None of these layers are used by data analysts

  B. Gold

  C. All of these layers are used equally by data analysts

  D. Silver

  E. Bronze

  Correct Answer: B

  Reference: https://www.databricks.com/glossary/medallion-architecture

• Question 44:

  In which of the following situations will the mean value and median value of variable be meaningfully different?

  A. When the variable contains no outliers

  B. When the variable contains no missing values

  C. When the variable is of the boolean type

  D. When the variable is of the categorical type

  E. When the variable contains a lot of extreme outliers

  Correct Answer: E

• Question 45:

  A data analyst is working with gold-layer tables to complete an ad-hoc project. A stakeholder has provided the analyst with an additional dataset that can be used to augment the gold-layer tables already in use.

  Which of the following terms is used to describe this data augmentation?

  A. Data testing

  B. Ad-hoc improvements

  C. Last-mile dashboarding

  D. Last-mile ETL

  E. Data enhancement

  Correct Answer: E