Online Access Free SnowPro-Core Exam Questions

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)

• A.The ACCOUNTADMIN role must be granted to only one user.
• B.Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
• C.Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
• D.All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
• E.All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

• A.The number of queries executed
• B.The size of the virtual warehouse
• C.The number of active users assigned to the warehouse
• D.The duration of the queries that are executed
• E.The length of time the warehouse is running

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

• A.A role that has been granted the ATTACH POLICY privilege
• B.A user with a SECURITYADMIN or higher role
• C.A role that has the NETWORK_POLlCY account parameter set
• D.A user with an USERADMIN or higher role
• E.A role that has the ownership of the network policy

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

• A.Percentage scanned from cache
• B.Bytes scanned
• C.Partitions total
• D.Partitions scanned
• E.Bytes written to result

What can a user win a reader account do in Snowflake?

• A.Update existing data
• B.Create a new snare
• C.Load now data
• D.Query shared data