Snowflake SOL-C01 - SnowPro Associate: Platform Certification Exam
What is the Snowsight object browser used for?
To manage virtual warehouses
To create Snowsight worksheets
To modify security settings for objects
To view and filter database objects
The Answer Is:
DExplanation:
The Snowsight object browser is Snowflake’s built-in visual interface for exploring and navigating all database objects within an account. It provides a hierarchical view across databases, schemas, and contained objects such as tables, views, stages, pipes, file formats, procedures, and functions. The key purpose of the object browser is to make it easy for users to view and filter database objects without needing SQL commands. Users can search objects by name, apply filters, preview table metadata, and inspect properties such as storage usage or row counts.
The object browser does not manage warehouses; warehouse management is done under the “Warehouses†section. It also does not create worksheets; worksheets are created in the “Worksheets†section. Additionally, the object browser does not modify security settings—permissions and grants are controlled through SQL (GRANT, REVOKE, SHOW GRANTS) or through the Access Control interfaces.
In summary, the object browser is a discovery and navigation layer, allowing users to efficiently find, inspect, and explore Snowflake objects.
==================
What is the primary purpose of the COPY INTO command in Snowflake for data loading?
To replicate databases across regions.
To create new virtual warehouses.
To load data from staged files into a table.
To manage user roles and permissions.
The Answer Is:
CExplanation:
COPY INTO
