🔍

DATA-ENGINEER-ASSOCIATE — questions

Page 5 of 9 · 169 total questions.

DATA-ENGINEER-ASSOCIATE Question 81

Single page →
Topic 1 · Question 81

Which of the following statements regarding the relationship between Silver tables and Bronze tables is always true?

  • ASilver tables contain a less refined, less clean view of data than Bronze data.
  • BSilver tables contain aggregates while Bronze data is unaggregated.
  • CSilver tables contain more data than Bronze tables.
  • DSilver tables contain a more refined and cleaner view of data than Bronze tables. (correct answer)
  • ESilver tables contain less data than Bronze tables.
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Silver tables contain a more refined and cleaner view of data than Bronze tables.

Explanation

The bronze layer preserves raw ingested data for replay, auditing, and downstream refinement. The silver layer contains validated, deduplicated, and conformed data suitable for downstream analysis.

DATA-ENGINEER-ASSOCIATE Question 82

Single page →
Topic 1 · Question 82

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data engineering team wants this issue to be resolved. Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?

  • AThey can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized."
  • BThey can turn on the Auto Stop feature for the SQL endpoint.
  • CThey can increase the cluster size of the SQL endpoint.
  • DThey can turn on the Serverless feature for the SQL endpoint. (correct answer)
  • EThey can increase the maximum bound of the SQL endpoint's scaling range.
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: They can turn on the Serverless feature for the SQL endpoint.

Explanation

Serverless compute lets Databricks manage provisioning, scaling, and infrastructure, minimizing operational overhead.

DATA-ENGINEER-ASSOCIATE Question 83

Single page →
Topic 1 · Question 83

A data engineer has a Job that has a complex run schedule, and they want to transfer that schedule to other Jobs. Rather than manually selecting each value in the scheduling form in Databricks, which of the following tools can the data engineer use to represent and submit the schedule programmatically?

  • Apyspark.sql.types.DateType
  • Bdatetime
  • Cpyspark.sql.types.TimestampType
  • DCron syntax (correct answer)
  • EThere is no way to represent and submit this information programmatically
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Cron syntax

DATA-ENGINEER-ASSOCIATE Question 84

Single page →
Topic 1 · Question 84

Which of the following approaches should be used to send the Databricks Job owner an email in the case that the Job fails?

  • AManually programming in an alert system in each cell of the Notebook
  • BSetting up an Alert in the Job page (correct answer)
  • CSetting up an Alert in the Notebook
  • DThere is no way to notify the Job owner in the case of Job failure
  • EMLflow Model Registry Webhooks
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Setting up an Alert in the Job page

DATA-ENGINEER-ASSOCIATE Question 85

Single page →
Topic 1 · Question 85

An engineering manager uses a Databricks SQL query to monitor ingestion latency for each data source. The manager checks the results of the query every day, but they are manually rerunning the query each day and waiting for the results. Which of the following approaches can the manager use to ensure the results of the query are updated each day?

  • AThey can schedule the query to refresh every 1 day from the SQL endpoint's page in Databricks SQL.
  • BThey can schedule the query to refresh every 12 hours from the SQL endpoint's page in Databricks SQL.
  • CThey can schedule the query to refresh every 1 day from the query's page in Databricks SQL. (correct answer)
  • DThey can schedule the query to run every 1 day from the Jobs UI.
  • EThey can schedule the query to run every 12 hours from the Jobs UI.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: They can schedule the query to refresh every 1 day from the query's page in Databricks SQL.

DATA-ENGINEER-ASSOCIATE Question 86

Single page →
Topic 1 · Question 86

In which of the following scenarios should a data engineer select a Task in the Depends On field of a new Databricks Job Task?

  • AWhen another task needs to be replaced by the new task
  • BWhen another task needs to fail before the new task begins
  • CWhen another task has the same dependency libraries as the new task
  • DWhen another task needs to use as little compute resources as possible
  • EWhen another task needs to successfully complete before the new task begins (correct answer)
Reveal answer & explanation
Correct answer: E

The correct answer is E. Option E: When another task needs to successfully complete before the new task begins

DATA-ENGINEER-ASSOCIATE Question 87

Single page →
Topic 1 · Question 87

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to a data analytics dashboard for a retail use case. The job has a Databricks SQL query that returns the number of store-level records where sales is equal to zero. The data engineer wants their entire team to be notified via a messaging webhook whenever this value is greater than 0. Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of stores with $0 in sales is greater than zero?

  • AThey can set up an Alert with a custom template.
  • BThey can set up an Alert with a new email alert destination.
  • CThey can set up an Alert with one-time notifications.
  • DThey can set up an Alert with a new webhook alert destination. (correct answer)
  • EThey can set up an Alert without notifications.
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: They can set up an Alert with a new webhook alert destination.

DATA-ENGINEER-ASSOCIATE Question 88

Single page →
Topic 1 · Question 88

A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when it is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job. Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

  • AThey can turn on the Auto Stop feature for the SQL endpoint. (correct answer)
  • BThey can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.
  • CThey can reduce the cluster size of the SQL endpoint.
  • DThey can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
  • EThey can set up the dashboard's SQL endpoint to be serverless.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: They can turn on the Auto Stop feature for the SQL endpoint.

DATA-ENGINEER-ASSOCIATE Question 89

Single page →
Topic 1 · Question 89

A data engineer needs access to a table new_table, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is. Which of the following approaches can be used to identify the owner of new_table?

  • AReview the Permissions tab in the table's page in Data Explorer
  • BAll of these options can be used to identify the owner of the table
  • CReview the Owner field in the table's page in Data Explorer (correct answer)
  • DReview the Owner field in the table's page in the cloud storage solution
  • EThere is no way to identify the owner of the table
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Review the Owner field in the table's page in Data Explorer

