Public-works engineers need scalable ETL-style transforms to clean messy permit text fields before loading a warehouse. Which Hadoop-era tool is aimed at that scripting/dataflow style?
Select an answer to reveal the explanation.
Short Explanation
Cleaning messy permit text at scale is an assembly-line script, not a shopping-cart lock. Pig was built for that high-level dataflow style on Hadoop. OLTP procedures and cloud-fundamentals trivia miss the job.
Full Explanation
Pig offers a scripting/dataflow abstraction over Hadoop so teams can express multi-step ETL transforms without writing every MapReduce job by hand. Cleaning and normalizing civic permit text fields is a classic fit. OLTP row locking, AZ-900 SKU recall, and CAP slogans are not substitutes for that batch transform layer.