Snowflake Architecture

An architect is configuring a Snowflake account to support a workload that requires reading data from an external Apache Iceberg table stored in an external cloud storage location. The architect wants to ensure that queries against the Iceberg table can leverage Snowflake's compute and caching. Which Snowflake feature should the architect use?

An organization requires a storage solution for semi-structured data that must be accessible by multiple independent compute clusters without data duplication. Which Snowflake architectural component facilitates this requirement?

When creating a Zero-copy Clone of a production database to a development environment, which THREE statements accurately describe the behavior? (Choose THREE)

A company is using Search Optimization Service (SOS) to speed up point lookups. They notice that after adding SOS to a column, the storage costs have increased significantly. Which architectural factor most likely contributes to this cost increase?

An architect is designing a data pipeline that ingests JSON data into a Snowflake table with a VARIANT column. The pipeline uses Snowpipe for continuous ingestion. The architect notices that some JSON records contain nested arrays and occasionally exceed 16 MB in size. Which statement accurately describes a limitation or behavior the architect must consider?

A data architect is designing a multi-cluster warehouse strategy. They require the warehouse to automatically scale up if queueing persists while maintaining cost efficiency during periods of low activity. Which configuration best addresses these requirements?

A Snowflake architect is optimizing a virtual warehouse for a workload that consists of many small, concurrent queries with high concurrency requirements. The queries are simple and return small result sets. The architect wants to minimize queuing and ensure fast response times while controlling costs. Which warehouse configuration should the architect choose?

What is the primary benefit of using Snowflake's Result Cache for repeated queries?

An architect is evaluating Snowflake's Virtual Warehouse architecture for a new workload that requires continuous, high-concurrency query execution with minimal latency. The workload consists of many small, short-running queries issued by hundreds of users simultaneously. Which configuration should the architect recommend to best meet these requirements?

Refer to the exhibit. Based on the configuration provided, how will the multi-cluster warehouse behave when the query load increases?

Which statement accurately describes the characteristics of micro-partitions in Snowflake's architecture?

A Snowflake architect is designing a multi-cluster warehouse to handle varying concurrency demands for a BI dashboard that experiences peak usage during business hours. The architect wants to ensure that queries are not queued and that the warehouse scales out automatically. Which configuration should the architect use?

A Snowflake architect needs to design a solution for a global retail company that requires near real-time analytics on streaming point-of-sale data. The data arrives continuously via Snowpipe and must be immediately available for complex joins with historical sales data. The architect must minimize data latency and ensure that the compute resources for ingestion do not compete with those for analytical queries. Which Snowflake feature should the architect implement to meet these requirements?

Refer to the exhibit. A query profile shows that 'partitions_scanned' is 5,000 while 'partitions_total' is 5,000 for a specific TableScan operator. What architectural issue does this indicate, and what is the recommended solution?

How does the Snowflake Cloud Services layer facilitate zero-copy cloning?

A Snowflake architect is designing a multi-cluster warehouse for a workload that experiences unpredictable spikes in concurrency. The architect wants to ensure that queries are not queued unnecessarily while minimizing credit consumption during periods of low demand. The warehouse is configured with a minimum cluster count of 1 and a maximum of 5. Which scaling policy should the architect choose to best meet these goals?

Which feature of the Cloud Services layer specifically ensures that all transactions maintain ACID properties?

Which component of the Snowflake architecture is responsible for managing metadata, access control policies, and the global state of the database objects across all accounts?

A retail company uses Snowflake to analyze point-of-sale data. They notice that queries filtering on the 'transaction_date' column are slow because the table is not clustered on that column. The table is very large and experiences frequent inserts. Which Snowflake feature should the architect recommend to automatically maintain clustering on the 'transaction_date' column?

In Snowflake's architecture, what happens to the existing data in a table when a new Cluster Key is defined and the Automatic Clustering service is enabled?

An architect is designing a Snowflake environment for a global e-commerce platform. The platform needs to support read-heavy workloads from multiple regions with low latency. The data is stored in a single Snowflake account in the US West (Oregon) region. The architect wants to minimize data transfer costs and improve query performance for users in Europe and Asia. Which approach should the architect recommend?

