When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

• A.The cloned views and the stored procedures will reference the cloned tables in the cloned database.
• B.An error will occur, as views with qualified references cannot be cloned.
• C.An error will occur, as stored objects cannot be cloned.
• D.The stored procedures and views will refer to tables in the source database.

Comment: *

Name: *

Email: *

Verification: *

What is true about sharing data in Snowflake? (Choose two.)

• A.The Data Consumer pays for data storage as well as for data computing.
• B.The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
• C.A Snowflake account can both provide and consume shared data.
• D.The Provider is charged for compute resources used by the Data Consumer to query the shared data.
• E.The Data Consumer pays only for compute resources to query the shared data.

Comment: *

Name: *

Email: *

Verification: *

Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Select TWO.)

• A.A column that appears most frequently in ORDER BY operations
• B.A column that appears most frequently in r.im z operations
• C.A column that appears most frequently in GROUP BY operations
• D.A column that appears most frequently in aggregate operations
• E.A column that appears most frequently in join operations

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

• A.No virtual warehouse will be used, data will be read from the result cache.
• B.No virtual warehouse will be used, data will be read from the local disk cache.
• C.The default virtual warehouse will be used to read all data.
• D.The virtual warehouse that is defined at the session level will be used to read all data.

Comment: *

Name: *

Email: *

Verification: *

Which statement best describes '' clustering''?

• A.The database administrator must define the clustering methodology for each Snowflake table.
• B.The clustering key must be included on the COPV command when loading data into Snowflake.
• C.Clustering can be disabled within a Snowflake account.
• D.Clustering represents the way data is grouped together and stored within snowflake's micro-partitions

Comment: *

Name: *

Email: *

Verification: *