Full Practice Set - [COF-C02] SnowPro Core
Certification Mock Exam - 1 – Results – Q&A
In what situations should you consider User-Managed Tasks over Serverless
Tasks? (Select 2) ✔️Ans - - Consider when you can fully utilize a single
warehouse by scheduling multiple concurrent resources
- Consider when adherence to the schedule interval is less import
Only the user who generated the scoped URL can use the URL to access the
referenced file. (True/False) ✔️Ans - - True
What will happen if a policy is assigned to a user who is already signed in?
✔️Ans - - The user can't do anything else until signed in and signed back in
again
Readers accounts enable providers to share data with consumers who are not
already Snowflake customers without requiring the consumers to become
Snowflake Customers. Which role can create the Reader account? ✔️Ans - -
ACCOUNTADMIN
Which of these types of VIEW does Snowflake support? (Select 3) ✔️Ans - -
Standard View
- Materialized View
- Secure View
Multi-cluster warehouses are beneficial in improving the performance of
slow-running queries or data loading. (True/False) ✔️Ans - - False
If an account has federated authentication enabled. Can Snowflake admins still
maintain user IDs and passwords in Snowflake? ✔️Ans - - Yes
The VALIDATION_MODE parameter does not support COPY statements that
transform data during a load. (True / False) ✔️Ans - - True
Which of these roles is dedicated to user and role management only? ✔️Ans
- - USERADMIN
, When deciding whether to suspend a warehouse or leave it running, what
should you consider? ✔️Ans - - Consider the trade-off between saving
credits by suspending the warehouse versus maintaining the cache of data
from the previous queries to help with performance
In which of the cloud platforms a Snowflake account can be hosted? (Select 3)
✔️Ans - - GCP
- AWS
- Azure
You can create an an account level network policy using _____ (Select all that
apply) ✔️Ans - - Snowsight
- SQL
- Classic Web Interface
What would happen if we suspend the warehouse while it is executing the SQL
statement? ✔️Ans - - Only idle compute resources of the warehouse will be
shut down, allowing any compute resources executing statements to continue
until the statement is complete
There are two modes to set up a multi-cluster warehouse. Select those from
the given choices. ✔️Ans - - Auto-scaling mode
- Maximized mode
File URL is ideal for ✔️Ans - - Custom applications that require access to
unstructured data files
What is the expiration period of a File URL? ✔️Ans - - It is Permanent
Which of the Snowflake editions provides a federated authorization feature?
✔️Ans - - All of the Snowflake Editions
A user cannot view the result set from a query that another user executed
except for the ACCOUNTADMIN role. (True / False) ✔️Ans - - False
Both external (external cloud storage) and internal (i.e., Snowflake) stages
support unstructured data. (True / False) ✔️Ans - - True
Certification Mock Exam - 1 – Results – Q&A
In what situations should you consider User-Managed Tasks over Serverless
Tasks? (Select 2) ✔️Ans - - Consider when you can fully utilize a single
warehouse by scheduling multiple concurrent resources
- Consider when adherence to the schedule interval is less import
Only the user who generated the scoped URL can use the URL to access the
referenced file. (True/False) ✔️Ans - - True
What will happen if a policy is assigned to a user who is already signed in?
✔️Ans - - The user can't do anything else until signed in and signed back in
again
Readers accounts enable providers to share data with consumers who are not
already Snowflake customers without requiring the consumers to become
Snowflake Customers. Which role can create the Reader account? ✔️Ans - -
ACCOUNTADMIN
Which of these types of VIEW does Snowflake support? (Select 3) ✔️Ans - -
Standard View
- Materialized View
- Secure View
Multi-cluster warehouses are beneficial in improving the performance of
slow-running queries or data loading. (True/False) ✔️Ans - - False
If an account has federated authentication enabled. Can Snowflake admins still
maintain user IDs and passwords in Snowflake? ✔️Ans - - Yes
The VALIDATION_MODE parameter does not support COPY statements that
transform data during a load. (True / False) ✔️Ans - - True
Which of these roles is dedicated to user and role management only? ✔️Ans
- - USERADMIN
, When deciding whether to suspend a warehouse or leave it running, what
should you consider? ✔️Ans - - Consider the trade-off between saving
credits by suspending the warehouse versus maintaining the cache of data
from the previous queries to help with performance
In which of the cloud platforms a Snowflake account can be hosted? (Select 3)
✔️Ans - - GCP
- AWS
- Azure
You can create an an account level network policy using _____ (Select all that
apply) ✔️Ans - - Snowsight
- SQL
- Classic Web Interface
What would happen if we suspend the warehouse while it is executing the SQL
statement? ✔️Ans - - Only idle compute resources of the warehouse will be
shut down, allowing any compute resources executing statements to continue
until the statement is complete
There are two modes to set up a multi-cluster warehouse. Select those from
the given choices. ✔️Ans - - Auto-scaling mode
- Maximized mode
File URL is ideal for ✔️Ans - - Custom applications that require access to
unstructured data files
What is the expiration period of a File URL? ✔️Ans - - It is Permanent
Which of the Snowflake editions provides a federated authorization feature?
✔️Ans - - All of the Snowflake Editions
A user cannot view the result set from a query that another user executed
except for the ACCOUNTADMIN role. (True / False) ✔️Ans - - False
Both external (external cloud storage) and internal (i.e., Snowflake) stages
support unstructured data. (True / False) ✔️Ans - - True
