Snowflake SOL-C01 Exam Dumps

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.

=======================================

Snowflake provides two main types of stages:Internal stagesandExternal stages. Internal stages reside inside Snowflake and include user stages, table stages, and named internal stages. These offer convenient, secure storage within Snowflake's managed environment. External stages reference cloud storage locations such as AWS S3, Azure Blob Storage, or Google Cloud Storage, enabling integration with external data repositories. Snowflake does not define a stage type called ''Public'' or ''Private,'' although stages can be granted secure access. Thus, the correct types are Internal and External stages.

Schemas serve as logical containers within a database, grouping tables, views, file formats, functions, and other objects.

Roles control access, not organization.

Tables store data but do not group objects.

Stages store files or point to external storage; they are not organizational containers.

==================

To create a new schema in Snowsight, users must follow the hierarchical navigation of Snowflake's object structure. The correct sequence is:

Data Database Create Schema

Steps:

Open theDatatab in the left navigation.

Select aDatabasewhere the schema will be created.

ChooseCreate Schema.

Enter the schema name and (optionally) description.

ClickCreate.

Incorrect options:

''Add Data'' is used for loading files, not creating schema objects.

''Data Create Schema'' is incomplete because Snowflake must knowwhich databasethe schema belongs to.

''Data Product'' is unrelated to object creation.

Thus, Snowflake requires explicit database context before schema creation.

Snowflake Data Exchange is not enabled by default. Accounts must open a support request to Snowflake Support, which then activates the feature. It cannot be enabled via UI or SQL. After activation, administrators may create private exchanges and listings.