COF-C02 exam

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

Which command is used to unload data from a Snowflake table into a file in a stage?A . COPY INTOB . GETC . WRITED . EXTRACT INTOView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query timeB . Partitions scanned is equal to partitions totalC . An Aggregate Operacor node is presentD . The...