SOL-C01 Question #106: Real Exam Question with Answer & Explanation

Question

You have a JSON file stored in an internal stage containing customer data with varying schem

Options

• ASome customers have address information stored as a nested JSON object, while others have it
• BUse the `LATERAL FLATTEN' function to explode the JSON and then use and to handle different
• CLoad the JSON data into a relational table and use a 'UNION ALL' query to combine records with
• DCreate two different views: one for customers with nested address objects and another for
• EUse to dynamically determine the column type and then apply appropriate conversion functions.
• FUse a stored procedure to iterate through each JSON record, determine the address format, and

Explanation

'LATERAL FLATTEN' helps process JSON and then the and functions are used to handle the different formats of the address. This is the most efficient approach. Loading into a relational table is not suited for semi-structured data. Using two views then UNION ALL is a valid strategy, however Flatten will be more efficient. Using a stored procedure would be inefficient.

No community discussion yet for this question.