COF-C02 exam

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).A . Internal stages B. Incremental backups C. Time Travel D. Zero-copy clones E. Fail-safeView AnswerAnswer: CE Explanation: Time travel and fail safe are the two continuous data protection features support the recovery of data automatically. Snowflake provides...

Which data type can be used to store geospatial data in Snowflake?A . Variant B. Object C. Geometry D. GeographyView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?A . Pipes B. Streams C. Tasks D. ProceduresView AnswerAnswer: B Explanation: https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20ch ange.

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)A . Customer-managed encryption keys through Tri-Secret Secure B. Automatic encryption of all data C. Up to 90 days of data recovery through Time Travel D. Object-level access control E. Column-level security to apply data masking policies...

In which use cases does Snowflake apply egress charges?A . Data sharing within a specific region B. Query result retrieval C. Database replication D. Loading data into SnowflakeView AnswerAnswer: BC

True or False: Fail-safe can be disabled within a Snowflake account.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach....

What is the default character set used when loading CSV files into Snowflake?A . UTF-8 B. UTF-16 C. ISO S859-1 D. ANSI_X3.AView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for% 20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the...

How often are encryption keys automatically rotated by Snowflake?A . 30 Days B. 60 Days C. 90 Days D. 365 DaysView AnswerAnswer: C

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?A . The primary cluster in the virtual warehouse B. The entire virtual warehouse C. The database in which the virtual warehouse resides D. The Queries currently being run on the virtual warehouseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters %20in%20the%20warehouse.