A Data Provider wants to share data with a Consumer who does not have a Snowflake account. Which TWO architectural components are required to facilitate this type of sharing?

Which Snowflake architectural layer is responsible for the 'Time Travel' functionality?

An architect is configuring a Snowflake account to use Federated Authentication with Okta as the identity provider (IdP). The requirement is to allow users to authenticate to Snowflake using their Okta credentials and to automatically provision users and roles based on Okta group memberships. Which configuration steps must the architect perform to meet these requirements?

Which layer of the Snowflake architecture is responsible for ensuring ACID compliance and transactional integrity?

An architect is configuring a Snowflake account to use Federated Authentication with Okta. The requirement is that users must authenticate through Okta and receive Snowflake roles based on their Okta group membership. The architect has already configured the SAML integration. What additional step is required to map Okta groups to Snowflake roles?

Refer to the exhibit. Which architectural mechanism is responsible for the significant difference between 'partitions_total' and 'partitions_scanned'?

A Snowflake architect is evaluating the use of Search Optimization Service for a large table that is frequently queried with highly selective filters on a column with high cardinality, such as a UUID. The architect wants to understand the benefits and limitations of enabling Search Optimization Service on this column. Which two statements are true regarding Search Optimization Service? (Choose two.)

A large retail organization is experiencing slow performance on a specific set of complex queries that filter by a non-clustered high-cardinality timestamp column. Which architectural feature of Snowflake should the architect prioritize to optimize these specific lookups without manually rebuilding the entire table structure?

A Snowflake architect is explaining the layers of Snowflake's architecture to a new team. Which layer is responsible for managing metadata, optimizing queries, and providing transaction management?

What happens when a Virtual Warehouse is 'resized' to a larger size while queries are currently running on it?

What is the function of the 'Snowflake Data Storage' layer in the overall architecture?

A company wants to share a large dataset with a consumer who is in a different Snowflake region but on the same cloud provider. What is the most architecturally sound way to achieve this while ensuring the consumer has the most up-to-date data?

An architect is designing a staging area for a data pipeline where data will only be needed for 24 hours before being transformed and moved. Which TWO table types would be most cost-effective for this scenario? (Select TWO)

Which THREE of the following functions are primarily handled by the Snowflake Cloud Services layer? (Choose THREE)

Refer to the exhibit. A user runs a query that returns results in 0.2 seconds and shows 'Result Cache used' in the Query Profile. Where did Snowflake retrieve this data from?

An architect is designing a multi-cluster warehouse for a retail analytics workload that experiences unpredictable spikes in concurrency. The warehouse is configured with a minimum of 2 clusters and a maximum of 10 clusters, scaling policy set to Economy. During a sudden spike, queries are queuing despite the warehouse scaling out to 6 clusters. What is the most likely cause of the queuing?

An architect is designing a secure data sharing strategy using Snowflake's Data Sharing feature. The goal is to share a subset of data with a partner account while ensuring that the partner cannot access underlying micro-partitions directly and that the shared data is always up-to-date. Which two statements are true regarding Snowflake Data Sharing? (Choose two.)

A financial services company runs a Snowflake account in the AWS us-east-1 region. The security team mandates that all data at rest must be encrypted with customer-managed keys, and they require an audit trail of key usage. Which Snowflake feature should the architect implement to meet these requirements with minimal administrative overhead?

A query that usually takes 10 seconds is now taking 5 minutes. The Query Profile shows that 'Local Disk Spilling' is high. What does this indicate about the warehouse and the query?

Refer to the exhibit. An architect is configuring a Snowflake Storage Integration to access an external S3 bucket. Based on the IAM policy shown, what will happen if a Snowflake user attempts to create an External Stage pointing to 's3://production-data/raw/'?

A healthcare organization needs to share patient data with external research partners without copying the data. The partners use their own Snowflake accounts and require read-only access to a specific subset of tables. Which Snowflake feature should the architect use to meet these requirements?

An architect is designing a Snowflake environment for a financial services company that requires the highest level of security. The company must ensure that data is encrypted at rest and in transit, and that encryption keys are managed by the customer, not Snowflake. Which Snowflake feature should the architect implement?

