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:
hi, could you please update the latest dump version
this question is keep repeat : you are developing a sales application that will contain several azure cloud services and handle different components of a transaction. different cloud services will process customer orders, billing, payment, inventory, and shipping. you need to recommend a solution to enable the cloud services to asynchronously communicate transaction information by using xml messages. what should you include in the recommendation?
great questions
its realy good
oracle 1z0-1059-22 dumps
please share me the pdf..
q50: which two functions can be used by an end user when pivoting an interactive report? the correct answer is a, c because we do not have rank in the function pivoting you can check in the apex app
best to practice
so far it is good
please provide me the dump
i failed the cisa exam today. but i have found all the questions that were on the exam to be on this site.
in question 272 the right answer states that an autonomous acces point is "configured and managed by the wlc" but this is not what i have learned in my ccna course. is this a mistake? i understand that lightweight aps are managed by wlc while autonomous work as standalones on the wlan.
it was helpful
good question
really nice
please i need dumps for isc2 cybersecuity
ans is coldline i think
very helpful
can you please provide dumps so that it helps me more
thank you for providing me with the updated question and answers. this version has all the questions from the exam. i just saw them in my exam this morning. i passed my exam today.
how i can see exam questions?
can you please upload please?
question 75: option c is correct answer
please add this exam
please upoad
has anyone recently attended safe 6.0 certification? is it the samq question from here.
expository experience
52 should be b&c. controller failure has nothing to do with this type of issue. degraded state tells us its a raid issue, and if the os is missing then the bootable device isnt found. the only other consideration could be data loss but thats somewhat broad whereas b&c show understanding of the specific issues the question is asking about.
great help!!!
very useful tools
looks a good platform to prepare az-104
want to pass the exam
good resource
question 11 : d