Snowflake AI Data Cloud Features and Architecture

Which component of the Snowflake architecture is responsible for the permanent storage of data and is independent of compute resources?

Which Snowflake feature allows you to access data from a previous point in time to recover from accidental deletions or updates?

What happens when you modify data in a zero-copy cloned table?

A data architect needs to ensure that data in Snowflake is encrypted at rest and in transit. Which feature provides the highest level of security by allowing the customer to manage their own encryption keys?

A Snowflake administrator is configuring a new external stage to load data from an Amazon S3 bucket. The storage integration already exists and is named MY_S3_INT. The administrator needs to reference this integration when creating the stage. Which SQL statement correctly creates the stage with the necessary parameters?

A data engineer creates a materialized view on a large sales fact table to improve performance for a frequently run aggregation query. After a few days, users report that the materialized view sometimes returns stale data compared to the base table. The engineer verifies that the base table is being updated continuously via Snowpipe. What is the most likely explanation for the stale results?

A data architect is designing a multi-cluster warehouse to handle unpredictable peak concurrent user sessions. Which scaling property ensures that Snowflake automatically starts additional warehouse clusters to prevent query queuing while maintaining performance?

A user needs to query data stored in an external stage that points to an Amazon S3 bucket. The user has been granted the necessary privileges on the stage and the storage integration. Which of the following is required to successfully query the data directly from the stage using a SELECT statement?

A Snowflake administrator is configuring a new virtual warehouse for a team of data scientists who will run ad-hoc queries with varying concurrency. The administrator wants to ensure optimal performance and cost-efficiency. Which two configurations should the administrator consider? (Choose two.)

A data engineer runs a long-running aggregation query on a virtual warehouse. Mid-execution, the warehouse is resized from MEDIUM to LARGE. What happens to the query?

A Snowflake user needs to query data that is stored in an external table pointing to Parquet files in an external stage. The user wants to optimize query performance by reducing the amount of data scanned. Which feature should the user leverage?

A data engineer is loading a 5 TB compressed CSV file into a Snowflake table using the COPY INTO command. The file is stored in an external stage pointing to an Amazon S3 bucket. The engineer notices that the load is slower than expected and wants to improve performance. Which of the following actions is most likely to improve the load performance?

How does Snowflake's architecture provide the ability to run multiple concurrent workloads without resource contention?

What is the primary benefit of the Snowflake architecture's decoupling of storage and compute?

A company is migrating from an on-premises Hadoop cluster to Snowflake. They are concerned about how Snowflake manages the lifecycle of micro-partitions and whether they need to manually 'defragment' the storage over time. How does Snowflake address this?

When a query is submitted to Snowflake, which component is responsible for retrieving the metadata required to build the query execution plan?

A user runs a query that was executed by another user 10 minutes ago, and the underlying data has not changed. The query returns results instantly without using a virtual warehouse. Which Snowflake feature explains this behavior?

A data engineer loads a batch of records into a table and then runs a query that filters on a column with a high-cardinality value. The query profile shows partition pruning eliminated most micro-partitions, but the query still scans many rows within the surviving partitions. The table has never been clustered. Which characteristic of Snowflake micro-partitions best explains why pruning was effective at the partition level yet still left many rows to scan?

A company needs to ensure that data stored in a Snowflake table is encrypted at rest with keys that the company manages and rotates independently. Which Snowflake feature should be configured?

A company wants to share data with a partner without replicating the data. Which Snowflake feature is designed for this purpose?

A Snowflake administrator needs to ensure that a virtual warehouse automatically suspends after a period of inactivity to save costs. Which parameter should they configure?

How does Snowflake's architecture provide high availability and disaster recovery across different geographic locations?

How does Snowflake's architecture provide high availability for its internal metadata and security services?

What is the primary role of the Query Optimizer in Snowflake?

What is the primary benefit of Snowflake's 'Multi-Cluster Warehouse' feature when handling highly concurrent workloads?

Which component in the Snowflake architecture is responsible for managing the data storage lifecycle, including compaction and file management?

