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.
Correct Answer: CE
CREATE DATABASE c1 FROM SHARE provider1.share1;
Creating streams on shared objects (secure views or tables) enables you to track data manipulation language (DML) changes made in those objects.
CREATE STREAM <name> ON TABLE <shared_db>.<schema>.<table>;
On the basis of this documentation, the answer is C and E
https://docs.snowflake.com/en/user-guide/data-share-consumers#step-1-create-a-database-from-the-share
The reasoning is as follows:
Cloning of shared databases is not supported
They cannot be modified
Streaming (CDC) of updates is supported
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MSIDDIQUI18
7 months, 1 week agoPk2287
10 months, 3 weeks agodrunk_goat82
1 year, 1 month agoDataKelpie
1 year, 10 months agohillcat111
2 years ago