SnowPro Core Certification – 50 Scenario-Based

MCQs
Q1: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use?
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q2: A developer needs to load JSON files into Snowflake and query them without defining strict
schema. Which Snowflake feature is most appropriate?
A. VARIANT data type
B. External Tables
C. Dynamic Data Masking
D. Streams
■ Correct Answer: A

Q3: Which of the following caches allow reuse of previous query results across sessions?
A. Result Cache
B. Warehouse Cache
C. Metadata Cache
D. Data Cache
■ Correct Answer: A

Q4: A company wants to restrict access so only certain corporate IPs can log in. Which Snowflake
feature should be used?
A. Roles
B. Network Policies
C. Masking Policies
D. Virtual Private Snowflake
■ Correct Answer: B

Q5: You need to share live, secure data with external partners without physically moving the data.
Which feature should you use?
A. Data Replication
B. Secure Data Sharing
C. Materialized Views
D. External Stages
■ Correct Answer: B

Q6: You want to enforce row-level security so users can only see rows related to their region.
Which feature should be used?
A. Dynamic Data Masking
B. Row Access Policies
C. Views
D. Secure Data Sharing
■ Correct Answer: B

Q7: A warehouse query is spilling to remote storage. What could help improve performance?
(Select two)
A. Use a larger warehouse size
B. Rewrite queries to scan less data
C. Switch to a smaller warehouse
D. Increase Time Travel period
■ Correct Answers: A, B

Q8: A team wants to mask sensitive data dynamically based on user roles. Which Snowflake
feature allows this?
A. Row Access Policies
B. Dynamic Data Masking
C. Network Policies
D. Fail-safe
■ Correct Answer: B

Q9: Your company uses S3 for staging data. Which type of stage should you configure for loading
data directly from S3?
A. User Stage
B. Internal Named Stage
C. External Stage
D. Table Stage
■ Correct Answer: C

Q10: To track INSERT/UPDATE/DELETE changes on a table for downstream processing, which

Q11: A company wants multiple consumers to access the same data product. What should the
provider create?
A. Reader Accounts
B. Tasks
C. External Tables
D. Data Shares
■ Correct Answer: D

Q12: What is the default retention period for Time Travel in Snowflake Standard Edition?
A. 1 day
B. 7 days
C. 30 days
D. 90 days
■ Correct Answer: A

Q13: A query needs to join two very large tables. Which technique can improve performance?
A. Use clustering keys
B. Use result caching
C. Increase fail-safe
D. Enable masking policies
■ Correct Answer: A

Q14: A team wants to clone a production schema for testing but avoid storage overhead. Which
feature allows this?
A. Materialized Views
B. Zero-Copy Cloning
C. Streams
D. File Formats
■ Correct Answer: B

Q15: Which two Snowflake roles are typically used for security administration? (Select two)
A. ACCOUNTADMIN
B. SECURITYADMIN
C. ORGADMIN
D. SYSADMIN
■ Correct Answers: A, B

Q16: A multinational company requires different retention times for different tables. How can this be
achieved?
A. Change the account Time Travel setting
B. Set retention at table level
C. Enable fail-safe
D. Clone the table
■ Correct Answer: B

Q17: A customer wants to minimize cost but ensure query performance during peak hours. Which
strategy works best?
A. Multi-cluster warehouse with auto-suspend
B. Keep warehouse always running
C. Enable fail-safe
D. Create larger static warehouses
■ Correct Answer: A

Q18: You need to query semi-structured JSON data nested within arrays. Which functions are most
useful? (Select two)
A. FLATTEN()
B. PARSE_JSON()
C. CAST()
D. SPLIT()
■ Correct Answers: A, B

Q19: A user created a share, but the consumer cannot access data. Which steps are required?
(Select two)
A. Consumer must create a database from the share
B. Grant usage on share to consumer role
C. Provider must enable fail-safe
D. Consumer must enable Time Travel
■ Correct Answers: A, B

Q20: A team wants to automate nightly transformations. Which Snowflake objects should be
combined?
A. Streams and Tasks
B. File Formats and Shares
C. Roles and Policies
D. Fail-safe and Time Travel
■ Correct Answer: A

Q21: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q22: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q23: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q24: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q25: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q26: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q27: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q28: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q29: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q30: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q31: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q32: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q33: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q34: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q35: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q36: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C
Q37: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q38: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q39: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q40: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q41: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q42: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q43: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q44: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q45: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q46: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q47: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q48: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q49: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C

Q50: Your analyst dropped a table accidentally. The table was dropped today, and you need to
recover it. Which feature should you use? (variant)
A. Fail-safe
B. Zero-Copy Clone
C. Time Travel
D. External Tables
■ Correct Answer: C