Tag - COF-R02 exam

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)A . SCIM B. Federated authentication C. TLS 1.2 D. Key-pair authentication E. OAuth F. OCSP authenticationView AnswerAnswer: B,D,E

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"

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.A . True B. FalseView AnswerAnswer: A

True or False: During data unloading, only JSON and CSV files can be compressed.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

Which of the following statements are true of Snowflake releases: (Choose two.)A . They happen approximately weekly B. They roll up and release approximately monthly, but customers can request early release application C. During a release, new customer requests/queries/connections transparently move over to the newer version D. A customer is...

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.A . True B. FalseView AnswerAnswer: B Explanation: When a new Snowflake object is created, it is not automatically owned by the user who created it. Instead, the object is owned...

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.A . True B. FalseView AnswerAnswer: B

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)A . Customers can change the size of the Warehouse after creation B. A Warehouse can be resized while running C. A Warehouse can be configured to suspend after a period of inactivity D. A Warehouse can...

True or False: The COPY command must specify a File Format in order to execute.A . True B. FalseView AnswerAnswer: B Explanation: Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.htmlCopy Into: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html