1500 Questions | SnowPro Core Certification 2026

B) When the warehouse has more queries than it can handle immediately.

C) When the storage layer latency exceeds 10ms.

D) When a user with the ACCOUNTADMIN role manually approves the scale-out.

E) When the result set of a single query exceeds 1GB.

F) At a pre-scheduled time defined in the Resource Monitor.

Correct Answer: B

Explanation:

B) Correct: In 'Standard' mode, Snowflake starts a new cluster as soon as a query is queued because the current cluster is busy.

C) Incorrect: Storage latency is managed by the storage layer and does not trigger compute scaling.

D) Incorrect: Auto-scaling is an automated process based on workload, not manual approval.

E) Incorrect: Query result size affects local disk/memory but doesn't trigger a new cluster start.

F) Incorrect: Scaling in 'Auto-scale' is dynamic; scheduled scaling is not a native 'Auto-scale' trigger.

B) RECOVER TABLE table_name;

C) UNDROP TABLE table_name;

D) SELECT * FROM table_name BEFORE (TIMESTAMP => ...);

E) CLONE TABLE table_name TO table_name_recovered;

F) ROLLBACK TABLE table_name;

Correct Answer: C

Explanation:

B) Incorrect: RECOVER is not the correct syntax in Snowflake.

C) Correct: The UNDROP command specifically restores the most recent version of a dropped table within the retention period.

D) Incorrect: While you can query data using Time Travel syntax, it doesn't "undrop" the table structure itself.

E) Incorrect: You cannot clone a table that has already been dropped.

F) Incorrect: ROLLBACK is used for transactions, not for recovering dropped objects.

B) SELECT src['customer_id'] FROM table;

C) SELECT src:customer_id FROM table;

D) SELECT GET(src, 'customer_id') FROM table;

E) SELECT src->customer_id FROM table;

F) SELECT src.value:customer_id FROM table;

Correct Answer: C

Explanation:

B) Incorrect: Square bracket notation is generally used for array indexes, not key-value pairs in JSON.

C) Correct: The colon (:) is the standard Snowflake operator for traversing paths in VARIANT data.

D) Incorrect: While GET() is a function, the colon syntax is the most direct and common method.

E) Incorrect: The arrow operator (->) is common in other databases but not used in Snowflake.

F) Incorrect: src.value is only used when flattening a JSON array with the FLATTEN function.

Welcome to the free gcp professional data engineer mock exams practice tests course Academy to help you prepare for your SnowPro free comptia a core 1 certification 220 1201 practice tests 2026 course.

This is a huge original question bank with 1,500 unique entries.

You get support from instructors if you have questions.

Each question has a detailed explanation for every option.

Mobile-compatible with the Udemy app for studying anywhere.

30-days money-back guarantee if you're not satisfied.