SNOWFLAKE EXAM 2025 WITH 100% ACCURATE
SOLUTIONS
True or false: A table in Snowflake can contain both a variant columns and a timestamp. -
✅✅✅CORRECT -True
True or false: The warehouse cache may be reset if a running warehouse is suspended and then
resumed. - ✅✅✅CORRECT -True
Which of the following are true of Multi-Cluster warehouses? Select all that apply. - ✅✅✅CORRECT -
Adds clusters automatically based on query activity;
Scales down when query activity slows
Which of the following are options when creating a Virtual Warehouse? - ✅✅✅CORRECT -Auto-
suspend;
Auto-resume
What is the recommended approach for making a variant column accessible in a BI tool? -
✅✅✅CORRECT -A view
Which of the following statements are true about Snowflake Data sharing? Select all that apply. -
✅✅✅CORRECT -Consumers can query shared tables in the same query as their own tables;
Data Sharing is integrated with role-based access controls
The Snowflake metadata repository contains which of the following? Select all that apply -
✅✅✅CORRECT -Table definitions;
References to all of the micropartition files for that table;
Tracking of all versions of the table data within the data retention window
Which transformations are available when using the COPY INTO command to load data files into
Snowflake from a stage? (select all that apply) - ✅✅✅CORRECT -Column data type conversion;
,Column concatenation
Which of the following statements apply to Snowflake in terms of security? Select all that apply. -
✅✅✅CORRECT -Snowflake leverages a role-based access control model;
All data in snowflake is encrypted
Which of the following is not a layer in Snowflake's Architecture? - ✅✅✅CORRECT -Data Catalog
(Layers are: Cloud Services, Virtual Warehouses, Storage)
Which of the following are true about the variant data type in Snowflake? Select all that apply. -
✅✅✅CORRECT -Optimized storage based on repeated elements;
Can be queried using JSON path notation
True or false: Snowflake only works with cloud-based tools. - ✅✅✅CORRECT -False
What technique does Snowflake use to limit the number of micro-partitions scanned by each query? -
✅✅✅CORRECT -Pruning
What is the maximum number of consumer accounts that can be added to a Share object? -
✅✅✅CORRECT -Unlimited
Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation?
Select the best answer. - ✅✅✅CORRECT -ELT
True or false: Snowflake offers tools to extract data from source systems. - ✅✅✅CORRECT -False
Which of the following best describes Snowflake's processing engine? - ✅✅✅CORRECT -Native SQL
Which of the following techniques can be used in Snowflake to improve query performance? -
✅✅✅CORRECT -Cluster Keys/Reclustering
, True or false: Virtual Warehouses cannot be resized while queries are running. - ✅✅✅CORRECT -
False
Which of the following are types of caching use by Snowflake? Select all that apply. - ✅✅✅CORRECT
-Warehouse caching;
Metadata caching;
Query result caching
Snowflake supports which of the following file formats for data loading? Select all that apply. -
✅✅✅CORRECT -Parquet;
ORC;
CSV
True or False: When data is staged to a Snowflake internal staging area using the PUT command, the data
is encrypted on the client's machine. - ✅✅✅CORRECT -True
True or false: You can point Snowflake at any S3 bucket to directly query the files in that bucket as long
as the files are in Parquet or ORC format. - ✅✅✅CORRECT -False
True or false: Snowflake caches are automatically invalidated if the underlying data changes. -
✅✅✅CORRECT -True
True or false: The Query Profiler view is only available for completed queries. - ✅✅✅CORRECT -False
Which role in Snowflake allows a user to administer users and manage all database objects? -
✅✅✅CORRECT -ACCOUNTADMIN
True or false: A table in Snowflake can only be queried using the Virtual Warehouse used to load the
data. - ✅✅✅CORRECT -False
Select all of the answers that describe Snowflake micro-partitions. Micro-partitions: - ✅✅✅CORRECT
-Are the physical data files that comprise Snowflake's logical tables;
SOLUTIONS
True or false: A table in Snowflake can contain both a variant columns and a timestamp. -
✅✅✅CORRECT -True
True or false: The warehouse cache may be reset if a running warehouse is suspended and then
resumed. - ✅✅✅CORRECT -True
Which of the following are true of Multi-Cluster warehouses? Select all that apply. - ✅✅✅CORRECT -
Adds clusters automatically based on query activity;
Scales down when query activity slows
Which of the following are options when creating a Virtual Warehouse? - ✅✅✅CORRECT -Auto-
suspend;
Auto-resume
What is the recommended approach for making a variant column accessible in a BI tool? -
✅✅✅CORRECT -A view
Which of the following statements are true about Snowflake Data sharing? Select all that apply. -
✅✅✅CORRECT -Consumers can query shared tables in the same query as their own tables;
Data Sharing is integrated with role-based access controls
The Snowflake metadata repository contains which of the following? Select all that apply -
✅✅✅CORRECT -Table definitions;
References to all of the micropartition files for that table;
Tracking of all versions of the table data within the data retention window
Which transformations are available when using the COPY INTO command to load data files into
Snowflake from a stage? (select all that apply) - ✅✅✅CORRECT -Column data type conversion;
,Column concatenation
Which of the following statements apply to Snowflake in terms of security? Select all that apply. -
✅✅✅CORRECT -Snowflake leverages a role-based access control model;
All data in snowflake is encrypted
Which of the following is not a layer in Snowflake's Architecture? - ✅✅✅CORRECT -Data Catalog
(Layers are: Cloud Services, Virtual Warehouses, Storage)
Which of the following are true about the variant data type in Snowflake? Select all that apply. -
✅✅✅CORRECT -Optimized storage based on repeated elements;
Can be queried using JSON path notation
True or false: Snowflake only works with cloud-based tools. - ✅✅✅CORRECT -False
What technique does Snowflake use to limit the number of micro-partitions scanned by each query? -
✅✅✅CORRECT -Pruning
What is the maximum number of consumer accounts that can be added to a Share object? -
✅✅✅CORRECT -Unlimited
Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation?
Select the best answer. - ✅✅✅CORRECT -ELT
True or false: Snowflake offers tools to extract data from source systems. - ✅✅✅CORRECT -False
Which of the following best describes Snowflake's processing engine? - ✅✅✅CORRECT -Native SQL
Which of the following techniques can be used in Snowflake to improve query performance? -
✅✅✅CORRECT -Cluster Keys/Reclustering
, True or false: Virtual Warehouses cannot be resized while queries are running. - ✅✅✅CORRECT -
False
Which of the following are types of caching use by Snowflake? Select all that apply. - ✅✅✅CORRECT
-Warehouse caching;
Metadata caching;
Query result caching
Snowflake supports which of the following file formats for data loading? Select all that apply. -
✅✅✅CORRECT -Parquet;
ORC;
CSV
True or False: When data is staged to a Snowflake internal staging area using the PUT command, the data
is encrypted on the client's machine. - ✅✅✅CORRECT -True
True or false: You can point Snowflake at any S3 bucket to directly query the files in that bucket as long
as the files are in Parquet or ORC format. - ✅✅✅CORRECT -False
True or false: Snowflake caches are automatically invalidated if the underlying data changes. -
✅✅✅CORRECT -True
True or false: The Query Profiler view is only available for completed queries. - ✅✅✅CORRECT -False
Which role in Snowflake allows a user to administer users and manage all database objects? -
✅✅✅CORRECT -ACCOUNTADMIN
True or false: A table in Snowflake can only be queried using the Virtual Warehouse used to load the
data. - ✅✅✅CORRECT -False
Select all of the answers that describe Snowflake micro-partitions. Micro-partitions: - ✅✅✅CORRECT
-Are the physical data files that comprise Snowflake's logical tables;
