Snowflake Snow Pro Certification Study Guide |Questions & Expertly Verified Answers, 2025 | 2026.

Snowflake Snow Pro Certification Study Guide |Questions & Expertly Verified Answers, 2025 | 2026. Quiz_________________? A cloned database or schema's child objects retain privileges of the source objects (T/F) - Answers True Quiz_________________? A cloned object retains all granted privileges of the source object (T/F) - Answers False - It doesn't retain any granted privileges Quiz_________________? A customer needs to have a preexisting account with AWS or Azure in order to have a Snowflake account (T/F) - Answers False Quiz_________________? A share can only contain one database (T/F) - Answers False - A share can contain several databases, as long as they are in the same Snowflake account Quiz_________________? A user can't be assigned multiple roles (T/F) - Answers False - A user can be assigned multiple roles Quiz_________________? All cache data are cleared if the underlying data changes (T/F) - Answers True Quiz_________________? Are Snowflake's Storage (DB) and Compute (WH) layers A) Separate and Independent B) Together and Dependent - Answers A) Separate and Independent Quiz_________________? Auto-Suspension limits has to be determined when the Virtual Warehouse is configured (T/F) - Answers False - it can be changed after initial configuration Quiz_________________? Can a cached query be run without a Virtual Warehouse running? - Answers Yes - No compute is used in a query that's cached in the results cache Quiz_________________? Can ACCOUNTADMINS view results of other users queries? - Answers No, they can only see the queries they ran Quiz_________________? Can Snowpipes be configured to not automatically ingest data? - Answers Yes, the auto_ingest parameter must be set to TRUE for data to automatically ingest Quiz_________________? Can Transient tables be cloned? - Answers Yes Quiz_________________? Can Virtual Warehouses be cloned? - Answers No, they can't Quiz_________________? Can you cluster on the combination of multiple columns? - Answers Yes - CLUSTER BY (column1, column2) Quiz_________________? Can you replicate data to other users who are on a different provider or region than you (AWS, Azure, GCP)? - Answers Yes Quiz_________________? Can you specify time travel requirements when cloning? - Answers Yes, this is done by suing the AT and BEFORE commands Quiz_________________? Clustering Keys improve performance on all queries that filter or sort on that column (T/F) - Answers True - This includes some joins Quiz_________________? Compute can't scale out as queries are running (T/F) - Answers False Quiz_________________? Data doesn't have to be staged prior to being loaded (T/F) - Answers False - Data must be staged prior to loading Quiz_________________? Data partitioning is automatically completed in the natural ingestion order (T/F) - Answers True