Which of the following are numeric data types supported by Snowflake? (Choose any 2 options)
Answer(s): A,D
Snowflake supports several numeric data types, includingINTEGER(and its aliases INT, BIGINT, SMALLINT, TINYINT) andFLOAT(a floating-point type). INTEGER represents exact whole numbers, and FLOAT supports approximate numerical values with fractional components. BOOLEAN is a logical data type used for TRUE/FALSE values, not numeric. VARCHAR is a string data type, also not numeric. Thus, INTEGER and FLOAT are the correct numeric data types supported by Snowflake.=====================
Which of the following are types of tables in Snowflake? (Choose any 3 options)
Answer(s): A,B,C
Snowflake provides three main table types:Permanent,Transient, andTemporary. Permanent tables support full Time Travel and Fail-safe, and are designed for long-term storage. Transient tables do not include Fail-safe and are best suited for intermediate or less durable datasets. Temporary tables exist only for the duration of the user session that created them, making them ideal for staging or ephemeral workloads. Snowflake does not have a table type called "Virtual"; therefore, the correct options are Permanent, Temporary, and Transient.=====================
What most accurately describe Snowflake?
Answer(s): C
Snowflake is best described as anAI Data Cloud Platform. While Snowflake originated as a cloud data warehouse, its capabilities have expanded to include secure data sharing, application development, machine learning workloads, unstructured data processing, Snowpark, and integrated LLM/AI functions (such as Snowflake Cortex and Streamlit). This broad ecosystem supports analytic workloads, governance, multi-cloud architecture, and AI-driven applications. It is not simply an ETL tool or a transactional database.=====================
Which SQL command is used to create a new database in Snowflake?
Answer(s): B
The correct SQL command for creating a new database in Snowflake isCREATE DATABASE database_name;. This initializes a new logical container for schemas and objects. USE DATABASE switches the active database context but does not create one. Snowflake does not support the shorthand CREATE DB or USE DB syntax. Therefore, CREATE DATABASE is the correct and only valid command for creating a database.=====================
Which of the following are key components of Snowflake's RBAC system? (Choose any 3 options)
Answer(s): B,C,D
Snowflake's RBAC security model revolves aroundUsers,Roles, andPrivileges. Users represent individual identities or service accounts. Roles group privileges and are assigned to users. Privileges define specific actions that can be performed on objects (e.g., SELECT, INSERT, OWNERSHIP). "Permissions" is not a formal RBAC component--permissions are effectively the result of privileges assigned to roles. Therefore, the three core RBAC components are Users, Roles, and Privileges.=====================
What is the purpose of a role hierarchy in Snowflake?
Role hierarchy in Snowflake allows one role to inherit the privileges of another. By granting roles to other roles, Snowflake enables scalable, maintainable access control. Higher-level roles grant privileges downward, allowing administrators to create layered access structures. This hierarchy simplifies permission management across teams and environments. It has no relation to SQL sequencing, network settings, or data storage.=====================
What is a key feature of custom roles in Snowflake? (Choose any 2 options)
Answer(s): B,D
Custom roles in Snowflake allow administrators to design access patterns aligned with organizational security requirements. They are created by Snowflake administrators and do not have predefined privileges; instead, privileges must be granted explicitly. Custom roles can be assigned to users or other roles, just like system-defined roles. Thus, the key attributes are that they are created by administrators and tailored to meet specific organizational needs.=====================
How can roles access objects in Snowflake? (Choose any 2 options)
Answer(s): A,B
Roles gain access to objects in Snowflake throughdirect privilege grantsor throughinheritancewithin a role hierarchy. A role may be explicitly granted privileges such as SELECT, OWNERSHIP, or USAGE. Alternatively, if a role is assigned to another role, it inherits all privileges of its parent role. Neither network settings nor data storage processes determine role access.=====================
Post your Comments and Discuss Snowflake SnowPro Associate Platform SOL-C01 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the SnowPro Associate Platform SOL-C01 content, but please register or login to continue.