Infosys Certified Snowflake Data Warehouse Developer
Practice with real exam-pattern questions for Infosys Certified Snowflake Data Warehouse Developer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Snowflake Data Warehouse Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Snowflake Data Warehouse Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Which of the following database object in snowflake is storing non-permanent, transitory data like ETL data which is session specific in nature?
- ✓
Views
Correct - B
Transient Table
- C
Temporary Table
- D
External table
- ✓
- Question 2
Identify the features of Time Travel in snowflake?
- ✓
Data backup from specific points
Correct - B
Restoring objects which got accidentally deleted
- C
Data usage Analysis over time
- D
All the given options
- ✓
- Question 3
Select the features that are true about the Snowflake Data Warehouse architecture:
- ✓
Data storage is independent from compute
Correct - B
Warehouses can be dynamically expanded to adjust to workloads
- C
All interactions with data are initiated through the services layer
- D
Multi-Cluster warehouses support high concurrency
- ✓
- Question 4
Which of the Snowflake database object persists until it is explicitly dropped and are available to all users with the appropriate privileges with the key difference that they do not have a Fail-safe period?
- ✓
Views
Correct - B
Transient Table
- C
Temporary Table
- D
External table
- ✓
- Question 5
If a size Small virtual warehouse is made up of two servers, how many servers make up a Medium warehouse?
- ✓
4
Correct - B
8
- C
12
- D
16
- ✓
- Question 6
What file formats does Snowflake support for loading semi-structured data? (Select ANY THREE options)
- ✓
CSV
Correct - B
PDF
- C
JSON
- D
AVRO
- E
PARQUET
- ✓
- Question 7
Which data type can store more than one type of data structure?
- ✓
VARIANT
Correct - B
BINARY
- C
DECIMAL
- D
STRING
- ✓
- Question 8
In Snowflake architecture, where layer is used for metadata storage?
- ✓
Storage layer
Correct - B
Compute layer
- C
Service layer
- D
None of the above
- ✓
- Question 9
You can manage user preferences in the following areas through the Snowflake user interface except:
- ✓
Adding users and permissions
Correct - B
Enrolling in multi-factor authentication
- C
Executing Fail-Safe recovery
- D
Monitoring queries using the History page
- ✓
- Question 10
What is the default scaling policy for multi-cluster warehouse?
- ✓
Economy
Correct - B
Standard
- C
Enterprise
- D
None of the above
- ✓
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.