COF-C02 exam

Which Snowflake partner specializes in data catalog solutions?A . Alation B. DataRobot C. dbt D. TableauView AnswerAnswer: A Explanation: Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise. https://docs.snowflake.com/en/user-guide/ecosystem-all.html

What is a best practice after creating a custom role?A . Create the custom role using the SYSADMIN role. B. Assign the custom role to the SYSADMIN role C. Assign the custom role to the PUBLIC role D. Add__CUSTOM to all custom role namesView AnswerAnswer: B Explanation: When creating roles...

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...