A database architect needs to design a high-churn table that receives millions of updates daily. To minimize storage costs associated with Fail-safe and Time Travel while maintaining some recovery capability, which table type and configuration should be used?

A Snowflake architect is designing a solution where multiple independent compute clusters (virtual warehouses) must access the same underlying data without needing to copy it, and each workload must be isolated to avoid resource contention. Which Snowflake architecture feature directly enables this?

A large-scale data ingestion pipeline is experiencing intermittent queuing. Which architectural element should be analyzed to identify the source of the contention?

An e-commerce company uses Snowflake to analyze clickstream data. They want to optimize query performance for a large fact table that is frequently filtered by 'event_date' and 'user_id'. The table is growing rapidly, and queries often scan many micro-partitions. Which architectural feature should the architect recommend to improve pruning?

What is the primary architectural advantage of using External Tables with the 'REFRESH' property instead of traditional data loading via COPY INTO?

A Business Critical edition customer wants to implement a disaster recovery strategy that ensures their Snowflake account can failover to a different region with a Recovery Time Objective (RTO) of less than 1 hour. Which architectural feature is required?

Which architectural component is responsible for managing the ACID properties across distributed compute nodes during a complex DML operation?

A query is performing poorly due to 'Remote Disk I/O'. The architect notices that the query profile shows a large number of micro-partitions being scanned. The table is already clustered on the filter column. What is the most likely cause of the high Remote Disk I/O?

When a query is executed, which layer is responsible for the 'Query Plan' generation?

A global e-commerce company stores order events in a Snowflake table that ingests roughly 40 million rows per day. Analysts report that point-lookup queries filtering on ORDER_ID are fast, but range queries that filter on ORDER_DATE and aggregate by REGION scan almost every partition and take several minutes. The architect must reduce bytes scanned for the date-range workload while minimizing rebuild cost, and the table already has a natural daily ingestion cadence. Which action best satisfies the requirement?

A data architect is designing a multi-cluster warehouse for a retail company's peak sales periods. The warehouse must automatically add clusters when queries are queued and shut them down when demand drops. The company wants to minimize credit consumption while maintaining query performance. Which configuration should the architect implement?

An architect is explaining Snowflake's architecture to a team new to the platform. The team wants to understand which component is responsible for storing metadata about tables, columns, and micro-partitions to enable efficient query pruning. Which Snowflake layer provides this functionality?

Why does Snowflake's architecture separate compute from storage?

A financial services company uses Snowflake to store sensitive customer data. They need to ensure that data is encrypted at rest and in transit, and that encryption keys are managed by the cloud provider's hardware security modules (HSMs). The company also requires that Snowflake support periodic key rotation. Which Snowflake feature should the architect recommend to meet these requirements?

A security architect is reviewing the network architecture. Why is the 'Private Link' (or Private Connectivity) feature considered an architectural enhancement for high-security environments?

An architect is configuring a Snowflake account to allow users to authenticate via an external OAuth 2.0 identity provider. The security team requires that the OAuth token includes specific custom claims that map to Snowflake roles. Which Snowflake feature should the architect use to enforce role mapping based on these claims?

Refer to the exhibit. An architect needs to optimize this warehouse to handle a batch process that performs a massive table scan followed by a complex join on 10 billion rows. What is the most effective architectural change?

Which feature of Snowflake's architecture allows for the scaling of resources to handle high-concurrency BI dashboard requests without affecting the performance of heavy ETL workloads?

What is the primary benefit of the decoupled storage and compute architecture regarding elastic scaling?

An enterprise is designing a multi-tenant SaaS application on Snowflake. Each customer tenant must have completely isolated data storage while allowing the software vendor to query aggregated metrics globally across all tenants without copying data. Which architectural design pattern best satisfies this requirement?

Which architectural feature ensures that DML operations in Snowflake do not impact query performance and provide data consistency without the need for manual locking?

A Snowflake architect is configuring a secure data sharing setup between a provider account and a consumer account in a different region. The provider wants to share a database that contains sensitive financial data. The architect must ensure that the data is encrypted in transit and at rest, and that the consumer cannot download the shared data. Which Snowflake feature should the architect use to meet these requirements?

Which of the following describes the 'Multi-cluster' feature of Snowflake Virtual Warehouses?