What actions can be performed by a consumer account on a shared database? (Select TWO)
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
Credit charges for Snowflake virtual warehouses are calculated based on the size of the virtual warehouse and the length of time the warehouse is running.The size determines the compute resources available, and charges are incurred for the time these resources are utilized
Which command will allow users to query data from files in cloud storage without ingesting the data?
An external table allows users to query files stored in external stages (e.g., S3, Azure Blob, GCS) without loading them into Snowflake tables. This enables cost-effective access to external datasets.
Snowflake Docs: External Tables
===========
Which JSON paths are considered to be equivalent in Snowflake? (Choose two.)
How does Snowflake describe its unique architecture?
Snowflake's unique architecture is described as a multi-cluster, shared data architecture that leverages massively parallel processing (MPP). This architecture separates compute and storage resources, enabling Snowflake to scale them independently. It does not use a single cluster or rely solely on symmetric multiprocessing (SMP); rather, it uses a combination of shared-nothing architecture for compute clusters (virtual warehouses) and a centralized storage layer for data, optimizing for both performance and scalability.
Snowflake Documentation: Snowflake Architecture Overview
Rebecca Moore
11 days agoHamza Hashmi
27 days agoAiko Do
1 month agoKhalid Nawaz
1 month agoManish Patel
2 months agoEmma Walker
2 months ago