Explanation:
The correct answer is C because the TRANSFORM higher-order function is specifically designed to apply a given function to each element in an array. In this scenario, we need to convert each food grain's quantity from kilograms to tons by dividing the quantity by 1000. The TRANSFORM function allows us to do this efficiently by iterating over each element in the food_grains array, applying the conversion, and then returning the transformed array. This approach is both concise and effective for the task at hand.
Example usage in the query:
TRANSFORM(food_grains, f -> f.food_grain_qty / 1000) as food_grains_qty_in_tons
TRANSFORM(food_grains, f -> f.food_grain_qty / 1000) as food_grains_qty_in_tons
This statement processes each element in the food_grains array, where f represents an individual element, and performs the division to convert the quantity from kilograms to tons.
Ultimate access to all questions.
No comments yet.
A data engineer is tasked with converting the quantity of food grains from kilograms to tons for a client dealing in agricultural products. The quantities are stored in a table named food_items. Given the schema of this table, which higher-order function should be used in the following query to achieve the desired conversion? (Note: 1 ton = 1000 kg)
SELECT warehouse_id,
food_grains,
____________ as food_grains_qty_in_tons
FROM food_items;
SELECT warehouse_id,
food_grains,
____________ as food_grains_qty_in_tons
FROM food_items;
A
MAP(food_grains, f -> f.food_grain_qty / 1000)
B
CONVERT(food_grains, f -> f.food_grain_qty / 1000)
C
TRANSFORM(food_grains, f -> f.food_grain_qty / 1000)
D
FLAT_MAP(food_grains, f -> f.food_grain_qty / 1000)
E
REDUCE(food_grains, f -> f.food_grain_qty / 1000)