Housing analysts who already write SQL want ad-hoc summaries over Hadoop tables, while an ETL team prefers scripted dataflow transforms. How should the city choose between Hive and Pig?
Select an answer to reveal the explanation.
Short Explanation
Match the tool to the cook: SQL folks grab Hive; dataflow scripters often grab Pig. Same kitchen (Hadoop), different utensils. Neither choice is "always," and cloud-fundamentals flashcards are not a query engine.
Full Explanation
Hive presents a SQL-like interface over data in Hadoop, which fits analysts already fluent in declarative queries. Pig emphasizes a scripting/dataflow style useful for ETL-style transforms. Choice should follow persona and task shape, not absolute bans. Vendor cloud-associate exam content is outside BDPC MapReduce tooling selection.