Free Databricks-Certified-Data-Engineer-Associate – Databricks Certified Data Engineer Associate Exam Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Virtual Machines

• ○

  Compute Orchestration

• ○

  Serverless Compute

• ○

  Compute

• ○

  Unity Catalog
  

Select all that apply, then click Submit answer.

• ○

  SELECT * FROM students@v4

• ○

  SELECT * FROM students TIMESTAMP AS OF ˜2024-04-22T 14:32:47.000+00:00'

• ○

  SELECT * FROM students FROM HISTORY VERSION AS OF 3

• ○

  SELECT * FROM students VERSION AS OF 5

• ○

  SELECT * FROM students TIMESTAMP AS OF ˜2024-04-22T 14:32:58.000+00:00'
  

Select an option, then click Submit answer.

• ○

  Databricks Repos automatically saves development progress

• ○

  Databricks Repos supports the use of multiple branches

• ○

  Databricks Repos allows users to revert to previous versions of a notebook

• ○

  Databricks Repos provides the ability to comment on specific changes

• ○

  Databricks Repos is wholly housed within the Databricks Lakehouse Platform
  

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.
  

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
  

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
  

Select an option, then click Submit answer.

• ○

  Option A

• ○

  Option B

• ○

  Option C

• ○

  Option D

• ○

  Option E