COF-C03 Snowflake AI Data Cloud Features and Architecture — All Questions With Answers

SHOW WAREHOUSES LIKE 'PROD_WH';

NAME | SIZE | MIN_CLUSTER_COUNT | MAX_CLUSTER_COUNT | SCALING_POLICY
PROD_WH | X-LARGE | 1 | 5 | ECONOMY

{
  "statement": "SELECT * FROM sales WHERE region = 'EMEA';",
  "warehouse": "WH_XS",
  "status": "SUCCESS",
  "cached_result": "TRUE",
  "credits_used": 0.0
}

ALTER WAREHOUSE WH_PROD SET MAX_CONCURRENCY_LEVEL = 16;

ALTER WAREHOUSE ANALYTICS_WH SET 
  MAX_CLUSTER_COUNT = 4, 
  MIN_CLUSTER_COUNT = 1, 
  SCALING_POLICY = 'ECONOMY', 
  AUTO_SUSPEND = 60;

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Principal": { "AWS": "arn:aws:iam::123456789:role/snowflake_role" },
      "Action": "sts:AssumeRole",
      "Condition": { "StringEquals": { "sts:ExternalId": "MY_ACCOUNT_SFID_123" } }
    }
  ]
}

{
  "statement": "SELECT * FROM sales;",
  "warehouse_state": "SUSPENDED",
  "result_cache": "AVAILABLE"
}

SELECT * FROM sales_data WHERE order_date = '2023-01-01';

-- Query Profile Metadata:
-- Scanned: 10GB
-- Partitions Scanned: 100
-- Partitions Total: 10,000

CREATE TABLE sales_events (
  event_id INT,
  event_data VARIANT
);

-- Query:
SELECT event_data:user_id::STRING FROM sales_events;

{
  "POLICY_NAME": "MASK_PII",
  "COLUMN_TYPE": "STRING",
  "MASKING_EXPRESSION": "CASE WHEN CURRENT_ROLE() IN ('ADMIN') THEN val ELSE '***' END"
}