Which statement about billing applies to Snowflake credits?

• A.Credits are billed per-minute with a 60-minute minimum
• B.Credits are used to pay for cloud data storage usage
• C.Credits are consumed based on the number of credits billed for each hour that a warehouse runs
• D.Credits are consumed based on the warehouse size and the time the warehouse is running

Comment: *

Name: *

Email: *

Verification: *

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

• A.The type of SQL statements executed
• B.The number of tables or databases queried
• C.The amount of data stored in the warehouse
• D.The length of time the compute resources in each cluster run

Comment: *

Name: *

Email: *

Verification: *

Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?

• A.GET_RELATIVE_PATH
• B.GET_PRESIGNED_URL
• C.BUILD_STAGE_FILE_URL
• D.BUILD_SCOPED_FILE_URL

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

• A.The column name is case-sensitive but element names are case-insensitive.
• B.The column name is case-insensitive but element names are case-sensitive.
• C.The column name and element names are both case-insensitive.
• D.The column name and element names are both case-sensitive.

Comment: *

Name: *

Email: *

Verification: *