Learn about the actions a company can take with an inbound share in Snowflake, including cloning tables from the share and creating table streams on shared tables.
Table of Contents
Question
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.
Which actions can the company take with the inbound share? (Choose two.)
A. Clone a table from a share.
B. Grant modify permissions on the share.
C. Create a table from the shared database.
D. Create additional views inside the shared database.
E. Create a table stream on the shared table.
Answer
A. Clone a table from a share.
E. Create a table stream on the shared table.
Explanation
When a company has an inbound share set up with eight tables and five secure views, and plans to make the share part of its production data pipelines, it can take the following actions:
A. Clone a table from a share.
E. Create a table stream on the shared table.
Cloning a table from a share allows the company to create a copy of the shared table within their own Snowflake account. This cloned table is independent of the original shared table and can be modified, queried, and used in the company’s data pipelines without affecting the source data.
Creating a table stream on a shared table enables the company to track and capture changes made to the shared table over time. Table streams provide a way to monitor and process incremental updates to the shared data, which is particularly useful when integrating the shared data into production data pipelines.
The other options mentioned are not valid actions for inbound shares:
B. Grant modify permissions on the share: The company receiving the inbound share cannot grant modify permissions on the share itself, as share permissions are controlled by the share provider.
C. Create a table from the shared database: While the company can query the shared tables and views, they cannot directly create new tables within the shared database.
D. Create additional views inside the shared database: Similar to creating tables, the company cannot create additional views within the shared database. Views can only be created by the share provider.
Snowflake SnowPro Advanced Architect certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Advanced Architect exam and earn Snowflake SnowPro Advanced Architect certification.