SNOWFLAKE SNOWPRO CORE EXAM 1
2025 QUESTIONS AND ANSWERS
What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?
1. Convert the rows in a relational table to a single VARIANT column and then unload the rows
into a file.
2. Reorder the rows in a relational table and then unload the rows into a file.
3. Convert the rows in a source file to a single VARIANT column and then load the rows from
the file to a variant table.
4. Reorder the data columns according to a target table definition and then unload the rows
into the table. - ANS 1
By default, which Snowflake role is required to create a share?
1. SECURITYADMIN
2. ORGADMIN
3. SHAREADMIN
4. ACCOUNTADMIN - ANS 4
If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended
when:
1. The last query using the Warehouse completes.
2. All Snowflakes sessions using the Warehouse are terminated.
3. There are no users logged into Snowflake.
1 @COPYRIGHT THESTAR 2025/2026
,4. The Warehouse is inactive for a specified period of time. - ANS 4
Which of the following statements are true concerning the Snowflake release process? (Choose
three.)
1. A customer is assigned a 30 minute window (that can be moved anytime within a week)
during which the system will be unavailable and customer is upgraded
2. Snowflake deploys new Behavior change releases every month.
3. Snowflake deploys patch releases every week, but new feature releases happen once a
month.
4. Snowflake deploys new feature releases and releases every week.
5. There is usually some minimal downtime associated with Snowflake during the deployments.
6. It is possible for you as a user to request 24-hour early access to the upcoming releases so
that you can do additional release testing before the release is rolled out. - ANS 2,4,6
What are the available Snowflake scaling modes for configuring multi-cluster virtual
warehouses? (Choose two.)
1. Economy
2. Maximized
3. Scale-Out
4. Auto-Scale
5. Standard - ANS 2,4
Snowflake will return an error when a user attempts to share which object?
1. Secure materialized views
2. Tables
3. Standard views
4. Secure views - ANS 3
2 @COPYRIGHT THESTAR 2025/2026
,What is the Snowflake multi-clustering feature for virtual warehouses used for?
1. To speed up slow or stalled queries
2. To improve concurrency for users and queries
3. To improve the data unloading process to the cloud
4. To improve data loading from very large data sets - ANS 2
Which loop type iterates until a condition is true?
1. FOR
2. LOOP
3. WHILE
4. REPEAT - ANS 4
The three main Snowflake layers are...
1. Extraction, Load, Transformation.
2. Database, Virtual Warehouse, Metadata.
3. Centralized Storage, Compute & Cloud Services.
4. Staging, Data Warehouse, Dimensional. - ANS 3
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for?
(Choose two.)
Spark connector
GO driver
Python connector
Node.js driver
ODBC driver - ANS 3,5
3 @COPYRIGHT THESTAR 2025/2026
, A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the
following statements are true? (Choose two.)
1. The exact query will ALWAYS return the precomputed result set for the
RESULT_CACHE_ACTIVE = time period
2. Snowflake edition is Enterprise or higher
3. The same exact query will return the precomputed results even if the underlying data has
changed as long as the results were last accessed within the previous 24 hour period
4. The 24 hours timer on the precomputed results gets renewed every time the exact query is
executed
5. The same exact query will return the precomputed results if the underlying data hasn't
changed and the results were last accessed within previous 24 hour period - ANS 4,5
What can the Snowflake SCIM API be used to manage? (Choose two.)
1. Users
2. Roles
3. Network policies
4. Session policies
5. Integrations - ANS 1,2
You have two virtual warehouses in your Snowflake account. If one of them updates the data in
the storage layer, when will the other one see it?
1. After an average time of 5 seconds.
2. Once all the compute resources are provisioned for the second warehouse.
3. After the sync process.
4. Immediately. - ANS 4
What are the types of data consumer accounts available in Snowflake? (Choose two.)
1. Reader Account
2. Subscriber account
4 @COPYRIGHT THESTAR 2025/2026
2025 QUESTIONS AND ANSWERS
What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?
1. Convert the rows in a relational table to a single VARIANT column and then unload the rows
into a file.
2. Reorder the rows in a relational table and then unload the rows into a file.
3. Convert the rows in a source file to a single VARIANT column and then load the rows from
the file to a variant table.
4. Reorder the data columns according to a target table definition and then unload the rows
into the table. - ANS 1
By default, which Snowflake role is required to create a share?
1. SECURITYADMIN
2. ORGADMIN
3. SHAREADMIN
4. ACCOUNTADMIN - ANS 4
If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended
when:
1. The last query using the Warehouse completes.
2. All Snowflakes sessions using the Warehouse are terminated.
3. There are no users logged into Snowflake.
1 @COPYRIGHT THESTAR 2025/2026
,4. The Warehouse is inactive for a specified period of time. - ANS 4
Which of the following statements are true concerning the Snowflake release process? (Choose
three.)
1. A customer is assigned a 30 minute window (that can be moved anytime within a week)
during which the system will be unavailable and customer is upgraded
2. Snowflake deploys new Behavior change releases every month.
3. Snowflake deploys patch releases every week, but new feature releases happen once a
month.
4. Snowflake deploys new feature releases and releases every week.
5. There is usually some minimal downtime associated with Snowflake during the deployments.
6. It is possible for you as a user to request 24-hour early access to the upcoming releases so
that you can do additional release testing before the release is rolled out. - ANS 2,4,6
What are the available Snowflake scaling modes for configuring multi-cluster virtual
warehouses? (Choose two.)
1. Economy
2. Maximized
3. Scale-Out
4. Auto-Scale
5. Standard - ANS 2,4
Snowflake will return an error when a user attempts to share which object?
1. Secure materialized views
2. Tables
3. Standard views
4. Secure views - ANS 3
2 @COPYRIGHT THESTAR 2025/2026
,What is the Snowflake multi-clustering feature for virtual warehouses used for?
1. To speed up slow or stalled queries
2. To improve concurrency for users and queries
3. To improve the data unloading process to the cloud
4. To improve data loading from very large data sets - ANS 2
Which loop type iterates until a condition is true?
1. FOR
2. LOOP
3. WHILE
4. REPEAT - ANS 4
The three main Snowflake layers are...
1. Extraction, Load, Transformation.
2. Database, Virtual Warehouse, Metadata.
3. Centralized Storage, Compute & Cloud Services.
4. Staging, Data Warehouse, Dimensional. - ANS 3
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for?
(Choose two.)
Spark connector
GO driver
Python connector
Node.js driver
ODBC driver - ANS 3,5
3 @COPYRIGHT THESTAR 2025/2026
, A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the
following statements are true? (Choose two.)
1. The exact query will ALWAYS return the precomputed result set for the
RESULT_CACHE_ACTIVE = time period
2. Snowflake edition is Enterprise or higher
3. The same exact query will return the precomputed results even if the underlying data has
changed as long as the results were last accessed within the previous 24 hour period
4. The 24 hours timer on the precomputed results gets renewed every time the exact query is
executed
5. The same exact query will return the precomputed results if the underlying data hasn't
changed and the results were last accessed within previous 24 hour period - ANS 4,5
What can the Snowflake SCIM API be used to manage? (Choose two.)
1. Users
2. Roles
3. Network policies
4. Session policies
5. Integrations - ANS 1,2
You have two virtual warehouses in your Snowflake account. If one of them updates the data in
the storage layer, when will the other one see it?
1. After an average time of 5 seconds.
2. Once all the compute resources are provisioned for the second warehouse.
3. After the sync process.
4. Immediately. - ANS 4
What are the types of data consumer accounts available in Snowflake? (Choose two.)
1. Reader Account
2. Subscriber account
4 @COPYRIGHT THESTAR 2025/2026
