Snowflake AI Data Cloud Features and Architecture

A Snowflake administrator is organizing objects in a new account. They need to create a network policy that restricts login access, a database to hold analytics tables, and a resource monitor to cap warehouse credit usage. When deciding where each object lives in the Snowflake object hierarchy, which statement correctly classifies these objects?

A healthcare analytics company must comply with HIPAA regulations. They require that all data be encrypted using a customer-managed key combined with a Snowflake-managed key, and they need support for private connectivity to isolate traffic from the public internet. Which is the minimum Snowflake edition that satisfies these requirements?

A Snowflake administrator is reviewing which components handle various platform responsibilities. They need to identify which architectural layer is responsible for user authentication, access control (RBAC), query parsing and optimization, and transaction management. Which layer of the Snowflake architecture handles these responsibilities?

A data engineer runs an identical aggregation query twice within a few minutes. The underlying tables have not changed, and the second execution returns results almost instantly without consuming any virtual warehouse compute credits. Which layer of the Snowflake architecture is responsible for enabling this behavior?

A data engineer manages a 12 TB events table that is frequently queried with filters on an event_date column. Query performance has degraded over time because new data arrives continuously and rows for the same date end up scattered across many micro-partitions. The engineer wants Snowflake to automatically reorganize the table's data so that partitions are better co-located by event_date, improving pruning for date-range queries. Which action should the engineer take?

A data engineer loads several years of transaction data into a large Snowflake table using daily batch loads ordered by transaction_date. Analysts almost always filter queries by transaction_date ranges, and query pruning is already very effective. The engineer is deciding whether to define an explicit clustering key on transaction_date. What is the most appropriate recommendation?

A data engineering team runs heavy nightly ETL jobs that must never slow down the interactive dashboards used by business analysts during the day. Both workloads query the same production tables. A junior engineer suggests simply increasing the size of the single shared warehouse, but the lead engineer wants to guarantee that the two workloads never compete for compute resources while still reading the exact same underlying data. Which characteristic of the Snowflake architecture enables the recommended approach?

A business intelligence team wants to let non-technical analysts ask questions about sales data in plain English and receive accurate SQL-generated answers, without writing SQL themselves. The team wants to use a managed Snowflake capability that translates natural language questions into SQL against a defined semantic model. Which Snowflake feature should they use?

A data engineer at a legal firm needs to automatically generate concise summaries of thousands of lengthy contract documents already stored as text in a Snowflake table. They want to use a fully managed, serverless capability that requires no infrastructure setup and can be invoked directly within a SQL statement. Which Snowflake feature should they use?

A data scientist wants to build a semantic similarity feature entirely within Snowflake SQL. They need to convert a column of product description text into numerical vector representations so they can later compute cosine distance between products. They want to avoid deploying any external model infrastructure or writing Snowpark UDFs. Which Snowflake Cortex capability directly produces the vector representations from the text?

A data science team at an insurance company wants to adapt a base large language model so it produces claim-classification outputs that match their internal category labels and tone. They want to do this entirely within Snowflake without exporting data to an external service, using their own labeled training rows stored in a Snowflake table. Which Snowflake Cortex capability should they use?

A retail analytics team wants to analyze thousands of customer product reviews stored in a Snowflake table to determine whether each review expresses positive or negative feelings. They want to do this using SQL, without training or deploying their own model, and without provisioning any external infrastructure. Which Snowflake capability best meets this requirement?

A development team is building an internal support chatbot that must retrieve relevant passages from thousands of PDF knowledge-base documents already loaded into Snowflake, then feed those passages to an LLM to generate answers. They want a fully managed retrieval service that combines semantic (vector) and keyword search, handles embedding and indexing automatically, and keeps the index fresh as documents change. Which Snowflake Cortex feature should they use for the retrieval component?

A data engineer is explaining to a new team member how Snowflake physically stores loaded table data in the Database Storage layer. The team member asks in what form Snowflake actually keeps the data on the underlying cloud object storage. Which statement accurately describes how Snowflake stores this data?

A data engineer creates a table named ORDERS in the SALES schema of the ANALYTICS database. Later, another team creates a table also named ORDERS in the MARKETING schema of the same ANALYTICS database. When troubleshooting, the engineer asks whether these two tables conflict. Based on Snowflake's object hierarchy, which statement is correct?

A data engineering team on Snowflake Standard Edition wants to enable materialized views to speed up repeated aggregate queries on a large reporting table. Their manager asks what is the minimum Snowflake edition required to use materialized views, and how this compares to the team's current edition. Which statement is correct?

A data engineer needs to load files from an Amazon S3 bucket into Snowflake tables. She wants to create a reusable reference to the S3 location, along with the credentials and file format, so multiple loading jobs across different schemas can reference it. Within the Snowflake object hierarchy, which type of object should she create to point to the external S3 location?

A data engineer is organizing objects for a new project. She needs a location to temporarily hold raw CSV files uploaded from her laptop via the PUT command before loading them into tables. She wants this staging location to be reusable across multiple load jobs, governed by the same access privileges as the tables it feeds, and contained entirely within Snowflake without referencing external cloud storage. Which object should she create?

A data engineer is investigating why a query with a WHERE clause filtering on an ORDER_DATE column scans far fewer micro-partitions on one large table than on another table of similar size. The well-performing table's data was loaded in ORDER_DATE order, while the other table's rows were loaded in random order. What Snowflake storage mechanism explains the difference in the number of micro-partitions scanned?

A data engineering team runs a multi-cluster virtual warehouse (min 1, max 5 clusters) on Snowflake Enterprise Edition to handle unpredictable bursts of BI dashboard queries. Management complains that clusters sometimes spin up for very short traffic spikes, driving up credit consumption. They want Snowflake to be more conservative about starting additional clusters, favoring lower cost even if some queries wait slightly longer in the queue. Which configuration change should the team make?