During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?

• A.Data loading will fail when the snowpipe is triggered
• B.All the files will be loaded into stage again
• C.Snowpipe loads duplicate data into the source table

Comment: *

Name: *

Email: *

Verification: *

Snowflake recommends starting slowly with SEARCH OPTIMIZATION(i.e. adding search optimization to only a few tables at first) and closely monitoring the costs and benefits.

• A.TRUE
• B.FALSE

Comment: *

Name: *

Email: *

Verification: *

If your role does not own the share, but owns the objects in the share, how can you block access to the objects

• A.Revoking the USAGE or SELECT privileges with CASCADE on the objects from the share owner.
• B.You will need to connect with the share owner
• C.Revoking the USAGE or SELECT privileges on the objects from the share owner

Comment: *

Name: *

Email: *

Verification: *

Snowflake supports the following query performance optimizing methods

• A.Retrieving results of previous query from cache
• B.B-tree type indexes
• C.Caching techniques

Comment: *

Name: *

Email: *

Verification: *

SNOWPIPE_AUTO_INGEST is supported for external stages only

• A.TRUE
• B.FALSE

Comment: *

Name: *

Email: *

Verification: *