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

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

• Question 41:

  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?

  A. DROP DATABASE database_name;
  B. DROP TABLE database_name.table_name;
  C. DELETE TABLE database_name.table_name;
  D. DELETE TABLE table_name FROM database_name;
  E. DROP TABLE table_name FROM database_name;
  B. DROP TABLE database_name.table_name;

  ---

  Explanation/Reference:

• Question 42:

  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
  E. Data enhancement

  ---

  Explanation/Reference:

• Question 43:

  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
  E. SQL Editor page

  ---

  Explanation/Reference:

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

• Question 44:

  The stakeholders.customers table has 15 columns and 3,000 rows of data. The following command is run:

  

  After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks. After logging back in two days later, what is the status of the stakeholders.eur_customers view?

  A. The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.
  B. The view has been dropped.
  C. The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.
  D. The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.
  E. The view has been converted into a table.
  B. The view has been dropped.

  ---

  Explanation/Reference:

  The command you sent creates a TEMP VIEW, which is a type of view that is only visible and accessible to the session that created it.

  When the session ends or the user logs out, the TEMP VIEW is automatically dropped and cannot be queried anymore. Therefore, after logging back in two days later, the status of the stakeholders.eur_customers view is that it has been

  dropped and SELECT * FROM stakeholders.eur_customers will result in an error. The other options are not correct because:

  A) The view does not remain available, as it is a TEMP VIEW that is dropped when the session ends or the user logs out.

  C) The view is not available in the metastore, as it is a TEMP VIEW that is not registered in the metastore. The underlying data cannot be accessed with SELECT * FROM delta. stakeholders.eur_customers, as this is not a valid syntax for

  querying a Delta Lake table. The correct syntax would be SELECT * FROM delta.dbfs:/stakeholders/eur_customers, where the location path is enclosed in backticks. However, this would also result in an error, as the TEMP VIEW does not

  write any data to the file system and the location path does not exist.

  D) The view does not remain available, as it is a TEMP VIEW that is dropped when the session ends or the user logs out. Data in views are not automatically deleted after logging out, as views do not store any data. They are only logical

  representations of queries on base tables or other views.

  E) The view has not been converted into a table, as there is no automatic conversion between views and tables in Databricks. To create a table from a view, you need to use a CREATE TABLE AS statement or a similar command.

• Question 45:

  Which of the following should data analysts consider when working with personally identifiable information (PII) data?

  A. Organization-specific best practices for PII data
  B. Legal requirements for the area in which the data was collected
  C. None of these considerations
  D. Legal requirements for the area in which the analysis is being performed
  E. All of these considerations
  E. All of these considerations

  ---

  Explanation/Reference: