Infosys Certified Snowflake Advanced Developer
Practice with real exam-pattern questions for Infosys Certified Snowflake Advanced 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 Advanced Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Snowflake Advanced Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Which of the following are best practices for loading data into Snowflake? (Choose ANY THREE options)
- ✓
Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
Correct - B
Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
- C
Enclose fields that contain delimiter characters in single or double quotes.
- D
Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
- E
When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
- ✓
- Question 2
The number of queries that a Virtual Warehouse can concurrently process is determined by (Select ANY TWO options):
- ✓
The complexity of each query
Correct - B
The CONCURRENT_QUERY_LIMIT parameter set on the Snowflake account
- C
The size of the data required for each query
- D
The tool that is executing the query
- ✓
- Question 3
How does Snowflake Data Cloud allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?
- ✓
The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
Correct - B
The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
- C
The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
- D
The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account
- ✓
- Question 4
Which of the following statements are TRUE about running tasks in Snowflake? (Select ANY THREE options)
- ✓
A task allows a user to execute a procedural logic using Snowflake Scripting
Correct - B
A task allows a user to execute a single SQL statement / command using a predefined schedule
- C
A task allows a user to execute a set of SQL commands on a predefined schedule
- D
A task allows user to call a stored procedure
- ✓
- Question 5
As a best practice, clustering keys must only be defined on tables of which minimum size?
- ✓
Multi-Kilobyte (KB) Range
Correct - B
Multi-Megabyte (MB) Range
- C
Multi-Gigabyte (GB) Range
- D
Multi-Terabyte (TB) Range
- ✓
- Question 6
What happens when a Data Provider revokes privileges to a share on an object in their source database?
- ✓
The object immediately becomes unavailable for all Data Consumers
Correct - B
Any additional data arriving after this point in time will not be visible to Data Consumers
- C
The Data Consumers stop seeing data updates and become responsible for storage charges for the object
- D
A static copy of the object at the time the privilege was revoked is created in the Data Consumers account
- ✓
- Question 7
A Snowflake user has a Snow SQL query that is running for a long time. When the user opens the query profiler, it indicates that a lot of data is spilling to disk.
What is causing this to happen?
- ✓
The result cache is almost full and is unable to hold the results
Correct - B
The cloud storage staging area is not sufficient to hold the data results.
- C
The warehouse memory is not sufficient to hold the intermediate query results.
- D
Clustering has not been applied to the table so the table is not optimized.
- ✓
- Question 8
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake.
The user enables the STRIP_OUTER_ARRAY file format option.
What does the STRIP_OUTER_ARRAY file format do?
- ✓
It removes the last element of the outer array.
Correct - B
It removes the outer array structure and loads the records into separate table rows.
- C
It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns.
- D
It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records.
- ✓
- Question 9
Identify the functionalities of PUT command used for Data loading in Snowflake. (Choose ANY TWO options)
- ✓
Automatically creates a File Format object
Correct - B
Automatically uses the last Stage created
- C
Automatically compresses files using Gzip
- D
Automatically encrypts files
- ✓
- Question 10
Which of the following commands are not blocking operations? (SELECT ANY TWO Options)
- ✓
UPDATE
Correct - B
INSERT
- C
MERGE
- D
COPY
- ✓
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Tableau Desktop Advanced Developer
Infosys Certified Microsoft SSIS 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.