Online Access Free SOL-C01 Exam Questions

What is the primary responsibility of Role Hierarchy in Snowflake's access control model?

• A.To define the order of SQL command execution
• B.To allow roles to inherit privileges from parent roles
• C.To categorize different types of users
• D.To specify the size of virtual warehouses

Which SQL function is used to parse a string as JSON data within a Snowflake query?

• A.EXTRACT_JSON()
• B.TO_JSON()
• C.PARSE_JSON()
• D.CONVERT_JSON()

Which cloud platforms does Snowflake support?

• A.Amazon Web Services (AWS)
• B.Microsoft Azure
• C.All of the options
• D.Google Cloud Platform (GCP)

What happens when you execute the following command in Snowflake?
DROP SCHEMA IF EXISTS marketing_schema;

• A.An error is returned if the schema does not exist
• B.The schema "marketing_schema" is dropped even if it contains tables
• C.The schema "marketing_schema" is created if it does not exist
• D.The schema "marketing_schema" is dropped only if it exists

What are the three key layers of Snowflake's architecture?

• A.Data Repository, Compute Clusters, Metadata Management
• B.Authentication, Access Control, Cloud Services
• C.Data Storage, Query Processing, Cloud Services
• D.Database Storage, ODBC Drivers, Virtual Warehouses