Snowflake interview question

EtL Cycles, SQL Queries, Resume based, flatten an array, string match