Snowflake SnowPro Core — Practice

Questions in this quiz

1. 1. Snowflake separates which two concerns architecturally that are coupled in traditional MPP warehouses?
   1. Storage and metadata
   2. Storage and compute
   3. Compute and authentication
   4. Queries and roles
2. 2. What is a micro-partition in Snowflake?
   1. A 50–500 MB compressed columnar storage unit
   2. A logical SQL view
   3. A user-defined cluster key
   4. A backup snapshot
3. 3. Which feature lets you query data as it existed at a previous point in time?
   1. Fail-safe
   2. Time Travel
   3. Streams
   4. Cloning
4. 4. What does Snowflake 'zero-copy cloning' do?
   1. Physically copies data into a new database
   2. Creates a metadata-only clone that shares underlying storage until divergence
   3. Replicates data to another region
   4. Compresses data further
5. 5. Which object provides change tracking on a table for CDC patterns?
   1. A View
   2. A Stream
   3. A Task
   4. A Stage
6. 6. Which Snowflake object schedules SQL execution at intervals?
   1. A Pipe
   2. A Task
   3. A Sequence
   4. A Stream
7. 7. Which loading mechanism is best for continuous, near-real-time ingestion of files from a cloud stage?
   1. COPY INTO run manually
   2. Snowpipe
   3. INSERT statements
   4. External tables
8. 8. Which warehouse size doubles the cost per hour relative to X-Small?
   1. X-Small (1 credit/hr)
   2. Small (2 credits/hr)
   3. Large (8 credits/hr)
   4. Medium (4 credits/hr)
9. 9. Which role hierarchy concept allows a higher role to inherit privileges of lower roles?
   1. GRANT OWNERSHIP
   2. Role inheritance via GRANT ROLE
   3. Future grants
   4. Masking policies
10. 10. What happens to Time Travel data once the retention period expires?
    1. It is immediately deleted.
    2. It moves to Fail-safe for an additional 7 days (permanent tables) where only Snowflake support can recover it.
    3. It moves to cold storage indefinitely.
    4. It is exported to S3.
11. 11. Which feature dynamically masks sensitive column values based on the role of the querying user?
    1. Row Access Policies
    2. Dynamic Data Masking policies
    3. Secure Views
    4. External Tokenization (only)
12. 12. Which command suspends a virtual warehouse to stop credit consumption?
    1. ALTER WAREHOUSE ... SUSPEND
    2. DROP WAREHOUSE
    3. SHOW WAREHOUSES
    4. USE WAREHOUSE NONE