SnowPro Core Exam Discussions & Posts
gm
Commented on July 25, 2025
Question 59 - False. In Snowflake, when a role is created, the role that is active at the time of creation is assigned ownership, not the individual user. This ownership can be transferred to another role using the GRANT OWNERSHIP command.
SINGAPORE
gm
Commented on July 25, 2025
Question 48 -
? They roll up and release approximately monthly, but customers can request early release application.
- While behavior changes are bundled monthly, releases themselves are weekly. Early access is available for Enterprise Edition and higher, but this applies to weekly releases, not monthly rollups.
? A customer is assigned a 30-minute window during which the system will be unavailable and upgraded.
- Snowflake upgrades are seamless and do not involve downtime. Customers are not assigned maintenance windows.
SINGAPORE
gm
Commented on July 25, 2025
Question 42 - Explaining why not others
? Snowflake tables are the physical instantiation of data: This is misleading because Snowflake abstracts physical storage from users.
? Clustering keys are required for optimal performance: Clustering keys are optional and used for very large tables to improve query performance, but not required.
? Snowflake tables are owned by a user: Tables are owned by roles, not individual users, as part of Snowflake's role-based access control (RBAC) model.
SINGAPORE
gm
Commented on July 25, 2025
Question 37: Explaination -
Here are the three correct statements about Snowflake data loading:
? VARIANT "null" values are not the same as SQL NULL values
In Snowflake, the string "null" stored in a VARIANT column is treated as a string, not as a SQL NULL. This distinction is important when querying or transforming semi-structured data like JSON.
? It is recommended to validate the data before loading into the Snowflake target table
Validating data helps ensure integrity, prevents errors during loading, and avoids polluting production tables with bad or malformed data.
? It is recommended to use staging tables to manage MERGE statements
Staging tables allow for cleaner, more controlled data transformations and help manage complex MERGE operations efficiently.
? It is recommended to do frequent, single row DMLs
This is not recommended. Snowflake is optimized for bulk operations. Frequent single-row DMLs (INSERT, UPDATE, DELETE) can be inefficient and costly.
SINGAPORE
gm
Commented on July 25, 2025
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
Answer should be False because Snowflake provides standard JDBC and ODBC drivers that allow connections from tools supporting these standards
SINGAPORE
gm
Commented on July 25, 2025
Helpful questions
SINGAPORE
cc
Commented on July 25, 2025
nice questions
JAPAN
cuuns
Commented on July 25, 2025
good questioins
JAPAN
harry
Commented on July 25, 2025
great content
JAPAN
AL
Commented on July 25, 2025
Good content
SPAIN
RT
Commented on July 22, 2025
Nice content
Anonymous
RT
Commented on July 22, 2025
Nice preparatory content
Anonymous
Himanshu Verma
Commented on July 21, 2025
Q283: Option B and D are correct
Anonymous
ahsan
Commented on July 21, 2025
good content
UNITED STATES
Hari
Commented on July 20, 2025
Q2: Economy and Standard
UNITED STATES
Himanshu Verma
Commented on July 20, 2025
Q262 : Correct option B, doc - https://docs.snowflake.com/en/user-guide/classify-intro
INDIA
Himanshu Verma
Commented on July 20, 2025
Q 235: SCIM is available for Business Critical Edition or above.
INDIA
Himanshu Verma
Commented on July 19, 2025
Question 190: Options A and D are correct
INDIA
Himanshu Verma
Commented on July 19, 2025
Question 182: There is an error in option C. I guess copy and pasting gone wrong :)
Anonymous
Himanshu Verma
Commented on July 19, 2025
Question 154: Correct option is B and C.
Anonymous
Himanshu Verma
Commented on July 13, 2025
Question 146: Option C and E are correct
INDIA
Ajay
Commented on July 13, 2025
seems Answer is not correct for QUESTION: 59 ( Answer should be TRUE)
QUESTION: 59
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
UNITED STATES
Ajay
Commented on July 13, 2025
QUESTION: 33
True or False: Snowpipe via REST API can only reference External Stages as source
Reference URL is not for REST API.
https://community.snowflake.com/s/article/Making-Transient-table-by-Default
UNITED STATES
Ajay
Commented on July 13, 2025
Some of Answer is not correct. Question 26 .. All options are correct but is showing only A,B
QUESTION: 26
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
AUTO_SUSPEND = { num | NULL }
Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
AUTO_RESUME = { TRUE | FALSE }
Specifies whether to automatically resume a warehouse when a SQL statement (for example, query) is submitted to i
Customers can change the size of the Warehouse after creation
A Warehouse can be resized while running
A Warehouse can be configured to suspend after a period of inactivity
A Warehouse can be configured to auto-resume when new queries are submitted
UNITED STATES
Ajay
Commented on July 13, 2025
some of Reference document is no more available for given URL.
UNITED STATES
Satyam
Commented on July 13, 2025
Good set of questions
INDIA
Sid
Commented on July 13, 2025
Prepping for certification
UNITED STATES
Himanshu Verma
Commented on July 12, 2025
Question 123: Correct option is False. Reader accounts cannot extract data for use outside of Snowflake
INDIA
Himanshu Verma
Commented on July 12, 2025
Question 77: All Options are correct
INDIA
Saurav Gupta
Commented on July 04, 2025
I am looking to appear for the Snowpro Core certification exam.
AUSTRIA
Volodymyr
Commented on July 03, 2025
Useful information to prepare the exam
Anonymous
Jack
Commented on July 01, 2025
good questions based on the content
NETHERLANDS
Ashish Ranjan
Commented on June 26, 2025
Correct answer for below is question is all 4 given options:
Qs. 26 - Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
INDIA
Himanshu Verma
Commented on June 22, 2025
Question 30: Answer is all of the above. Option D is correct
INDIA
Himanshu Verma
Commented on June 22, 2025
Question 26: All options are correct, not just A and B. It is mentioned in the documentation as well.
INDIA
Raunak Kabiraj
Commented on June 09, 2025
Snowflake does not charge a premium for storing semi-structured data (such as JSON, Avro, Parquet, or XML). Semi-structured data is stored in the same way as structured data, and storage costs are based solely on the amount of data stored, regardless of its structure. There are no additional or premium charges specifically for storing semi-structured data in Snowflake.
Anonymous
Raunak Kabiraj
Commented on June 09, 2025
Credit consumption by the compute layer (virtual warehouses) is based on:
Warehouse size
Amount of data processed
Explanation:
Warehouse Size: Snowflake warehouses are sized using a "T-shirt" sizing system (X-Small, Small, Medium, Large, etc.). Larger warehouse sizes consume more credits per second of usage.
Amount of Data Processed: The complexity and volume of the queries you run on the warehouse directly impact the amount of compute resources used, and therefore, the credit consumption. More complex queries and larger datasets will consume more credits.
Why the other options are not direct factors:
Number of users: The number of users connected to a warehouse doesn't directly impact credit consumption. However, more users running queries will indirectly increase the amount of data processed and, therefore, credit consumption.
Number of clusters for the Warehouse: While multi-cluster warehouses can scale out to handle concurrency, the number of clusters itself doesn't directly d
Anonymous
Alok Awasthi
Commented on June 08, 2025
QUESTION: 173 Answer should be B not D.
The best way to resolve this issue is to split the file into multiple files in the recommended size range (100 MB - 250 MB).
Snowflake enforces a LOB (Large Object) size limit of 16 MB, meaning that if a single JSON document exceeds this limit, the load will fail. Splitting the JSON file into smaller chunks ensures that individual records remain within the acceptable size range, preventing errors during ingestion.
Anonymous
Madhu
Commented on June 05, 2025
Its good practice material to go through
Anonymous
dvnrao
Commented on June 03, 2025
preparing for exam is different and working in snowflake is different it like theory vs practical
Anonymous
dvnrao
Commented on June 02, 2025
preparing for exam
Anonymous
Raj
Commented on May 21, 2025
All of the answers are correct for question 26.
UNITED STATES
GPNK
Commented on May 17, 2025
Preparing for exam
JAPAN
Kalilulla
Commented on May 14, 2025
Preparing for certification
INDIA
Gowtham
Commented on May 12, 2025
I am 2 years experienced with Snowflake, yet after looking into these questions, I am really bothered about facing Snowpro Core, Preparation was real scarry.
Anonymous
Balaji
Commented on April 23, 2025
Preparing for exam
Anonymous
Bob
Commented on March 12, 2025
This AWS-SysOps exam dump help me so much! Many questions was same like real exam, so I feel more confident. Some was hard, but the answer explain good, so I understand better, not just remmember. I have trouble with monitoring part, but this make it more clear.
EUROPEAN UNION
Anonymous
Commented on February 28, 2025
Testing my Snowflake knowledge
INDIA
Anonymous
Commented on February 28, 2025
preparing for exam
INDIA
Leemon
Commented on February 26, 2025
Why don't you guys share your experience here man?!
This is a good site and I can see it has a lot of users. So just be helpful and post your experience and thoughts.
UNITED STATES
Mubarok
Commented on February 26, 2025
I am very nervous to go write my exam. These questions looks promising.
AUSTRALIA
Pankti
Commented on February 22, 2025
Thanks for sharing exam questions. These are really helpful for exam preparation.
UNITED STATES
hari
Commented on February 11, 2025
Preparing for exam
INDIA
Santhosh Kumar Shanmugham
Commented on January 07, 2025
planning to attend snowflake certification
Anonymous
T qwe
Commented on January 05, 2025
Preparing for the certification. This is helpful
UNITED KINGDOM
Jorden
Commented on January 05, 2025
HUGE thank you for this website for helping me pass this exam.
UNITED KINGDOM
Cara
Commented on December 22, 2024
I am happy to have found this exam questions. For those who already wrote this exam please share your thoughts and experince.
Anonymous
srini
Commented on December 19, 2024
Really helped me with the certification exam.
Anonymous
srinivas
Commented on December 18, 2024
Really helpful.
Anonymous
ks
Commented on December 10, 2024
Really helpful. Just got my certification passed. Thanks.
Anonymous
Skh
Commented on December 07, 2024
Really helpful. Just got my certification passed. Thanks.
Anonymous
dsr
Commented on November 27, 2024
recommended to every one those who prepare for snowpro core exam
EUROPEAN UNION
srinivas
Commented on November 27, 2024
useful questions for beginners
EUROPEAN UNION
Kincky77
Commented on November 27, 2024
Brooo, this is awesome. Did not know you could get these practice questions online. Really helped me with the certification exam.
UNITED KINGDOM