SOL-C01 Exam Dumps - SnowPro Associate: Platform Certification Exam

The Snowsight Monitoring tab provides a centralized view of virtual warehouse usage metrics, enabling administrators and developers to evaluate how compute resources are being consumed. This includes critical insights such as credit usage, query load, concurrency levels, average queue times, execution durations, and auto-scaling activity (for multi-cluster warehouses). These metrics help determine whether a warehouse is correctly sized, whether concurrency issues are occurring, or whether workloads require scaling up or adding clusters.

Query history is available in a different section—“Activity → Query History”—not under Monitoring. Time Travel snapshots are not visualized within Monitoring; Time Travel is controlled via retention parameters and accessed with SQL (AT/BEFORE clauses). Schema change history is also not part of Monitoring and instead is discoverable through ACCOUNT_USAGE or specific metadata views.

The Monitoring tab exists specifically to help evaluate warehouse performance and resource consumption, enabling optimization of compute spending and better workload management.

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

Snowflake is a fully cloud-native platform that supports deployment across all three major cloud providers:AWS, GCP, and Azure. Snowflake delivers consistent functionality across each provider, allowing organizations to choose the cloud best suited for regulatory, architectural, and business requirements. Although small feature differences may exist between cloud providers, Snowflake’s core capabilities—virtual warehouses, storage layers, security, data sharing, and governance—operate uniformly across all three platforms. This multi-cloud support gives Snowflake strong flexibility for hybrid, multi-region, and multi-cloud deployments.

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

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.

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

The FLATTEN table function expands semi-structured data such as arrays or objects stored in VARIANT columns. Its output includes several metadata columns, and the most important among them isVALUE, which contains the extracted element from the array or object. VALUE is the column that developers typically join on or reference to access the flattened data.

In addition to VALUE, FLATTEN returns KEY (for object keys), INDEX (position in arrays), SEQ (internal ordering), and PATH (hierarchical reference path). These other columns support analytical or transformation logic, but VALUE remains the primary output used for downstream SQL.

The other listed options—OUTPUT, ROWNUM, and LEVEL—are not part of the FLATTEN function’s output schema. ROWNUM and LEVEL may appear in other SQL contexts but not in FLATTEN results. Therefore, the correct answer is VALUE.

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

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.