Online Access Free SnowPro-Core Exam Questions

Which data types optimally store semi-structured data? (Select TWO).

• A.VARCHAR
• B.VARIANT
• C.ARRAY
• D.STRING
• E.CHARACTER

Which SQL command can be used to verify the privileges that are granted to a role?

• A.SHOW GRANTS TO ROLE <Role Name>
• B.SHOW GRANTS FOR ROLE <Role Name>
• C.SHOW ROLES <Role Name>
• D.SHOW GRANTS ON ROLE <Role Name>

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

• A.Query processing
• B.Authentication and access control
• C.Metadata management
• D.Local disk caching
• E.Database storage

A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

• A.ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY
• B.ALTER TABLE <TABLE NAME> REMOVE CLUSTERING KEY
• C.ALTER TABLE <TABLE NAME> DELETE CLUSTERING KEY
• D.ALTER TABLE <TABLE NAME> PURGE CLUSTERING KEY

Which Snowflake function will parse a JSON-null into a SQL-null?

• A.TO_CHAR
• B.STRIP NULL VALUE
• C.TO_VARCHAR
• D.TO_VARIANT