Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam
Go to Exam

Exam SnowPro Advanced Architect topic 1 question 45 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 45
Topic #: 1
[All SnowPro Advanced Architect Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
by hillcat111 at June 9, 2023, 1:02 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
MSIDDIQUI18
1 week, 6 days ago
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>;
upvoted 1 times
...
Pk2287
3 months, 4 weeks ago
Answer is C & E.. A,B and D options are not possible considering share data is read only
upvoted 1 times
...
drunk_goat82
7 months ago
Selected Answer: CE
CAN'T CLONE A TABLE from a share.
upvoted 1 times
...
DataKelpie
1 year, 4 months ago
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
upvoted 2 times
...
hillcat111
1 year, 5 months ago
Answer is A&C
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel