Free Preparation Discussions
MENU
Snowflake Exam ARA-R01 Topic 3 Question 15 Discussion
Topic #: 3
The data share exists between a data provider account and a data consumer account. Five tables from the provider account are being shared with the consumer account. The consumer role has been granted the imported privileges privilege.
What will happen to the consumer account if a new table (table_6) is added to the provider schema?
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
Gabriele
2 months agoVerdell
2 months agoLucia
2 months agoDorsey
2 months agoKarma
3 months agoRueben
2 months agoJanna
2 months agoFiliberto
2 months agoRoxane
3 months agoLeila
3 months agoJesus
3 months agoTheron
3 months agoMarica
3 months agoMaurine
3 months agoMadelyn
3 months agoNovella
3 months agoEarlean
3 months agoRegenia
3 months agoEmelda
3 months agoIrving
2 months agoTasia
3 months agoFranklyn
3 months agoVernice
3 months agoSue
3 months agoJamey
3 months agoMagda
3 months ago