Refer to the exhibit. Which Snowflake security feature is represented by this JSON definition?

Which feature allows Snowflake to automatically utilize results from previous queries without consuming compute resources?

An organization wants to simplify its data pipeline by automatically updating target tables whenever new data arrives in the source tables, without manually managing tasks or streams. Which Snowflake feature is designed for this architectural pattern?

A Snowflake administrator needs to grant USAGE on a virtual warehouse named ANALYTICS_WH to a role named ANALYST_ROLE. Which SQL command accomplishes this?

A data architect is designing a multi-cluster warehouse to handle unpredictable bursts in query volume. Which architectural feature ensures that the warehouse automatically scales out to maintain performance without manual intervention?

A data engineer is loading streaming events through Snowpipe. The ingest rate spikes unpredictably, causing queued files to wait several minutes before loading, while the target table is queried heavily by BI users. The engineer wants Snowpipe processing to scale independently of the BI virtual warehouse so that neither workload interferes with the other. Which Snowflake feature should the engineer leverage to achieve this?

When sharing data via the Snowflake Marketplace, what architectural component ensures that the consumer sees the most up-to-date data without the provider having to re-send files?

A Snowflake administrator is configuring a new virtual warehouse for a data science team. The team requires the ability to run multiple concurrent queries without queuing, and they want to minimize credit consumption during idle periods. The administrator needs to configure the warehouse with appropriate settings. Which two actions should the administrator take? (Choose two.)

A data scientist wants to create a copy of a 100 TB production table to test a new transformation logic. How does Snowflake’s Zero-copy Cloning architecture handle this request?

What is the primary benefit of the Snowflake Query Result Cache compared to a standard warehouse cache?

A data engineer wants to ensure that data loaded into Snowflake is encrypted at rest and in transit. Which Snowflake architecture component handles the encryption and decryption processes automatically without requiring user-managed keys or manual intervention?

An administrator needs to implement a data governance strategy that includes tracking sensitive data and masking PII. Which TWO Snowflake features should be used to achieve this?

A data architect needs to ensure that a specific set of resource-intensive queries always have dedicated compute resources and do not compete with other workloads. Which Snowflake feature should be used?

A data analyst wants to explore semi-structured JSON data stored in a Snowflake table column. They need to extract specific fields and flatten nested arrays. Which Snowflake feature is best suited for this task?

What is the primary function of the Snowflake metadata store during the query optimization process?

Which TWO of the following statements accurately describe the function of the Snowflake Cloud Services layer?

A data architect is designing a solution that requires zero-copy cloning of a production database for testing purposes. The clone must be created quickly and should not duplicate storage until changes are made. Which Snowflake feature should they use?

What is the primary function of the Snowflake 'Result Cache'?

What happens to the performance of a warehouse when multiple users query the same data simultaneously?

Refer to the exhibit. This JSON policy is part of the setup for a Snowflake Storage Integration. What is the architectural purpose of the 'sts:ExternalId' condition in this cross-account IAM trust relationship?

Refer to the exhibit. What is the impact of changing the MAX_CONCURRENCY_LEVEL parameter on this warehouse?

A data engineer runs a query that joins a large fact table with a small dimension table. The query takes 12 minutes. The engineer notices that the small dimension table is broadcast to all compute nodes, and the fact table is redistributed across nodes. Which Snowflake feature is primarily responsible for this behavior, and what is its main benefit in this scenario?

Which feature of Snowflake allows for the rapid creation of a near-zero-copy clone of a database, schema, or table without consuming additional storage?

Which statement best describes the 'Snowflake Data Cloud' architecture's approach to scalability?

A Snowflake account has a virtual warehouse that is configured with AUTO_SUSPEND = 60 seconds and AUTO_RESUME = TRUE. A user runs a query that takes 5 minutes to complete. After the query finishes, the warehouse remains idle for 2 minutes and then suspends. During the idle period, what charges apply?

