Which of the following describes a Snowflake stored procedure?

• A.They can be created as secure and hide the underlying metadata from the user.
• B.They can be created to run with a caller's rights or an owner's rights.
• C.They can only access tables from a single database.
• D.They can contain only a single SQL statement.

Comment: *

Name: *

Email: *

Verification: *

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

• A.Information Schema -> TABLE_FUNCTION
• B.Information Schema -> TABLE_HISTORY
• C.SHOW TABLES;
• D.SHOW STORAGE BY TABLE;
• E.Information Schema -> TABLE_STORAGE_METRICS

Comment: *

Name: *

Email: *

Verification: *

When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

• A.1 hour
• B.2 hours
• C.4 hours
• D.8 hours

Comment: *

Name: *

Email: *

Verification: *

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

• A.32
• B.16
• C.4
• D.8

Comment: *

Name: *

Email: *

Verification: *

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

• A.Table definition
• B.Stage definition
• C.Session level
• D.COPY INTO TABLE statement

Comment: *

Name: *

Email: *

Verification: *