COF-C02 V4

When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the queryB . When another user executes the queryC . When the underlying data has changedD . When the warehouse used to execute the query is suspendedE . When it has...

Which command can be used to stage local files from which Snowflake interface?A . SnowSQLB . Snowflake classic web interface (Ul)C . SnowsightD . .NET driverView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/snowsql-use.html

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)A . ROLESB . POLICY_REFERENCESC . QUERY_HISTORYD . RESOURCE_MONIT ORSE . ACCESS_HISTORYView AnswerAnswer: BE

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

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . TrueB . FalseView AnswerAnswer: A Explanation: You can experiment the same with snowflake UI.

What are ways to create and manage data shares in Snowflake? (Select TWO)A . Through the Snowflake web interface (Ul)B . Through the DATA_SHARE=TRUE parameterC . Through SQL commandsD . Through the enable__share=true parameterE . Using the CREATE SHARE AS SELECT * TABLE commandView AnswerAnswer: A C

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?A . Create a zero-copy clone of the worksheet and grant permissions to teammatesB . Create a private Data Exchange so that any teammate can use the worksheetC...

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

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: BC

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 queryB . Micro-partitions have been reclustered since the query was last runC . The new query is run...