SOL-C01 Practice Questions

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.

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

PARSE_DOCUMENT supports two processing modes:OCRandLAYOUT. OCR mode performs Optical Character Recognition, extracting raw text from scanned documents, images within PDFs, or low-quality text-based documents. It is ideal for scenarios like contract ingestion, receipt processing, or older scanned documents. LAYOUT mode extracts structured layout elements—tables, paragraphs, lines, bounding boxes—preserving the original document’s spatial organization. This enables downstream analytical tasks such as table reconstruction or semantic segmentation of document content. OMR (Optical Mark Recognition) is not a supported feature, and “CONTENT” is not a valid mode. By supporting OCR and LAYOUT modes, Snowflake Cortex provides robust document intelligence capabilities directly within the Snowflake environment.

TheData Storage Layerin Snowflake stores all data in acompressed, encrypted, columnar formatdesigned for analytical efficiency. Snowflake automatically reorganizes ingested data into micro-partitions optimized for pruning and high-performance scans. The compression and structuring are fully automated, requiring no tuning or indexing by the user.

Another foundational feature iselastic storage, made possible by Snowflake’s cloud-native architecture. Storage automatically scales up or down based on data volume without user intervention, and is separated from compute. This ensures cost efficiency and immediate availability of capacity for large datasets.

Incorrect options:

In-memory storageis not a Snowflake feature; long-term data is persisted in cloud object storage.

Elastic Cloudis not a Snowflake architectural term.

The Data Storage Layer is designed for durability, scalability, and optimal query performance.

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