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 of the following are valid Snowflake Virtual Warehouse sizes? (Choose any 3 options)
Snowflake warehouse sizes followT-shirt sizing, each representing a doubling of compute resources relative to the previous size. Valid Snowflake warehouse sizes includeX-Small,Small,Medium,Large, and up to6X-Large.
X-Smallis the smallest supported warehouse size and is commonly used for light data processing, development tasks, and low-volume operations.
Smalldoubles the compute capacity of X-Small, providing better performance for moderate workloads.
Mediumcontinues scaling upward, offering increased CPU, memory, and parallelism for heavier analytics or transformation workloads.
Tinyis not a Snowflake warehouse size. Snowflake never exposes a warehouse smaller than X-Small, ensuring consistent minimum compute capabilities.
These standardized size tiers allow predictable resource scaling and cost forecasting.
Which are the type of Views we have in Snowflake? (Choose any 3 options)
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 are the benefits of using the Snowsight data loading interface? (Select TWO).
Snowsight's file-loading interface:
*Automatically detects data typesby inspecting column values.
*Loads (inserts) file contents directly into a table, either a new table or an existing one.
Snowsight does not automatically create permanent file formats, does not merge rows, and does not optimize warehouse-level performance.
==================
What filter can be used when searching for data products on the Snowflake Marketplace?
On the Snowflake Marketplace, users can apply a Price filter when searching for data products. This filter helps distinguish between free offerings and paid listings, making it easier to align data acquisition with budget and commercial terms. Marketplace metadata includes pricing information that this filter uses to refine search results.
Dataset ''Size'' is not exposed as a primary Marketplace search filter. ''Compatibility'' is implied, as all Marketplace products are consumable within Snowflake. ''Performance'' is not a filterable attribute, because performance is influenced mainly by the consumer's compute configuration and query design, rather than a fixed property of the Marketplace listing.
==================
Sandra Sanchez
24 days agoFrank Collins
1 month agoRobert Cooper
2 months agoLaura Flores
2 months agoDorothy Stewart
3 months agoBetty Gonzalez
3 months agoAshley Lee
4 months agoNathan Morgan
4 months agoDorothy Hall
5 months agoDorothy Rogers
5 months agoPaul Young
6 months agoJames Cooper
5 months agoJessica Wilson
5 months agoRyan Cook
5 months agoWilliam Clark
6 months agoDaniel Allen
5 months agoIrene
6 months agoMarguerita
7 months agoMalika
7 months agoShawnda
7 months agoHuey
7 months agoJutta
8 months agoLisha
8 months agoAmira
8 months agoBrittni
8 months agoLilli
9 months agoSheron
9 months agoRoselle
9 months agoBrianne
9 months agoRebecka
10 months agoTanesha
10 months agoLatanya
10 months agoGoldie
10 months agoOren
11 months ago