COF-C02 exam

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).A . Internal stagesB . Incremental backupsC . Time TravelD . Zero-copy clonesE . Fail-safeView AnswerAnswer: C, E Explanation: Snowflake’s Continuous Data Protection (CDP) encompasses a set of features that help protect data stored in Snowflake against human...

In which use cases does Snowflake apply egress charges?A . Data sharing within a specific regionB . Query result retrievalC . Database replicationD . Loading data into SnowflakeView AnswerAnswer: C Explanation: Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region...

Which stage type can be altered and dropped?A . Database stageB . External stageC . Table stageD . User stageView AnswerAnswer: B Explanation: External stages can be altered and dropped in Snowflake. An external stage points to an external location, such as an S3 bucket, where data files are stored....

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)A . Customer-managed encryption keys through Tri-Secret SecureB . Automatic encryption of all dataC . Up to 90 days of data recovery through Time TravelD . Object-level access controlE . Column-level security to apply data masking policies...

User-level network policies can be created by which of the following roles? (Select TWO).A . ROLEADMINB . ACCOUNTADMINC . SYSADMIND . SECURITYADMINE . USERADMINView AnswerAnswer: B, D Explanation: User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN...

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;B . GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;C . GRANT MODIFY...

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?A . STATEMENT_TIMEOUT__IN__SECONDSB . STATEMENT_QUEUED_TIMEOUT_IN_SECONDSC . MAX_CONCURRENCY__LEVELD . QUERY_TIMEOUT_IN_SECONDSView AnswerAnswer: B Explanation: The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get...

Will data cached in a warehouse be lost when the warehouse is resized?A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.B . Yes. because the compute resource is replaced in its entirety with a new compute resource.C . No. because the...

What are the default Time Travel and Fail-safe retention periods for transient tables?A . Time Travel - 1 day. Fail-safe - 1 dayB . Time Travel - 0 days. Fail-safe - 1 dayC . Time Travel - 1 day. Fail-safe - 0 daysD . Transient tables are retained in neither...

What happens when a cloned table is replicated to a secondary database? (Select TWO)A . A read-only copy of the cloned tables is stored.B . The replication will not be successful.C . The physical data is replicatedD . Additional costs for storage are charged to a secondary accountE . Metadata...