A Snowflake administrator configures a storage integration named EXT_S3_INT so that an external stage can read Parquet files from an Amazon S3 bucket. After creating the integration, the administrator runs DESCRIBE INTEGRATION EXT_S3_INT and copies the STORAGE_AWS_IAM_USER_ARN and STORAGE_AWS_EXTERNAL_ID values. What must the administrator do with these two values to allow Snowflake to access the bucket?

An administrator is configuring a virtual warehouse for a data science team that runs unpredictable, long-running training queries. The team wants the warehouse to shut down automatically when idle to save credits, but they also want queries to start immediately when a new request arrives without waiting for a manual resume. Which configuration should the administrator apply?

A Snowflake administrator is configuring a new virtual warehouse to support a data science team that runs occasional, complex queries on large datasets. The team requires fast performance and minimal latency. Which TWO warehouse configuration settings should the administrator consider to optimize performance for this workload? (Choose two.)

A Snowflake administrator needs to provide a data analyst with the ability to read data from a specific table but prevent the analyst from seeing any personally identifiable information (PII) columns. The administrator decides to use a masking policy. Which statement accurately describes the behavior of a masking policy in Snowflake?

A Snowflake user runs a SELECT statement against a large fact table. The query returns results in under a second, and the query profile shows that no warehouse was started. Which Snowflake feature most likely served the result?

Which Snowflake feature allows for the creation of a 'zero-copy' clone of a database or table?

What is the role of the 'Search Optimization Service' in Snowflake?

Which THREE of the following are benefits of Snowflake's micro-partitioning architecture?

Which TWO of the following statements accurately describe the functionality of Snowflake's separation of storage and compute architecture?

A Snowflake user executes a complex query that joins a large fact table with several dimension tables. The query takes longer than expected. The user notices that the query plan shows a significant amount of data being spilled to local disk. The warehouse size is currently MEDIUM. What is the most likely cause of the spillage, and what is the recommended action?

A data engineering team is loading a 500 GB CSV file into a Snowflake table using the COPY command. They notice that the load is taking longer than expected and the warehouse is showing high CPU utilization. Which of the following is the MOST likely cause for the slow performance?

A user runs a query that filters on a column with a very high cardinality, such as a timestamp with millisecond precision. The table is extremely large and is not clustered. What is the most likely impact on query performance?

A Snowflake user is designing a table to store semi-structured data from JSON logs. The user wants to query specific fields within the JSON efficiently and also retain the ability to query the entire JSON object. The user also wants to minimize storage costs. Which approach should the user take?

Refer to the exhibit. What is the primary advantage of using the VARIANT data type in this scenario?

A platform team is evaluating Snowflake's Time Travel feature for a production database. They need to understand which capabilities Time Travel provides for recovering from accidental data changes and for querying historical data. (Choose two.)

Which Snowflake architecture feature enables seamless data sharing between two different Snowflake accounts without the need to copy or move data?

Which Snowflake feature provides an 'always-on' mechanism to allow users to instantly query the state of data as it existed at any point in the past within a defined retention period?

Which TWO of the following tasks are performed by the Snowflake Cloud Services layer?

Refer to the exhibit. Given the state described in the JSON, what happens when a user executes the query?

Which component of the Snowflake architecture is responsible for managing data integrity, query optimization, and transaction management?

A company wants to monetize its data by making it available to other Snowflake customers through a centralized, public platform. Which Snowflake feature should they use?

Which component is responsible for orchestrating the lifecycle of a virtual warehouse, including start and stop operations?

Refer to the exhibit. Based on the query profile metadata provided, which Snowflake feature most likely contributed to the high efficiency of this query?

A Snowflake user needs to query data stored in an external cloud storage location (e.g., Amazon S3) without loading it into Snowflake tables. They want to minimize data movement and cost. Which Snowflake feature should they use?

Refer to the exhibit. Why were zero credits consumed for the query execution?

Refer to the exhibit. Based on the configuration provided for the ANALYTICS_WH, how will Snowflake manage clusters when multiple users start submitting queries at the same time?

What is the role of the Cloud Services layer within the Snowflake architecture when a user submits a query?