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

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

• Question 31:

  A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.

  The Alert does not work.

  Which of the following describes why the Alert does not work?

  A. Alerts don't work with queries that access tables.
  B. Queries that return results based on dates cannot be used with Alerts.
  C. The wrong query parameter is being used. Alerts only work with Date and Time query parameters.
  D. Queries that use query parameters cannot be used with Alerts.
  E. The wrong query parameter is being used. Alerts only work with dropdown list query parameters, not dates.
  D. Queries that use query parameters cannot be used with Alerts.

  ---

  Explanation/Reference:

• 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.
  E. The accounts.customers table is removed from the metastore, but the underlying data files are untouched.

  ---

  Explanation/Reference:

• Question 33:

  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
  C. Markdown-based text boxes

  ---

  Explanation/Reference:

• Question 34:

  A data analyst has been asked to count the number of customers in each region and has written the following query:

  

  If there is a mistake in the query, which of the following describes the mistake?

  A. The query is using count(*), which will count all the customers in the customers table, no matter the region.
  B. The query is missing a GROUP BY region clause.
  C. The query is using ORDER BY, which is not allowed in an aggregation.
  D. There are no mistakes in the query.
  E. The query is selecting region, but region should only occur in the ORDER BY clause.
  B. The query is missing a GROUP BY region clause.

  ---

  Explanation/Reference:

• Question 35:

  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
  E. Create an external table while specifying the object storage path to LOCATION

  ---

  Explanation/Reference:

• Question 36:

  A data analyst has created a user-defined function using the following line of code:

  CREATE FUNCTION price(spend DOUBLE, units DOUBLE)

  RETURNS DOUBLE

  RETURN spend / units;

  Which of the following code blocks can be used to apply this function to the customer_spend and customer_units columns of the table customer_summary to create column customer_price?

  A. SELECT PRICE customer_spend, customer_units AS customer_priceFROM customer_summary
  B. SELECT priceFROM customer_summary
  C. SELECT function(price(customer_spend, customer_units)) AS customer_priceFROM customer_summary
  D. SELECT double(price(customer_spend, customer_units)) AS customer_priceFROM customer_summary
  E. SELECT price(customer_spend, customer_units) AS customer_priceFROM customer_summary
  E. SELECT price(customer_spend, customer_units) AS customer_priceFROM customer_summary

  ---

  Explanation/Reference:

• Question 37:

  A data analyst runs the following command:

  INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;

  What is the result of running this command?

  A. The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, and any duplicate data is deleted.
  B. The command fails because it is written incorrectly.
  C. The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, including any duplicate data.
  D. The suppliers table now contains the data from the new_suppliers table, and the new_suppliers table now contains the data from the suppliers table.
  E. The suppliers table now contains only the data from the new_suppliers table.
  B. The command fails because it is written incorrectly.

  ---

  Explanation/Reference:

• Question 38:

  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
  C. Use Partner Connect's automated workflow to establish a cluster for Fivetran to interact with

  ---

  Explanation/Reference:

• Question 39:

  How can a data analyst determine if query results were pulled from the cache?

  A. Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.
  B. Go to the Alerts tab and check the Cache Status alert.
  C. Go to the Queries tab and click on Cache Status. The status will be green if the results from the last run came from the cache.
  D. Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.
  E. Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.
  A. Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.

  ---

  Explanation/Reference:

• Question 40:

  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
  E. Use a Serverless SQL endpoint

  ---

  Explanation/Reference: