COF-C02

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 parameter C. Through SQL commands D. Through the enable__share=true parameter E. Using the CREATE SHARE AS SELECT * TABLE commandView AnswerAnswer: C,D

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)A . JDBC B. SnowSQL C. Snowflake Web Interface (UI) D. ODBC E. PythonView AnswerAnswer: A,B,C,D,E Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

Which of the following roles is recommended to be used to create and manage users and roles?A . SYSADMIN B. SECURITYADMIN C. PUBLIC D. ACCOUNTADMINView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse. According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).A . Use multi-clustered warehousing to scale out...

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?A . Yes, because a table owner has full control and can unset...

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):A . SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN C. SECURITYADMIN, ACCOUNTADMIN D. ACCOUNTADMINView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

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 parameter C. Via SQL commands D. Via Virtual WarehousesView AnswerAnswer: A,C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

What are value types that a VARIANT column can store? (Select TWO)A . STRUCT B. OBJECT C. BINARY D. ARRAY E. CLOBView AnswerAnswer: B,D Explanation: Characteristics of a VARIANT A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is...

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.A . True B. FalseView AnswerAnswer: A Explanation: Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

True or False: You can query the files in an External Stage directly without having to load the data into a table.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used...