Use Auto Loader with Schema Enforcement and Schema Evolution in Batch Modes (for Example, Directory Listing or File Notification) to Land Data into UnityCatalog–governed Tables. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 7)

Questions 31–33

1. 31application · medium

   A data engineer is setting up Auto Loader to ingest data from a new source. The source is known to occasionally add new columns, but the team wants to be alerted when this happens rather than having the ingestion fail or silently add columns. Which schema evolution mode should be used?

   • A`addNewColumns`
   • B`none`
   • C`failOnNewColumns`
   • D`rescue`
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   Which of the following is an example of schema evolution in Auto Loader?

   • AThe storage location of the data files changes
   • BThe number of files in the directory increases
   • CA new column is added to the incoming data files, and Auto Loader automatically includes it in the target table
   • DThe file format changes from CSV to JSON
   Reveal Solution Discussion Select an answer first
3. 33foundation · easy

   What is required to write Auto Loader output to a Unity Catalog table?

   • AThe target table must exist in a catalog and schema that the user has access to
   • BThe table must be created in the default catalog
   • CThe table must be created using SQL only
   • DThe table must be an external table
   Reveal Solution Discussion Select an answer first