These are the questions that come up again and again in Snowflake interviews for analyst and data engineer roles: a few to write in SQL, a few to explain. For the SQL ones, interviewers care that you reach for Snowflake's own tools (QUALIFY, FLATTEN, time travel) rather than the long way round. For the others, they want the one-sentence answer and the reason behind it.
Answer each one as if you were saying it out loud, then check. Read the explanation even when you're right: it's often the follow-up question.