COF-C02 V4

Which Snowflake partner specializes in data catalog solutions?A . AlationB . DataRobotC . dbtD . 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

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)A . SCIMB . Federated authenticationC . TLS 1.2D . Key-pair authenticationE . OAuthF . OCSP authenticationView AnswerAnswer: B, D, E

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

What features does Snowflake Time Travel enable?A . Querying data-related objects that were created within the past 365 daysB . Restoring data-related objects that have been deleted within the past 90 daysC . Conducting point-in-time analysis for Bl reportingD . Analyzing data usage/manipulation over all periods of timeView AnswerAnswer: B...

Which Snowflake feature is used for both querying and restoring data?A . Cluster keysB . Time TravelC . Fail-safeD . CloningView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.

How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of executionB . Querying (select) the size of the stream content...

Which feature is only available in the Enterprise or higher editions of Snowflake?A . Column-level securityB . SOC 2 type II certificationC . Multi-factor Authentication (MFA)D . Object-level access controlView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/intro-editions.html

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?A . Okta VerifyB . Duo MobileC...

True or False: Fail-safe can be disabled within a Snowflake account.A . TrueB . 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 are two ways to create and manage Data Shares in Snowflake? (Choose two.)A . Via the Snowflake Web Interface (Ul)B . Via the data_share=true parameterC . Via SQL commandsD . Via Virtual WarehousesView AnswerAnswer: AC Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html