A financial services company uses a transient table named `STG_CUSTOMER_PII` to temporarily process sensitive data. A junior administrator accidentally executes a `DROP TABLE` command on this table. The data retention period for the account is set to the default of 1 day. What is the most direct and appropriate method to recover this table and its data, assuming the drop occurred less than an hour ago?
A data engineering team is loading a large dataset composed of 10,000 small JSON files (each under 10MB) from an S3 bucket into a Snowflake table. The initial load process using a `COPY INTO` command is performing poorly. Which TWO actions are recommended best practices to improve the performance of this bulk loading operation? (Select TWO)
A data analyst needs to transform and flatten a deeply nested JSON structure stored in a VARIANT column named `RAW_PAYLOAD`. The structure contains an array of user objects, and each user object contains an array of address objects. The goal is to produce a flat table with one row per address for each user. Which combination of functions is required to achieve this multi-level flattening?
True or False: When a virtual warehouse is resized from a Small to a Large, any queries currently running on the warehouse are immediately migrated to the new, larger resources and will complete faster.
**Case Study:** A global e-commerce company, ShopSphere, is centralizing its analytics on Snowflake. They have three distinct user groups with different workload patterns. The Business Intelligence (BI) team runs complex, long-running analytical queries against large fact tables, primarily during business hours (9 AM - 5 PM). The Data Science (DS) team runs intensive machine learning training jobs using Snowpark, which are unpredictable in timing and duration. The Finance team runs lightweight, ad-hoc queries for daily reporting throughout the day. ShopSphere's primary goals are to ensure workload isolation to prevent query contention, maintain predictable performance for the BI team, and manage costs effectively. The current setup uses a single, large multi-cluster warehouse for all three teams, which has led to performance degradation for the BI team when DS jobs are running, and higher-than-expected costs due to the warehouse running constantly. The Director of Analytics has tasked you with redesigning the virtual warehouse strategy to meet the company's goals. Which of the following strategies provides the best combination of performance isolation, predictability, and cost-efficiency for ShopSphere?
A security administrator needs to configure a network policy that allows access from a specific range of corporate IP addresses but also permits the Snowflake Partner Connect services to access the account. Which statement accurately describes how to achieve this?
A data provider shares a secure view from their database with a data consumer. The consumer's query against the secure view is running much slower than expected. The provider confirms the underlying query for the view is highly optimized on their end. What is the most likely reason for the performance degradation on the consumer side?
A developer is using SnowSQL to load a local CSV file named `data.csv` into a user stage. Which command should be used for this purpose?
What is the primary function of the Cloud Services layer in the Snowflake architecture? ```mermaid graph TD subgraph Snowflake_Architecture A[Cloud Services Layer] --> B[Query Processing Layer] A --> C[Database Storage Layer] B --> C end subgraph A_Responsibilities direction LR A1[Authentication] --> A2[Access Control] A2 --> A3[Query Optimization] A3 --> A4[Metadata Management] end A --- A_Responsibilities ```
A data pipeline uses a stream object to capture changes on a source table. A downstream task consumes the data from the stream within an explicit transaction (`BEGIN`/`COMMIT`). If the task fails after consuming the stream data but before the transaction commits, what is the state of the stream?