Snowflake SnowPro Core Exam 1
UPDATED ACTUAL QUESTIONS AND
CORRECT 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. - CORRECT ANSWER 1
By default, which Snowflake role is required to create a share?
1. SECURITYADMIN
2. ORGADMIN
3. SHAREADMIN
4. ACCOUNTADMIN - CORRECT ANSWER 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.
4. The Warehouse is inactive for a specified period of time. - CORRECT ANSWER 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. - CORRECT
ANSWER 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 - CORRECT ANSWER 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 - CORRECT ANSWER 3
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 - CORRECT ANSWER 2
,Which loop type iterates until a condition is true?
1. FOR
2. LOOP
3. WHILE
4. REPEAT - CORRECT ANSWER 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. - CORRECT ANSWER 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 - CORRECT ANSWER 3,5
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 - CORRECT
ANSWER 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 - CORRECT ANSWER 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. - CORRECT ANSWER 4
What are the types of data consumer accounts available in Snowflake? (Choose two.)
1. Reader Account
2. Subscriber account
3. Full Account
4. Public Account
5. Shared Account - CORRECT ANSWER 1,3
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
1. To accommodate more queries
2. To accommodate a more complex workload
3. To accommodate more users
4. To accommodate fluctuations in workload - CORRECT ANSWER 2
UPDATED ACTUAL QUESTIONS AND
CORRECT 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. - CORRECT ANSWER 1
By default, which Snowflake role is required to create a share?
1. SECURITYADMIN
2. ORGADMIN
3. SHAREADMIN
4. ACCOUNTADMIN - CORRECT ANSWER 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.
4. The Warehouse is inactive for a specified period of time. - CORRECT ANSWER 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. - CORRECT
ANSWER 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 - CORRECT ANSWER 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 - CORRECT ANSWER 3
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 - CORRECT ANSWER 2
,Which loop type iterates until a condition is true?
1. FOR
2. LOOP
3. WHILE
4. REPEAT - CORRECT ANSWER 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. - CORRECT ANSWER 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 - CORRECT ANSWER 3,5
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 - CORRECT
ANSWER 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 - CORRECT ANSWER 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. - CORRECT ANSWER 4
What are the types of data consumer accounts available in Snowflake? (Choose two.)
1. Reader Account
2. Subscriber account
3. Full Account
4. Public Account
5. Shared Account - CORRECT ANSWER 1,3
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
1. To accommodate more queries
2. To accommodate a more complex workload
3. To accommodate more users
4. To accommodate fluctuations in workload - CORRECT ANSWER 2
