Which Snowflake function constructs an OBJECT from the arguments provided by a query (such as table columns)?

• A. object_deconstruct(*)
• B. to_json_object(*)
• C. object_construct(*)
• D. to_object(*)

Answer: (C)

Building an OBJECT from a query’s row means turning the row’s columns into key-value pairs inside a single object. In Snowflake, OBJECT_CONSTRUCT is designed for this: you can pass a list of keys and values, and when you use an asterisk to expand the row (OBJECT_CONSTRUCT(*)), each column name becomes a key and its value becomes the corresponding value. The result is a VARIANT containing an object like {col1: value1, col2: value2, …}.

This is why it’s the best choice here. The other options don’t perform this row-to-object construction: object_deconstruct converts an existing object into its fields, not the other way around. The others aren’t standard methods for building an object from a table’s columns.