Securing the SnowPro Core Certification is the ultimate way to prove you can navigate the complexities of the Snowflake AI Data Cloud. I developed this comprehensive resource because I know that reading documentation is only half the battle—the real challenge lies in applying that knowledge to complex, scenario-based questions. With 1,500 original practice questions, I am here to help you bridge the gap between "knowing the platform" and "passing the exam on your first attempt."

Every single question includes a deep-dive explanation of all options. I don't just provide the right answer; I explain the technical "why" behind it, ensuring you understand how Snowflake's unique architecture handles storage and compute independently. Whether you are tackling virtual warehouse scaling or mastering secure data sharing, these tests provide the rigorous environment you need to build confidence.

Practice Question Previews

Question 1: Multi-Cluster Warehouse Scaling A company is using a Multi-cluster warehouse in 'Auto-scale' mode with the 'Standard' scaling policy. What is the primary trigger for Snowflake to start an additional cluster?

• Options:

  • A) When the CPU utilization of the current cluster reaches 80%.

  • 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:

  • A) Incorrect: Snowflake scaling is based on query queuing and concurrency, not direct CPU percentages.

  • 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.

Question 2: Data Protection and Time Travel You have a permanent table in Snowflake with a retention period of 90 days. You accidentally drop the table. Which command should you use to recover it within the Time Travel window?

• Options:

  • A) RESTORE TABLE table_name;

  • 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:

  • A) Incorrect: RESTORE is not a valid Snowflake command for table recovery.

  • 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.

Question 3: Semi-Structured Data Handling When querying a JSON file stored in a VARIANT column named src, what is the correct syntax to access a nested key called customer_id?

• Options:

  • A) SELECT src.customer_id FROM table;

  • 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:

  • A) Incorrect: Dot notation works but typically requires additional casting to be fully functional.

  • 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 Exams Practice Tests Academy to help you prepare for your SnowPro Core Certification.

  • You can retake the exams as many times as you want.

  • 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.

I hope that by now you're convinced! There is a massive amount of knowledge packed into these questions. I'll see you inside.