Practice exam · Snowflake
SnowPro Core Certification practice exam
Short answer
The SnowPro Core Certification practice exam has 100 questions in 115 minutes, with a 75% passing mark, as configured here. The fastest way to know whether you are ready is to sit a full exam on the clock and read your score by domain, not only the total.
Domains covered
- Account Access and Security
- Data Loading and Unloading
- Data Protection and Data Sharing
- Performance Concepts
- Snowflake AI Data Cloud Features and Architecture
- Data Transformations
Sample questions, with explanations
Three questions from the bank, open to read.
Select the term that is associated with the compute layer:
- Query optimization
- Query planning
- Query processing ✓ (correct)
Why this is correct
You can find the name of the layers in different ways, like Query Processing for the Compute Layer.
Is re-clustering in Snowflake only triggered if the table would benefit from the operation?
- True ✓ (correct)
- False
Why this is correct
DML operations (INSERT, UPDATE, DELETE, MERGE, COPY) can make the data in the table become less clustered. To solve that, Snowflake provides periodic & automatic re-clustering to maintain optimal clustering. It only reclusters a clustered table if it benefits from the operation.
Can you load data using the PUT command through worksheets in the Snowflake UI?
- True
- False ✓ (correct)
Why this is correct
We can use the PUT command to UPLOAD files from a local directory/folder on a client machine into INTERNAL STAGES. It does NOT work with external stages, and we cannot use it from the Snowflake Web UI.
Take the full practice exam
- 100 questions drawn from the bank, with a 115-minute timer
- Score by domain and a review of every question
- An AI tutor to talk through each question you miss
- What you miss feeds your study plan
Independent, unofficial practice exam. Snowflake and the exam name are trademarks of their owners; UpSkillScore is not affiliated with them. Format and passing mark are the exam's configuration in UpSkillScore, not an official statement.
Frequently asked questions
How many questions does the SnowPro Core Certification practice exam have?
It has 100 questions and a 115-minute limit. The passing mark of the practice exam is 75%.
Is this the official SnowPro Core Certification exam?
No. It is an independent practice exam built to match the structure of the real one. It does not replace the official exam.
Do I need an account to take it?
You can read the structure and sample questions without an account. Taking the full timed exam, scoring by domain and the AI tutor need one.