What does a red checkmark next to a cell in a Snowflake notebook signify?
Answer(s): A
A red checkmark in Snowflake Notebooks indicates that the cell encountered anerrorduring execution. This visual indicator helps users quickly identify issues so they can inspect the error message and adjust code accordingly. Successful execution shows a green checkmark, while running cells show a spinner. Snowflake notebooks do not include a "paused" state for notebook cells.=====================
How can users integrate Streamlit with Snowflake notebooks?
Answer(s): D
Snowflake Notebooks provide native integration with Streamlit, allowing users to build interactive data apps directly inside Snowflake. Users can call Streamlit functions such as st.write(), st.dataframe(), st.button(), and st.slider() within Python cells. No external HTML, scripting, or network configuration is required. Streamlit components execute seamlessly in the notebook environment, enabling dashboards and interactive visualizations on top of Snowflake data.=====================
Which option is available in Snowsight for loading data from a local file?
Snowsight provides adrag-and-dropinterface for uploading data from a local machine into an internal stage. This is done via: Data Add Data Load Files into a Stage. Users can upload multiple files and choose the destination stage. This convenient UI eliminates the need for command-line tools such as SnowSQL. Snowsight supports both local file uploads and cloud storage references, not just cloud sources.=====================
How can users filter queries in the Query History view in Snowsight?
Answer(s): C
Snowsight's Query History view allows filtering queries bystatus,date range, andexecuting user. Additional filters include SQL text search, warehouse, duration, statement type, session ID, query ID, query tag, parameterized query hash, and whether a query was generated by a client or task. These filters help users identify long-running, failed, queued, or specific types of queries for troubleshooting and performance optimization. Network or hardware configurations have no role in Query History filtering.=====================
What are the steps to create a new stage in Snowsight?
To create a new stage in Snowsight, users navigate through:Data Database Schema Create Stage. Within the schema, selecting the "+" icon opens the option to create a stage. Users may configure internal or external stages, encryption settings, and directory table options. Other paths listed reference creating schemas rather than creating stages and are therefore incorrect.=====================
Which are the type of Views we have in Snowflake? (Choose any 3 options)
Answer(s): A,B,D
Snowflake supportsNon-Materialized Views(standard views),Materialized Views, andSecure Views. Non-materialized views compute results dynamically at query time. Materialized views store precomputed results, improving performance for repeated analytical queries. Secure views protect underlying query logic and metadata from being exposed, ensuring privacy when sharing datasets. The option "UnMaterialized" is not a Snowflake concept and does not exist as a view type.
What a Database in Snowflake cant contain?
A Snowflake database is a top-level container that can include schemas, and within those schemas it can contain objects such astables,views,stages,functions,procedures, anddatabase roles. However,global account-level roles(such as SYSADMIN, SECURITYADMIN, PUBLIC, or custom account roles) do not reside inside a database. These roles are created and managed at the Snowflake account level, not within any specific database. In contrast,database rolesare scoped within a specific database and can exist inside it. Views and tables are standard database objects. Therefore, the only option that a Snowflake database cannot contain is an account-levelRole.=====================
How do databases and schemas fit into Snowflake's hierarchy? (Choose any 2 options)
Answer(s): A,C
Snowflake's object hierarchy begins with theaccount, which contains one or moredatabases. Each database can contain multipleschemas, and each schema contains objects such astables,views,stages, and functions. The schema is a logical boundary for grouping related database objects. A schema cannot contain databases, and tables cannot contain schemas. Instead, tables and views are contained within schemas. Therefore, the two correct hierarchical relationships are that a database can contain multiple schemas, and a schema can contain multiple tables and views.=====================
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.