During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

• A.STATEMENT_TIMEOUT__IN__SECONDS
• B.STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
• C.MAX_CONCURRENCY__LEVEL
• D.QUERY_TIMEOUT_IN_SECONDS

Comment: *

Name: *

Email: *

Verification: *

What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?

• A.IO
• B.Network
• C.Pruning
• D.Spilling

Comment: *

Name: *

Email: *

Verification: *

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• A.Customer-managed encryption keys through Tri-Secret Secure
• B.Automatic encryption of all data
• C.Up to 90 days of data recovery through Time Travel
• D.Object-level access control
• E.Column-level security to apply data masking policies to tables and views

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

• A.Caching
• B.Cluster depth
• C.Query pruning
• D.Retrieval optimization

Comment: *

Name: *

Email: *

Verification: *

Assuming the data provider has granted the required permissions to the objects in a share, which statement will grant permissions to the role consumer_role, allowing access to the database share_db?

• A.grant all on database share_db to role consumer_role;
• B.grant usage on database share_db to role consumer_role;
• C.grant imported privileges on database share_db to role consumer_role;
• D.grant ownership on database share_db to role consumer_role;

Comment: *

Name: *

Email: *

Verification: *