Free Preparation Discussions
MENU
Snowflake Exam ARA-R01 Topic 3 Question 25 Discussion
Topic #: 3
An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running.
Why is this occurring?
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
Shelba
2 months agoAgustin
11 days agoWilliam
15 days agoWeldon
30 days agoEllsworth
2 months agoRyan
12 days agoDesmond
14 days agoDorothy
17 days agoRyan
21 days agoTrinidad
30 days agoJacquelyne
1 months agoAvery
2 months agoDeeann
2 months agoMelynda
2 months agoKristian
2 months agoGerman
2 months agoMarylin
3 months agoBrynn
2 months agoLeontine
2 months agoRene
3 months agoBenton
1 months agoRolland
2 months agoGianna
2 months agoChandra
2 months agoCarolann
3 months agoJonelle
3 months agoLinn
3 months ago