Snowflake Related Exams
ARA-C01 Exam
An Architect has a table called leader_follower that contains a single column named JSON. The table has one row with the following structure:
{
"activities": [
{ "activityNumber": 1, "winner": 5 },
{ "activityNumber": 2, "winner": 4 }
],
"follower": {
"name": { "default": "Matt" },
"number": 4
},
"leader": {
"name": { "default": "Adam" },
"number": 5
}
}
Which query will produce the following results?
ACTIVITY_NUMBER
WINNER_NAME
1
Adam
2
Matt
Which Snowflake objects can be used in a data share? (Select TWO).
A Snowflake Architect created a new data share and would like to verify that only specific records in secure views are visible within the data share by the consumers.
What is the recommended way to validate data accessibility by the consumers?