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 SnowPro Associate Platform SOL-C01 exam with other users:
great help!!!
very useful tools
looks a good platform to prepare az-104
want to pass the exam
good resource
question 11 : d
only the free dumps will be enough for pass, or have to purchase the premium one. please suggest.
good questions. thanks.
good for practice.
great case study
the questions in this exam dumps is valid. i passed my test last monday. i only whish they had their pricing in inr instead of usd. but it is still worth it.
q40 the answer is not d, why are you giving incorrect answers? snapshot consolidation is used to merge the snapshot delta disk files to the vm base disk
thanks, very relevant
wrong answer. it is true not false.
please i need the mo-100 questions
very good use full
very valid questions
will these question help me to clear pl-300 exam?
please provide me with these dumps questions. thanks
in the pdf downloaded is write google cloud database engineer i think that it isnt the correct exam
i think you have the answers wrong regarding question: "what are three core principles of web content accessibility guidelines (wcag)? answer: robust, operable, understandable
these questions are not valid , they dont come for the exam now
question looks valid
good for practice
need more q&a to go ahead
question 59 - a newly-created role is not assigned to any user, nor granted to any other role. answer is b https://docs.snowflake.com/en/user-guide/security-access-control-overview
just passed my exam today. i saw all of these questions in my text today. so i can confirm this is a valid dump.
needed dumps
very helpful
will post once the exam is finished
relevant questions
just clear exam on 10/06/2202 dumps is valid all questions are came same in dumps only 2 new questions total 46 questions 1 case study with 5 question no lab/simulation in my exam please check the answers best of luck
q.112 - correct answer is c - the event registry is a module that provides event definitions. answer a - not correct as it is the definition of event log
good and useful.