COF-R02

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

True or False: A single database can exist in more than one Snowflake account.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

Which of the following DML commands isn’t supported by Snowflake?A . UPSERT B. MERGE C. UPDATE D. TRUNCATE TABLEView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

Which of the following objects can be cloned? (Choose four.)A . Tables B. Named File Formats C. Schemas D. Shares E. Databases F. UsersView AnswerAnswer: A,B,C,E Explanation: Which Objects Can Be Cloned? Data Containment Objects. Databases. Schemas. Tables. Streams. Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

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: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

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

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryption B. An HTTPS server with WebDAV C. A Google Cloud storage bucket D. A Windows server file share on AzureView AnswerAnswer: C

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)A . The validation_mode option is used when creating an Internal Stage B. validation_mode=return_all_errors is a parameter of the copy command C. The validation_mode option will validate data to be loaded by the copy statement while completing the...