Execute SQL Queries Directly on Files, Including ORC Files, JSON Files, CSV Files, Text Files, and Delta Files, and Understand the Different Save Modes for Outputting Data in Spark SQL. ASSOCIATE-DEVELOPER-APACHE-SPARK Practice Questions (Page 3)

Questions 11–15

1. 11expert · hard

   A team has a Delta table at /data/events that receives streaming updates. A nightly batch job reads the table and writes a snapshot to /data/snapshot for reporting. The job must ensure that the snapshot reflects the state of the table at a specific point in time, even if new data arrives during the job. Which approach should they use?

   • ARead the table normally and write with Overwrite mode.
   • BRead the table with VERSION AS OF and write with ErrorIfExists mode.
   • CUse TIMESTAMP AS OF to read the table at the current time, then write with Append mode.
   • DUse VERSION AS OF to read the table at the version captured at the start of the job, then write with Overwrite mode.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which save mode should you use to add new records to an existing Delta table without removing the existing data?

   • AOverwrite
   • BAppend
   • CErrorIfExists
   • DIgnore
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   When querying a text file directly with Spark SQL, what does each row in the result represent?

   • AThe entire file becomes a single string value in one row.
   • BEach line is parsed into multiple columns based on a delimiter.
   • CEach word in the file becomes a separate row.
   • DEach line of the file becomes a single string value in a column named `value`.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which property of Delta Lake ensures that concurrent writes to a Delta table do not corrupt the data?

   • AACID transactions
   • BPartition pruning
   • CSchema inference
   • DTime travel
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which Spark SQL feature enables querying a directory of JSON files without first creating a table in a metastore?

   • AThe ability to reference the file path directly in the FROM clause, with schema inference.
   • BThe use of Hive's external table syntax with a LOCATION clause.
   • CThe need to load the files into a DataFrame and register a temporary view first.
   • DThe requirement to define a custom SerDe for each file format before querying.
   Reveal Solution Discussion Select an answer first