COF-C02 exam

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Which of the following commands cannot be used within a reader account?A . CREATE SHARE B. ALTER WAREHOUSE C. DROP ROLE D. SHOW SCHEMAS E. DESCRBE TABLEView AnswerAnswer: B Explanation: A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to...

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

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)A . ROLES B. POLICY_REFERENCES C. QUERY_HISTORY D. RESOURCE_MONIT ORS E. ACCESS_HISTORYView AnswerAnswer: B,C Explanation: https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%20POLICY-,Auditing%20Dynamic%20Data%20Masking,a%20masking%20policy%20is%20set.

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).A . The user has the appropriate privileges on the objects associated with the query B. Micro-partitions have been reclustered since the query was last run C. The new query is run...

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__SECONDS B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS C. MAX_CONCURRENCY__LEVEL D. 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...

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%20 use%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...

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?A . SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS; B. SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user()) C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY; D....