Databricks Data Engineer Associate exam dumps

Databricks Data Engineer Associate practice question 506 of 532

Databricks Certified Data Engineer Associate. Associate level, Databricks. Free question with the correct answer and a full explanation.

Databricks Data Engineer Associate Question 506

Select 2

You are a data engineer tasked with creating a Databricks SQL (DBSQL) warehouse to support a team of analysts. The analysts need a warehouse that can auto-stop after a period of inactivity to save costs, and you must ensure that the warehouse is configured with a custom cluster size. Which of the following configurations should you enable or set while creating the warehouse?

  1. A

    Enable the auto-stop feature and specify the inactivity timeout duration.

  2. B

    Configure the SQL warehouse with an instance pool for custom cluster size.

  3. C

    Set the cluster size by selecting the appropriate number of clusters during warehouse creation.

  4. D

    Disable the auto-stop feature to ensure the warehouse runs continuously.

  5. E

    Select the desired warehouse size (e.g., Small, Medium, Large) during the warehouse creation process.

Show answer and explanation

Correct answers: A, E

Explanation

When creating a Databricks SQL warehouse, enabling the auto-stop feature ensures cost savings by automatically stopping the warehouse after a period of inactivity. Additionally, selecting the appropriate warehouse size (Small, Medium, Large) defines the cluster configuration. These settings are crucial for optimizing cost and performance, while other options like using instance pools or disabling auto-stop are not relevant or counterproductive in this scenario.

  • A. Correct.

    Correct: Enabling the auto-stop feature and setting an inactivity timeout ensures the warehouse stops automatically after a period of inactivity, saving costs.

  • B. Incorrect.

    Incorrect: Instance pools are not used to define the cluster size for a Databricks SQL warehouse. They are used for managing clusters efficiently in Databricks Workspaces.

  • C. Incorrect.

    Incorrect: Cluster size is not set by specifying the number of clusters. Instead, the size of the SQL warehouse is chosen from predefined options like Small, Medium, or Large.

  • D. Incorrect.

    Incorrect: Disabling the auto-stop feature will result in higher costs as the warehouse will continue running even when not in use.

  • E. Correct.

    Correct: Choosing the appropriate warehouse size (e.g., Small, Medium, Large) allows you to define the custom cluster size for the SQL warehouse.

Timed practice exam

Take a Databricks Data Engineer Associate practice test under exam conditions

45 questions in 90 minutes, drawn from this bank, with a score report and a per-question review when you finish.

Start timed exam

More Databricks Data Engineer Associate practice questions

  1. 507.You are working with a Databricks platform where data is organized using a three-layer namespace:...
  2. 508.You are tasked with querying a table named salesdata stored in a three-layer namespace structure...
  3. 509.You are working on a Databricks project where data is organized in a three-layer namespace. The...
  4. 510.You are working on a Databricks project where you need to query a table using the three-layer...
  5. 511.You are working in a Databricks workspace with a catalog named 'main', a schema named 'sales', and...
Back to the Databricks Data Engineer Associate exam dumps