APICS Certified Supply Chain Professional (CSCP) — Question 183

Which of the following benefits is provided by the array functions from Spark SQL?

Answer options

• A. An ability to work with data in a variety of types at once
• B. An ability to work with data within certain partitions and windows
• C. An ability to work with time-related data in specified intervals
• D. An ability to work with complex, nested data ingested from JSON files
• E. An ability to work with an array of tables for procedural automation

Correct answer: D

Explanation

The correct answer, D, highlights how Spark SQL array functions can effectively handle complex and nested data structures that are often found in JSON files. The other options, while they represent useful features of Spark SQL, do not specifically relate to the unique capabilities of array functions.