Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Advanced: Architect · Snowflake
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
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>;
Answer is C & E.. A,B and D options are not possible considering share data is read only
CAN'T CLONE A TABLE from a share.