Snowflake Certification Practice Test 01

Practice Test 01

Question 1 of 20

📋 Multiple Choice

Question 1

## Question 1 A newly hired Data Engineer joins an e-commerce company. The company wants a cloud-native platform where storage and compute can scale independently. Which Snowflake capability satisfies this requirement?

A. Virtual Warehouses

✓

B. Separate Storage and Compute Architecture

C. Materialized Views

D. Data Sharing

Answer

✅ B. Separate Storage and Compute Architecture

Explanation

Snowflake separates storage from compute, allowing organizations to scale them independently. ---

Answered: 0 / 20

Snowflake Certification Practice Test 01

Practice Test 01

Insightful Saga — Modern Data Engineering Certification Preparation

Question 1

A. Virtual Warehouses

B. Separate Storage and Compute Architecture

C. Materialized Views

D. Data Sharing

Answer: ✅ B. Separate Storage and Compute Architecture

Explanation:

Snowflake separates storage from compute, allowing organizations to scale them independently. ---

Question 2

## Question 2 A company stores 100 TB of sales data. Business users run only a few reports every day. What is the PRIMARY benefit of Snowflake's architecture?

A. Unlimited Dashboards

B. Pay for Compute Only When Used

C. No Security Model

D. No Metadata

Answer: ✅ B. Pay for Compute Only When Used

Explanation:

Virtual warehouses can be suspended when not in use, reducing compute costs. ---

Question 3

## Question 3 A Snowflake database contains multiple business areas such as Finance, HR, and Sales. Which Snowflake object should typically organize these areas?

A. Warehouse

B. Stage

C. Schema

D. Stream

Answer: ✅ C. Schema

Explanation:

Schemas logically organize database objects inside a database. ---

Question 4

## Question 4 Which Snowflake object provides computing resources for query execution?

A. Schema

B. Stage

C. Virtual Warehouse

D. Stream

Answer: ✅ C. Virtual Warehouse ---

Question 5

## Question 5 A user loads data into Snowflake but does not execute any queries. Which Snowflake component is consuming storage costs?

A. Warehouse

B. Storage Layer

C. Task

D. Stream

Answer: ✅ B. Storage Layer ---

Question 6

## Question 6 A company wants multiple analysts to query the same dataset simultaneously without impacting each other's performance. Which Snowflake capability supports this?

A. Separate Virtual Warehouses

B. Separate Databases

C. Separate Accounts

D. Separate Stages

Answer: ✅ A. Separate Virtual Warehouses ---

Question 7

## Question 7 A newly created warehouse has not processed any queries for 15 minutes. What configuration can reduce costs automatically?

A. Clustering Key

B. Auto Suspend

C. Stream

D. Time Travel

Answer: ✅ B. Auto Suspend ---

Question 8

## Question 8 Which Snowflake object is used to temporarily hold files before loading?

A. Warehouse

B. Stage

C. Role

D. Schema

Answer: ✅ B. Stage ---

Question 9

## Question 9 A file is uploaded into an internal stage. What is the next step typically performed before analytics can begin?

A. Load Data Into Table

B. Drop Warehouse

C. Create Clone

D. Create Stream

Answer: ✅ A. Load Data Into Table ---

Question 10

## Question 10 A company wants strict separation between Development, QA, and Production environments. Which approach is MOST commonly used?

A. Separate Databases

B. Disable Roles

C. Single Schema

D. Single Warehouse

Answer: ✅ A. Separate Databases ---

Question 11

## Question 11 A security team wants users to receive only the permissions required to perform their jobs. Which principle should be followed?

A. Full Access

B. Least Privilege

C. Public Access

D. Shared Credentials

Answer: ✅ B. Least Privilege ---

Question 12

## Question 12 Which Snowflake object is primarily responsible for access control?

A. Role

B. Stage

C. Stream

D. Warehouse

Answer: ✅ A. Role ---

Question 13

## Question 13 A Data Engineer wants to grant permissions to a team rather than individual users. What is the recommended approach?

A. Assign Permissions Directly

B. Use Roles

C. Create Warehouses

D. Create Streams

Answer: ✅ B. Use Roles ---

Question 14

## Question 14 A company accidentally drops a table. Which Snowflake feature may allow recovery?

A. Time Travel

B. Search Optimization

C. Materialized View

D. Task

Answer: ✅ A. Time Travel ---

Question 15

## Question 15 Which layer stores actual table data in Snowflake?

A. Storage Layer

B. Compute Layer

C. Cloud Services Layer

D. Warehouse Layer

Answer: ✅ A. Storage Layer ---

Question 16

## Question 16 A warehouse is resized from Small to Large. What changes?

A. More Compute Resources

B. More Storage

C. More Databases

D. More Schemas

Answer: ✅ A. More Compute Resources ---

Question 17

## Question 17 Which Snowflake feature enables secure sharing of data without copying it?

A. Data Sharing

B. Streams

C. Tasks

D. Clustering

Answer: ✅ A. Data Sharing ---

Question 18

## Question 18 An engineer wants to view all databases available in Snowflake. Which command would typically help?

A. SHOW DATABASES

B. SHOW USERS

C. SHOW STREAMS

D. SHOW TASKS

Answer: ✅ A. SHOW DATABASES ---

Question 19

## Question 19 A company stores JSON files inside Snowflake. Which Snowflake capability supports this?

A. Semi-Structured Data Support

B. Clustering Key

C. Search Optimization

D. Warehouse Scaling

Answer: ✅ A. Semi-Structured Data Support ---

Question 20

## Question 20 A new Data Engineer joins a company. Before creating tables, the engineer typically needs:

A. Database and Schema

B. Search Optimization

C. Streams

D. Materialized Views

Answer: ✅ A. Database and Schema

Explanation:

Tables are usually created inside schemas, which are contained within databases. --- --- title: Snowflake Certification Practice Test 02 description: Intermediate Snowflake Concepts ---