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

• Question 31:

  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

  Correct Answer: E

• Question 32:

  After running DESCRIBE EXTENDED accounts.customers;, the following was returned:

  Now, a data analyst runs the following command:

  DROP accounts.customers;

  Which of the following describes the result of running this command?

  A. Running SELECT * FROM delta. `dbfs:/stakeholders/customers` results in an error.

  B. Running SELECT * FROM accounts.customers will return all rows in the table.

  C. All files with the .customers extension are deleted.

  D. The accounts.customers table is removed from the metastore, and the underlying data files are deleted.

  E. The accounts.customers table is removed from the metastore, but the underlying data files are untouched.

  Correct Answer: E

• Question 33:

  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

  Correct Answer: C

  

• Question 34:

  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

  Correct Answer: E

• Question 35:

  A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production. They want all three sections on the same dashboard, but they want to clearly designate the sections using text on the dashboard. Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?

  A. Separate endpoints for each section

  B. Separate queries for each section

  C. Markdown-based text boxes

  D. Direct text written into the dashboard in editing mode

  E. Separate color palettes for each section

  Correct Answer: C

• Question 36:

  Which of the following approaches can be used to ingest data directly from cloud-based object storage?

  A. Create an external table while specifying the DBFS storage path to FROM

  B. Create an external table while specifying the DBFS storage path to PATH

  C. It is not possible to directly ingest data from cloud-based object storage

  D. Create an external table while specifying the object storage path to FROM

  E. Create an external table while specifying the object storage path to LOCATION

  Correct Answer: E

• Question 37:

  A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every minute.

  A data analyst has created a dashboard based on this gold-level data. The project stakeholders want to see the results in the dashboard updated within one minute or less of new data becoming available within the gold-level tables.

  Which of the following cautions should the data analyst share prior to setting up the dashboard to complete this task?

  A. The required compute resources could be costly

  B. The gold-level tables are not appropriately clean for business reporting

  C. The streaming data is not an appropriate data source for a dashboard

  D. The streaming cluster is not fault tolerant

  E. The dashboard cannot be refreshed that quickly

  Correct Answer: A

• Question 38:

  A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.

  Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?

  A. Reduce the SQL endpoint cluster size

  B. Increase the SQL endpoint cluster size

  C. Turn off the Auto stop feature

  D. Increase the minimum scaling value

  E. Use a Serverless SQL endpoint

  Correct Answer: E

• Question 39:

  Data professionals with varying titles use the Databricks SQL service as the primary touchpoint with the Databricks Lakehouse Platform. However, some users will use other services like Databricks Machine Learning or Databricks Data Science and Engineering.

  Which of the following roles uses Databricks SQL as a secondary service while primarily using one of the other services?

  A. Business analyst

  B. SQL analyst

  C. Data engineer

  D. Business intelligence analyst

  E. Data analyst

  Correct Answer: C

• Question 40:

  Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

  A. Use Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with

  B. Use Delta Live Tables to establish a cluster for Fivetran to interact with

  C. Use Partner Connect's automated workflow to establish a cluster for Fivetran to interact with

  D. Use Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with

  E. Use Workflows to establish a cluster for Fivetran to interact with

  Correct Answer: C