DATA-ENGINEER-ASSOCIATE Question 90

Single page →
Topic 1 · Question 90

A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project. Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

  • AGRANT ALL PRIVILEGES ON TABLE sales TO team; (correct answer)
  • BGRANT SELECT CREATE MODIFY ON TABLE sales TO team;
  • CGRANT SELECT ON TABLE sales TO team;
  • DGRANT USAGE ON TABLE sales TO team;
  • EGRANT ALL PRIVILEGES ON TABLE team TO sales;
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: GRANT ALL PRIVILEGES ON TABLE sales TO team;

DATA-ENGINEER-ASSOCIATE Question 91

Single page →
Topic 1 · Question 91

Which data lakehouse feature results in improved data quality over a traditional data lake?

  • AA data lakehouse stores data in open formats.
  • BA data lakehouse allows the use of SQL queries to examine data.
  • CA data lakehouse provides storage solutions for structured and unstructured data.
  • DA data lakehouse supports ACID-compliant transactions. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: A data lakehouse supports ACID-compliant transactions.

DATA-ENGINEER-ASSOCIATE Question 92

Single page →
Topic 1 · Question 92

In which scenario will a data team want to utilize cluster pools?

  • AAn automated report needs to be version-controlled across multiple collaborators.
  • BAn automated report needs to be runnable by all stakeholders.
  • CAn automated report needs to be refreshed as quickly as possible. (correct answer)
  • DAn automated report needs to be made reproducible.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: An automated report needs to be refreshed as quickly as possible.

DATA-ENGINEER-ASSOCIATE Question 93

Single page →
Topic 1 · Question 93

What is hosted completely in the control plane of the classic Databricks architecture?

  • AWorker node
  • BDatabricks web application (correct answer)
  • CDriver node
  • DDatabricks Filesystem
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Databricks web application

DATA-ENGINEER-ASSOCIATE Question 94

Single page →
Topic 1 · Question 94

A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos. What is an advantage of using Databricks Repos over the Databricks Notebooks versioning?

  • ADatabricks Repos allows users to revert to previous versions of a notebook
  • BDatabricks Repos is wholly housed within the Databricks Data Intelligence Platform
  • CDatabricks Repos provides the ability to comment on specific changes
  • DDatabricks Repos supports the use of multiple branches (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Databricks Repos supports the use of multiple branches

Explanation

Databricks Repos integrates Git-based source control with workspace development workflows.

DATA-ENGINEER-ASSOCIATE Question 95

Single page →
Topic 1 · Question 95

What is a benefit of the Databricks Lakehouse Architecture embracing open source technologies?

  • AAvoiding vendor lock-in (correct answer)
  • BSimplified governance
  • CAbility to scale workloads
  • DCloud-specific integrations
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Avoiding vendor lock-in

DATA-ENGINEER-ASSOCIATE Question 96

Single page →
Topic 1 · Question 96

A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions. In which location can the data engineer review their permissions on the table?

  • AJobs
  • BDashboards
  • CCatalog Explorer (correct answer)
  • DRepos
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Catalog Explorer

DATA-ENGINEER-ASSOCIATE Question 97

Single page →
Topic 1 · Question 97

A data engineer is running code in a Databricks Repo that is cloned from a central Git repository. A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository. Which Git operation does the data engineer need to run to accomplish this task?

  • AClone
  • BPull (correct answer)
  • CMerge
  • DPush
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Pull

DATA-ENGINEER-ASSOCIATE Question 98

Single page →
Topic 1 · Question 98

Which file format is used for storing Delta Lake Table?

  • ACSV
  • BParquet (correct answer)
  • CJSON
  • DDelta
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Parquet

DATA-ENGINEER-ASSOCIATE Question 99

Single page →
Topic 1 · Question 99

A data architect has determined that a table of the following format is necessary: Which code block is used by SQL DDL command to create an empty Delta table in the above format regardless of whether a table already exists with this name?

Exhibit 1 for question 99
  • ACREATE OR REPLACE TABLE table_name ( employeeId STRING, startDate DATE, avgRating FLOAT ) (correct answer)
  • BCREATE OR REPLACE TABLE table_name WITH COLUMNS ( employeeId STRING, startDate DATE, avgRating FLOAT ) USING DELTA
  • CCREATE TABLE IF NOT EXISTS table_name ( employeeId STRING, startDate DATE, avgRating FLOAT )
  • DCREATE TABLE table_name AS SELECT employeeId STRING, startDate DATE, avgRating FLOAT
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: CREATE OR REPLACE TABLE table_name ( employeeId STRING, startDate DATE, avgRating FLOAT )

DATA-ENGINEER-ASSOCIATE Question 100

Single page →
Topic 1 · Question 100

A data engineer has been given a new record of data: id STRING = 'a1' rank INTEGER = 6 rating FLOAT = 9.4 Which SQL commands can be used to append the new record to an existing Delta table my_table?

  • AINSERT INTO my_table VALUES ('a1', 6, 9.4) (correct answer)
  • BINSERT VALUES ('a1', 6, 9.4) INTO my_table
  • CUPDATE my_table VALUES ('a1', 6, 9.4)
  • DUPDATE VALUES ('a1', 6, 9.4) my_table
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: INSERT INTO my_table VALUES ('a1', 6, 9.4)

Showing questions 81–100 of 169 · Page 5 of 9