SnowPro Core Exam Discussions & Posts
Anonymous
Commented on August 06, 2025
insert and copy are direct commands unlike merge and upsert where there are check and hence and blocking commands
UNITED STATES
Anonymous
Commented on August 06, 2025
Question 20 - regardless of whether it;s a structured or semi-structured it charges equal based on size.
UNITED STATES
Matthew
Commented on August 04, 2025
QUESTION: 55
Correct Ans is SYSADMIN
Anonymous
Matthew
Commented on August 04, 2025
QUESTION: 26
All choices are correct not only A, B
Anonymous
G
Commented on August 02, 2025
QUESTION: 594
E is also right answer
AUSTRALIA
G
Commented on August 02, 2025
QUESTION: 583
answer is A B D in this order of priority and not just A D. So the best choice is A B
AUSTRALIA
G
Commented on August 02, 2025
QUESTION: 576
answer is A and not B
AUSTRALIA
G
Commented on August 02, 2025
QUESTION: 574
answer is C and not B
AUSTRALIA
G
Commented on August 02, 2025
QUESTION: 571
answer is B D and not B E
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 560
answer is C and not D
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 541
answer is D and not C
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 524
answer is A and not C
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 522
answer is A and not B
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 510
answer is D and not B
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 508
answer is A and not C
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 499
answer is A C D
not only C D
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 428
answers A D E
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 409
answer is B and not C
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 405:
answer is A and not D
AUSTRALIA
G
Commented on August 01, 2025
QUESTION: 357
answer is C and not D
AUSTRALIA
G
Commented on August 01, 2025
for question # 349 correct answer is B D and not B C
AUSTRALIA
G
Commented on July 31, 2025
Most of the answers here are accurate
AUSTRALIA
G
Commented on July 31, 2025
Very helpful dump for higher success rates
AUSTRALIA
Kowsar
Commented on July 29, 2025
Good questions for practice
UNITED STATES
gm
Commented on July 26, 2025
Question 123 - False -
Reader accounts in Snowflake are designed for accessing and querying data shared by a provider, but they cannot extract that data for use outside of the Snowflake environment. They are primarily used for data consumption within Snowflake.
Anonymous
gm
Commented on July 26, 2025
Q109 - False because owned by role not by user
Anonymous
gm
Commented on July 26, 2025
91 - Answer should be True
AWS PrivateLink can be used to establish a secure, private connection between a customer's on-premise data center (via AWS Direct Connect) and Snowflake. This connection bypasses the public internet, enhancing security and reducing the risk of data exposure.
Anonymous
gm
Commented on July 26, 2025
Question 77: Answer should be all
Bulk copy from an External Stage:
This involves using the COPY INTO command to load data from files stored in external cloud storage locations (e.g., Amazon S3, Azure Blob Storage, Google Cloud Storage) into a Snowflake table.
Continuous load using Snowpipe REST API:
Snowpipe enables continuous data loading from staged files as soon as they become available. The Snowpipe REST API can be used to trigger the loading process for new files in an external stage.
The Snowflake Web Interface (UI) data loading wizard:
Snowsight, Snowflake's web interface, provides a user-friendly wizard that guides users through the process of loading data into tables, often from local files or staged files.
Bulk copy from an Internal Stage:
Similar to external stages, data can be bulk loaded from internal stages (storage locations within Snowflake) into tables using the COPY INTO command. Files can be placed in internal stages using commands like PUT.
Anonymous
gm
Commented on July 26, 2025
Question 68:
Explanation:
INSERT:
When inserting data into a table, Snowflake usually writes to new partitions, allowing other queries to access the existing data simultaneously.
COPY:
Similar to INSERT, the COPY command often writes to new partitions, enabling parallel execution with other operations.
Why other options are incorrect:
UPDATE:
This command modifies existing data in a table, which requires locking the affected rows to prevent conflicts. This makes it a blocking operation, meaning other queries that need to access the same rows will have to wait until the UPDATE finishes.
MERGE:
Like UPDATE, the MERGE command modifies data in a table, requiring locks and thus being a blocking operation. It combines data from multiple sources into a target table, which can involve modifying existing rows.
Anonymous
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