What is a key capability of the Snowflake virtual warehouse?
Answer(s): B
A virtual warehouse provides compute resources in Snowflake and can be resized (scaled up or down) at any time. Scaling up increases compute power for intensive workloads, while scaling down reduces cost for lighter workloads.Virtual warehouses do not store data--that is handled by Snowflake's independent storage layer. They are not on-premises and do not provide unlimited concurrency; Snowflake supports high concurrency using multi-cluster warehouses but not boundless concurrency.
What is the name for a Snowflake account holder who shares data with other Snowflake accounts?
Answer(s): A
In Snowflake's Secure Data Sharing model, the accountsharingdata is known as thedata provider. Providers create shares that include selected objects (tables, views, secure views, etc.) and grant access to consumer accounts.Adata consumerreceives the shared data.Data readeranddata administratorare not defined terms in Snowflake's sharing architecture.
What are the key benefits of using Snowflake? (Select TWO).
Answer(s): A,D
Snowflake's multi-cluster shared data architecture enablesindependent scaling of compute and storage, meaning workloads can be sized differently without affecting stored data.It also providesnear-unlimited concurrency, because Snowflake can automatically add compute clusters during peak loads.Snowflake does not require manual infrastructure management and runs fully in the cloud--not on- premises. Multi-cloud support reduces vendor lock-in, not increases it.
What is a benefit of using an external stage to load data into Snowflake?
External stages point to files in external cloud storage (S3, Azure Blob, GCS). Because the data is not stored inside Snowflake, the user avoids Snowflake storage charges, which can significantly reduce cost for large staging datasets.External stages do not automatically delete files, are not inherently more secure than internal stages, and still count as database objects even though they reference external storage.
What is the LIST command used for in Snowflake?
TheLISTcommand displays all files available in a stage--internal, external, user, or table stages.It is typically used prior to COPY INTO to confirm which files are available for loading.SHOW TABLES lists tables; SHOW GRANTS shows privileges; GRANTS queries show user-role assignments--not LIST.
What is the SHOW FILE FORMATS SQL command used for in Snowflake?
Answer(s): C
SHOW FILE FORMATS listsfile format objectsthat exist in the currently selected schema (or optionally, a specific database or schema). These objects define how Snowflake interprets staged files during data loading.It doesnotlist supported built-in formats (CSV, Parquet, etc.).It doesnotshow example usage information and doesnotlist files--LIST @stage handles that.
What Snowflake object is used to organize database objects into logical groupings?
Schemas serve as logical containers within a database, grouping tables, views, file formats, functions, and other objects.Roles control access, not organization.Tables store data but do not group objects.Stages store files or point to external storage; they are not organizational containers.
What are the benefits of using the Snowsight data loading interface? (Select TWO).
Answer(s): B,C
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.
Share your comments for Snowflake SOL-C01 exam with other users:
planning to take psm test
please allow to download
please provide dumps
is the answer to question 15 correct ? i feel like the answer should be b
its getting more technical
i think these questions are what i need.
helpful assessment
i am confused about the answers to the questions. do you know if the answers are correct?
hi, please make the dumps available for my upcoming examination.
good practice
so far it is really informative
hi i want it please please upload it
am preparing for exam ,just nice questions
please upload c_tadm_23 exam
can we get tdvan4 vantage data engineering pdf?
want to clear the exam.
could you please upload the dumps of sap c_sac_2302
asm management configuration is about storage
kool thumb up
just passed the az-500 exam this last friday. most of the questions in this exam dumps are in the exam. i bought the full version and noticed some of the questions which were answered wrong in the free version are all corrected in the full version. this site is good but i wish the had it in an interactive version like a test engine simulator.
i can practice for exam
please i need this exam.
i need the dump
i want it bad, even if cs6 maybe retired, i want to learn cs6
i hate comptia with all my heart with their "choose the best" answer format as an argument could be made on every question. they say "the "comptia way", lmao no this right here boys is the comptia way 100%. take it from someone whos failed this exam twice but can configure an entire complex network that these are the questions that are on the test 100% no questions asked. the pbqs are dead on! nice work
very good materials
thanks for your support.
iam impressed with the quality of these dumps. they questions and answers were easy to understand and the xengine app was very helpful to use.
not bad but you question database from isaca
awesome contents
answer to 134 is casb. while data loss prevention is the goal, in order to implement dlp in cloud applications you need to deploy a casb.
are these brain dumps sufficient enough to go write exam after practicing them? or does one need more material this wont be enough?
i did attend the required cources and i need to be sure that i am ready to take the exam, i would ask you please to share the questions, to be sure that i am fit to proceed with taking the exam.
why only give explanations on some, and not all questions and their respective answers?