ExamGecko
Question list
Search
Search

List of questions

Search

Question 3 - ARA-C01 discussion

Report
Export

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.
Answers
A.
Clone a table from a share.
B.
Grant modify permissions on the share.
Answers
B.
Grant modify permissions on the share.
C.
Create a table from the shared database.
Answers
C.
Create a table from the shared database.
D.
Create additional views inside the shared database.
Answers
D.
Create additional views inside the shared database.
E.
Create a table stream on the shared table.
Answers
E.
Create a table stream on the shared table.
Suggested answer: A, D

Explanation:

These two actions are possible with an inbound share, according to the Snowflake documentation and the web search results. An inbound share is a share that is created by another Snowflake account (the provider) and imported into your account (the consumer). An inbound share allows you to access the data shared by the provider, but not to modify or delete it. However, you can perform some actions with the inbound share, such as:

Clone a table from a share. You can create a copy of a table from an inbound share using the CREATE TABLE ... CLONE statement. The clone will contain the same data and metadata as the original table, but it will be independent of the share.You can modify or delete the clone as you wish, but it will not reflect any changes made to the original table by the provider1.

Create additional views inside the shared database. You can create views on the tables or views from an inbound share using the CREATE VIEW statement. The views will be stored in the shared database, but they will be owned by your account.You can query the views as you would query any other view in your account, but you cannot modify or delete the underlying objects from the share2.

The other actions listed are not possible with an inbound share, because they would require modifying the share or the shared objects, which are read-only for the consumer.You cannot grant modify permissions on the share, create a table from the shared database, or create a table stream on the shared table34.

Cloning Objects from a Share | Snowflake Documentation

Creating Views on Shared Data | Snowflake Documentation

Importing Data from a Share | Snowflake Documentation

Streams on Shared Tables | Snowflake Documentation

asked 23/09/2024
Musaddiq Shorunke
44 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first