Save Data to Persistent Tables While Applying Sorting and Partitioning to Optimize Data Retrieval. ASSOCIATE-DEVELOPER-APACHE-SPARK Practice Questions (Page 5)

Questions 21–22

1. 21foundation · easy

   In Spark SQL, what is a persistent table?

   • AA file in a distributed file system that is read directly by Spark without a schema.
   • BA table that is registered in the metastore and persists across sessions and applications.
   • CA temporary view that is available only within the current Spark session.
   • DA DataFrame that is cached in memory and shared across all sessions.
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A financial services company frequently joins a large `transactions` table with a smaller `customers` table on the `customer_id` column. The join is a bottleneck. You decide to bucket the `transactions` table by `customer_id`. To maximize the benefit of bucketing for the join, what additional configuration should you apply?

   • APartition the `transactions` table by `customer_id`
   • BBucket the `customers` table by `customer_id` with the same number of buckets
   • CSort the `transactions` table by `customer_id` within each bucket
   • DIncrease the number of buckets to a large value like 1000
   Reveal Solution Discussion Select an answer first