Which are the type of Views we have in Snowflake? (Choose any 3 options)
Suggested Answer: A, B, D
Get Premium SOL-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
18 comments · newest first
JU
Juan
2 days ago
I’m not sure about UnMaterialized. Is that even a thing?
JE
Jess
8 days ago
Non-Materialized is another one for sure.
TA
Tamra
13 days ago
Yeah, and Secure too!
HA
Hayley
18 days ago
I think Materialized is definitely one.
FE
Felicia
23 days ago
I’m surprised there’s no mention of UnMaterialized!
CU
Curt
28 days ago
Wait, are you sure about Secure?
WI
Willetta
1 month ago
Totally agree with the choices!
BR
Bronwyn
1 month ago
I thought there was an UnMaterialized option?
CA
Cassi
1 month ago
A) Materialized, B) Non-Materialized, D) Secure are the ones!
LE
Leontine
2 months ago
I always get confused with these options!
GR
Grover
2 months ago
Wait, are we sure about "Secure"?
AL
Alaine
2 months ago
Totally agree, those are the main types!
BE
Beata
2 months ago
I thought there was an "UnMaterialized" option?
NA
Natalya
2 months ago
A) Materialized, B) Non-Materialized, D) Secure are the ones!
HA
Harris
2 months ago
I definitely recall that materialized and secure views are types, but I can't remember if non-materialized is the right term or if it's something else.
RE
Ressie
3 months ago
I feel like "UnMaterialized" isn't a term we used in class, but I'm confused about the correct terminology.
KA
Karan
3 months ago
I remember practicing with a question that mentioned non-materialized views, so that might be one of the options.
KI
Kimbery
3 months ago
I think there are materialized views and secure views, but I'm not sure about the third one.