Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ARA-R01 Topic 3 Question 25 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 25
Topic #: 3
[All ARA-R01 Questions]

An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running.

Why is this occurring?

Show Suggested Answer Hide Answer
Suggested Answer: D

When a new table (table_6) is added to a schema in the provider's account that is part of a data share, the consumer will not automatically see the new table. The consumer will only be able to access the new table once the appropriate privileges are granted by the provider. The correct process, as outlined in option D, involves using the provider's ACCOUNTADMIN role to grant USAGE privileges on the database and schema, followed by SELECT privileges on the new table, specifically to the share that includes the consumer's database. This ensures that the consumer account can access the new table under the established data sharing setup. Reference:

Snowflake Documentation on Managing Access Control

Snowflake Documentation on Data Sharing


Contribute your Thoughts:

Rene
2 days ago
Hmm, I'm pretty sure the tasks can't be cloned since they are tied to the original database. Option A seems like the obvious choice here.
upvoted 0 times
...
Carolann
7 days ago
Maybe the objects that the tasks reference are not fully qualified.
upvoted 0 times
...
Jonelle
8 days ago
I agree with Linn, cloned tasks need to be manually resumed.
upvoted 0 times
...
Linn
10 days ago
I think the tasks are suspended by default.
upvoted 0 times
...

Save Cancel