← Back to exam page

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

Loading demo links...

Showing 7–9 of 17 questions

Question 7 (Topic 1)

What describes the relationship between Gold tables and Silver tables?

Select an option, then click Submit answer.

  • ○ Gold tables are more likely to contain aggregations than Silver tables.
  • ○ Gold tables are more likely to contain valuable data than Silver tables.
  • ○ Gold tables are more likely to contain a less refined view of data than Silver tables.
  • ○ Gold tables are more likely to contain truthful data than Silver tables.
Question 8 (Topic 1)

A data engineer has developed a data pipeline to ingest data from a JSON source using Auto Loader, but the engineer has not provided any type inference or schema hints in their pipeline. Upon reviewing the data, the data engineer has noticed that all of the columns in the target table are of the string type despite some of the fields only including float or boolean values. Why has Auto Loader inferred all of the columns to be of the string type?

Select an option, then click Submit answer.

  • ○ Auto Loader cannot infer the schema of ingested data
  • ○ JSON data is a text-based format
  • ○ Auto Loader only works with string data
  • ○ All of the fields had at least one null value
Question 9 (Topic 1)

Which query is performing a streaming hop from raw data to a Bronze table?

Select an option, then click Submit answer.

  • ○

  • ○

  • ○

  • ○