What Snowflake parameter is configured in the Query Processing layer?
Answer(s): C
The Query Processing layer of Snowflake is wherevirtual warehouses operate, so warehouse sizing parameters (X-Small to 6X-Large) fall under this layer. Warehouse size determines compute power, concurrency, and performance behavior for SQL workloads. Administrators configure warehouse size based on workload intensity, response time requirements, and cost considerations.Serverless compute limits and micro-partition limits belong to storage and services layers. Table types (permanent, transient, temporary) are storage-level configurations, not part of Query Processing.Thus, warehouse sizing is the correct parameter configured at the Query Processing layer.
What is the primary benefit of the Snowflake data cloud?
Answer(s): D
The Snowflake Data Cloud allows organizations toseamlessly share, access, and collaborate on dataacross departments and external partners, without copying or moving data. Through secure data sharing, listings, and data clean rooms, Snowflake eliminates data silos and dramatically improves data collaboration.It does not eliminate the need for governance--Snowflake enhances governance via RBAC, masking policies, and centralized controls. It does not provide access to underlying cloud infrastructure; Snowflake abstracts that. It is not an on-premises solution; Snowflake is fully cloud-native.Thus, the primary benefit is unifying and securely sharing data across the ecosystem.
What is the recommended way to provide a role with access to a Snowflake object?
The recommended approach in Snowflake's RBAC model is togrant privileges to roles, not to individual users or through ownership transfers. Privileges such as SELECT, INSERT, USAGE, and MODIFY are granted to roles, and roles are then assigned to users--creating scalable governance.Transferring ownership is a powerful action and should not be used simply to provide access. The PUBLIC role should not be used to grant sensitive privileges since it is granted to all users by default. Cloning objects is unnecessary and creates new objects, not access to the original.Thus, granting privileges to the role is the correct RBAC practice.
Which role is a system defined role in Snowflake?
Answer(s): A
USERADMIN is one of Snowflake'ssystem-defined roles, created automatically in every account. It is responsible for managing users and roles, including CREATE USER, ALTER USER, and role assignment. It is part of Snowflake's default RBAC hierarchy (SYSADMIN, SECURITYADMIN, USERADMIN, etc.).SNOWFLAKE_ADMIN and SNOWFLAKE_DBA are not Snowflake system roles--they may exist in organizations as custom roles but do not appear by default. DATA_ENGINEER is also user-created and not a built-in role.Therefore, USERADMIN is the only true system-defined role listed.
What are characteristics of schemas in Snowflake? (Select TWO).
Answer(s): D,E
Schemas in Snowflake serve asorganizational containersfor database objects such as tables, views, sequences, stages, file formats, and functions. They existwithin a database, forming Snowflake's logical hierarchy: account database schema object.Schemas are not limited to a single role; access depends on granted privileges. Schemas are not immutable--administrators can rename, alter, or drop them. Schemas do not contain virtual warehouses; warehouses exist independently at the account level.Thus, the correct characteristics are that schemas organize objects and are contained within a database.
What is a database in Snowflake?
A Snowflake database is alogical containergrouping one or more schemas. It does not store data physically in the traditional sense--Snowflake abstracts physical storage into its cloud-native micro- partitioned storage layer. Because schemas contain tables, views, and other objects, a database organizes schemas logically, enabling governance, naming conventions, and security boundaries.A virtual warehouse is compute, not storage. A "collection of tables and views" better describes a schema, not a database. Snowflake separates logical structure from physical storage, so a database is not a physical file repository.Thus, a database is best defined as a logical grouping of schemas.
Which SQL keyword is used to constrain the number of rows returned by a query in Snowflake? (Select TWO)
Answer(s): A,D
Snowflake supports bothTOPandLIMITas valid SQL mechanisms for restricting the number of rows returned by a query. They function similarly but are used in different syntactic positions.LIMITappears at the end of the query:SELECT * FROM my_table LIMIT 10;This tells Snowflake to return only the specified number of rows.TOPis used in the SELECT clause:SELECT TOP 10 * FROM my_table;Both approaches are equivalent in functionality and are supported to maintain compatibility with ANSI SQL and other SQL dialects.The other options are not correct row-limiting mechanisms:·SELECTis a required keyword but does not limit rows on its own.·GETis not a SQL keyword for row restriction; GET is used for downloading files from internal stages.·ROW_NUMBERis a window function used for ranking rows, not constraining row count.Therefore, TOP and LIMIT are the only correct SQL keywords in Snowflake for controlling how many rows are returned by a query.
What are characteristics of the Snowflake Platform? (Select TWO).
Answer(s): C,D
Snowflake is a fully managed, cloud-native platform that automates nearly all infrastructure tasks.Two defining characteristics are:1. Snowflake handles platform maintenance, management, and upgrades.Snowflake automatically performs software updates, scaling operations, tuning, optimization, and patching. Users never need to upgrade hardware, install software, or manage clusters.2. There is no infrastructure for customers to provision and maintain.All compute, storage, and services run on public clouds (AWS, Azure, GCP). Snowflake abstracts the underlying infrastructure completely, eliminating the need for customers to manage VMs, disks, clusters, or networking.Incorrect options:· Snowflake supportsbothcolumn-level security (via masking policies)androw-level security (via row access policies).· Snowflake is not responsible foralldata security--customers must configure RBAC, masking, and governance.· Snowflake doesnotrun on-premises; it is exclusively cloud-based.Thus, options C and D correctly describe Snowflake platform characteristics.
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.