DatabricksCertified Associate Developer for Apache Spark
Domain 2Objective 2
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 4)
Part of the Using Spark SQL domain, which accounts for 20% of the ASSOCIATE-DEVELOPER-APACHE-SPARK exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~7–12 in this domain), expect 2–3 from this objective — we provide 19 practice questions to prepare you well beyond it. (estimate)
19questions here
4free pages
7concepts
20%of the exam
Questions 16–19
- 16
Which SQL statement correctly queries an ORC file located at `/data/events.orc`?
Select an answer first - 17
A nightly job writes the results of a SQL query to /data/daily_sales using df.write.save(). The job failed yesterday, so the file does not exist. Today's run must create the file. If the job runs again tomorrow, it should replace yesterday's data. Which save mode should be used?
Select an answer first - 18
Which SQL statement correctly queries a text file at `/data/log.txt`?
Select an answer first - 19
Which save mode in Spark SQL will fail if the target location already contains data?
Select an answer first
Finished these 4 questions?
Review the revealed explanations, or continue through the curriculum.
No more pagesBack to ASSOCIATE-DEVELOPER-APACHE-SPARK
Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “ASSOCIATE-DEVELOPER-APACHE-SPARK” is a trademark of its owner, used for identification only.