Which object types are protected by Fail-safe? (Choose two.)
A. Permanent Tables
B. Temporary Tables
C. External Tables
D. Materialized Views
E. Transient Tables
What is the purpose of enabling Federated Authentication on a Snowflake account?
A. Disables the ability to use key pair and basic authentication (e.g., username/password) when connecting
B. Allows dual Multi-Factor Authentication (MFA) when connecting to Snowflake
C. Forces users to connect through a secure network proxy
D. Allows users to connect using secure single sign-on (SSO) through an external identity provider
Which schema has the RESOURCE_MONITORS view?
A. ACCOUNT_USAGE
B. READER_ACCOUNT_USAGE
C. INFORMATION_SCHEMA
D. WAREHOUSE_USAGE_SCHEMA
What is the default Time Travel retention period?
A. 1 day
B. 7 days
C. 45 days
D. 90 days
According to Snowflake best practice recommendations, which role should be used to create databases?
A. ACCOUNTADMIN
B. SYSADMIN
C. SECURITYADMIN
D. USERADMIN
Snowflake's approach to the management of system access combines which of the following models? (Choose two.)
A. Security Assertion Markup Language (SAML)
B. Role-Based Access Control (RBAC)
C. Identity Access Management (AM)
D. Create, Read, Update, and Delete (CRUD)
E. Discretionary Access Control (DAC)
F. Mandatory Access Control (MAC)
To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)
A. The MODIFY privilege on the table
B. The OWNERSHIP privilege on the table
C. A SECURITYADMIN role
D. The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
E. The SELECT privilege on the table
When can a newly configured virtual warehouse start running SQL queries?
A. After 50% of the warehouse provisioning has completed
B. During the time slots defined by the ACCOUNTADMIN
C. When the warehouse provisioning is completed
D. After the warehouse replication is completed
What are the benefits of the replication feature in Snowflake? (Choose two.)
A. Disaster recovery
B. Time Travel
C. Fail-safe
D. Database failover and failback
E. Data security
What is used to limit the credit usage of a virtual warehouse within a Snowflake account?
A. Load monitor
B. Resource monitor
C. Query Profile
D. Stream
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.