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 Core Certification · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
D. The stored procedures and views will refer to tables in the source database
Fully Qualified table reference means, specifying the table name like the below, <DB>.<Schema>.<TableName>. The questions says, the DB containing stored procedures and regular views (reason it was told a regular view is, for secure view the table cross reference across DB needs a REFERENCE GRANT) that have a fully qualified table references. If its a not a qualified name, then the Table will be looked into the current DB, which is the DB in which the cloned SP and Views are created.
For sure D. Just tested this.