When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

• A.A single join node uses more than 50% of the query time
• B.The query is spilling to remote storage
• C.Partitions scanned is equal to partitions total
• D.An AggregateOperacor node is present

Comment: *

Name: *

Email: *

Verification: *

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

• A.SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
• B.ACCOUNTADMIN
• C.SECURITYADMIN ACCOUNTADMIN, SYSADMIN
• D.SECURITYADMIN, ACCOUNTADMIN

Comment: *

Name: *

Email: *

Verification: *

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

• A.A Data Exchange allows accounts to share data with third, non-Snowflake parties.
• B.A Data Exchange allows groups of accounts to share data privately among the accounts.
• C.If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
• D.The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
• E.Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

Comment: *

Name: *

Email: *

Verification: *

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

• A.If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.
• B.If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.
• C.If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.
• D.If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.
• E.If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

Comment: *

Name: *

Email: *

Verification: *

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

• A.Reader
• B.Consumer
• C.Vendor
• D.Standard
• E.Personalized

Comment: *

Name: *

Email: *

Verification: *