← Back to exam page

Databricks-Certified-Data-Engineer-Associate – Databricks Certified Data Engineer Associate Exam

Loading demo links...

Showing 4–6 of 7 questions

Question 4

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 5

Which of the following describes a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?

Select an option, then click Submit answer.

  • ○

    Parquet files can be partitioned

  • ○

    CREATE TABLE AS SELECT statements cannot be used on files

  • ○

    Parquet files have a well-defined schema

  • ○

    Parquet files have the ability to be optimized

  • ○

    Parquet files will become Delta tables

Question 6

A data engineer is attempting to drop a Spark SQL table my_table. The data engineer 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?

Select an option, then click Submit answer.

  • ○

    The table's data was larger than 10 GB

  • ○

    The table's data was smaller than 10 GB

  • ○

    The table was external

  • ○

    The table did not have a location

  • ○

    The table was managed