← Back to exam page

Free CERTIFIED-DATA-ENGINEER-ASSOCIATE – Databricks CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice Test Question

Loading demo links...

Showing 1–3 of 17 questions

Question 1 (Topic 1)

Which of the following data lakehouse features results in improved data quality over a traditional data lake?

Select an option, then click Submit answer.

  • ○ A data lakehouse provides storage solutions for structured and unstructured data.
  • ○ A data lakehouse supports ACID-compliant transactions.
  • ○ A data lakehouse allows the use of SQL queries to examine data.
  • ○ A data lakehouse stores data in open formats.
  • ○ A data lakehouse enables machine learning and artificial Intelligence workloads.
Question 2 (Topic 1)

A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team. Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

Select an option, then click Submit answer.

  • ○ GRANT VIEW ON CATALOG customers TO team;
  • ○ GRANT CREATE ON DATABASE customers TO team;
  • ○ GRANT USAGE ON CATALOG team TO customers;
  • ○ GRANT CREATE ON DATABASE team TO customers;
  • ○ GRANT USAGE ON DATABASE customers TO team;
Question 3 (Topic 1)

Which of the following data workloads will utilize a Gold table as its source?

Select an option, then click Submit answer.

  • ○ A job that enriches data by parsing its timestamps into a human-readable format
  • ○ A job that aggregates uncleaned data to create standard summary statistics
  • ○ A job that cleans data by removing malformatted records
  • ○ A job that queries aggregated data designed to feed into a dashboard
  • ○ A job that ingests raw data from a streaming source into the Lakehouse