Snowflake Certification Practice Test 02

Practice Test 02

Question 1 of 20

📋 Multiple Choice

Question 21

## Question 21 A retail company accidentally deletes customer records from a table. The deletion occurred 12 hours ago. What is the BEST Snowflake feature to recover the deleted data?

A. Fail-safe

B. Cloning

✓

C. Time Travel

D. Snowpipe

Answer

✅ C. Time Travel

Explanation

Time Travel allows access to historical versions of data within the configured retention period. ---

Answered: 0 / 20

Snowflake Certification Practice Test 02

Practice Test 02

Insightful Saga — Modern Data Engineering Certification Preparation

Question 21

## Question 21 A retail company accidentally deletes customer records from a table. The deletion occurred 12 hours ago. What is the BEST Snowflake feature to recover the deleted data?

A. Fail-safe

B. Cloning

C. Time Travel

D. Snowpipe

Answer: ✅ C. Time Travel

Explanation:

Time Travel allows access to historical versions of data within the configured retention period. ---

Question 22

## Question 22 A Data Engineer wants to create a copy of a production database instantly without copying physical data. Which Snowflake feature should be used?

A. Stream

B. Clone

C. Task

D. Warehouse

Answer: ✅ B. Clone

Explanation:

Zero-Copy Cloning creates metadata pointers instead of physically duplicating data. ---

Question 23

## Question 23 A company wants developers to test schema changes safely without impacting production data. What is the MOST appropriate approach?

A. Clone the Production Database

B. Create a Larger Warehouse

C. Create a New Role

D. Create a Stream

Answer: ✅ A. Clone the Production Database ---

Question 24

## Question 24 A Snowflake table is configured with a 7-day Time Travel retention period. What happens after the Time Travel period expires?

A. Data enters Fail-safe

B. Data is deleted immediately

C. Warehouse restarts

D. Streams are reset

Answer: ✅ A. Data enters Fail-safe ---

Question 25

## Question 25 What is the PRIMARY purpose of Snowflake Fail-safe?

A. Performance Optimization

B. Disaster Recovery

C. Query Acceleration

D. Role Management

Answer: ✅ B. Disaster Recovery

Explanation:

Fail-safe is a Snowflake recovery mechanism designed for catastrophic recovery scenarios. ---

Question 26

## Question 26 A company wants to identify changed rows since the last ETL run. Which Snowflake feature is most appropriate?

A. Stream

B. Warehouse

C. Clone

D. View

Answer: ✅ A. Stream ---

Question 27

## Question 27 A Stream in Snowflake primarily tracks:

A. Warehouse Activity

B. Change Data Capture Information

C. User Logins

D. Query History

Answer: ✅ B. Change Data Capture Information ---

Question 28

## Question 28 A company wants to execute an ETL process every night at midnight. Which Snowflake feature should be configured?

A. Stage

B. Task

C. Stream

D. Clone

Answer: ✅ B. Task ---

Question 29

## Question 29 A Stream captures changes in a source table. What component commonly consumes those changes?

A. Task

B. Warehouse Resize

C. Role

D. Schema

Answer: ✅ A. Task ---

Question 30

## Question 30 A company wants fully automated data ingestion whenever files arrive in cloud storage. Which Snowflake capability should be implemented?

A. Snowpipe

B. Time Travel

C. Search Optimization

D. Clone

Answer: ✅ A. Snowpipe ---

Question 31

## Question 31 A new CSV file arrives in cloud storage. Snowpipe automatically loads the file. Which business benefit is achieved?

A. Near Real-Time Ingestion

B. Data Sharing

C. Clustering

D. Fail-safe

Answer: ✅ A. Near Real-Time Ingestion ---

Question 32

## Question 32 A Data Engineer wants ingestion to happen without manually running COPY commands. What solution is best?

A. Snowpipe

B. Stream

C. Clone

D. Warehouse Scaling

Answer: ✅ A. Snowpipe ---

Question 33

## Question 33 A company clones a database. Immediately after cloning, storage consumption is:

A. Doubled

B. Tripled

C. Nearly Unchanged

D. Deleted

Answer: ✅ C. Nearly Unchanged

Explanation:

Zero-copy cloning initially shares underlying storage. ---

Question 34

## Question 34 Which Snowflake feature enables point-in-time access to historical data?

A. Streams

B. Time Travel

C. Tasks

D. Warehouses

Answer: ✅ B. Time Travel ---

Question 35

## Question 35 A Data Engineer wants to automate a pipeline: 1. Detect Changes 2. Process Changes 3. Update Target Table Which combination is MOST appropriate?

A. Stream + Task

B. Clone + Warehouse

C. Snowpipe + Role

D. View + Schema

Answer: ✅ A. Stream + Task ---

Question 36

## Question 36 A healthcare company wants a testing environment identical to production. Which approach provides the fastest solution?

A. Rebuild All Objects

B. Export and Import Data

C. Zero-Copy Clone

D. Create New Warehouse

Answer: ✅ C. Zero-Copy Clone ---

Question 37

## Question 37 A company wants to schedule SQL execution every hour. Which Snowflake object should be used?

A. Stream

B. Task

C. Stage

D. View

Answer: ✅ B. Task ---

Question 38

## Question 38 A company receives thousands of files daily. Manual ingestion is no longer practical. Which Snowflake feature is designed for this scenario?

A. Snowpipe

B. Time Travel

C. Fail-safe

D. Clone

Answer: ✅ A. Snowpipe ---

Question 39

## Question 39 An engineer accidentally updates millions of records incorrectly. The issue is discovered three hours later. Which Snowflake feature provides the fastest recovery path?

A. Warehouse Resize

B. Database Role

C. Time Travel

D. Search Optimization

Answer: ✅ C. Time Travel ---

Question 40

## Question 40 A company wants to build incremental ETL pipelines instead of full reloads. Which Snowflake feature should be evaluated first?

A. Streams

B. Clone

C. Warehouse Scaling

D. Materialized Views

Answer: ✅ A. Streams

Explanation:

Streams track row-level changes, making them ideal for incremental processing. --- --- title: Snowflake Certification Practice Test 03 description: Company Scenario Based Questions ---