COF-R02 V1

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:A . The Pipe load history is reset to empty B. The REFRESH parameter is set to TRUE C. Previously loaded files will be ignored D. All of the aboveView AnswerAnswer: D Explanation: When a pipe is recreated using...

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Which of the following are options when creating a Virtual Warehouse?A . Auto-suspend B. Auto-resume C. Local SSD size D. User countView AnswerAnswer: A,B

True or False: An active warehouse is required to run a COPY INTO statement.A . True B. FalseView AnswerAnswer: A

True or False: Snowflake charges a premium for storing semi-structured data.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

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

How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution B. Querying (select) the size of the stream content...

Snowflake is designed for which type of workloads? (Choose two.)A . OLAP (Analytics) workloads B. OLTP (Transactional) workloads C. Concurrent workloads D. On-premise workloadsView AnswerAnswer: A,C Explanation: Reference: https://blog.couchbase.com/its-the-workload-stupid/ https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?A . To accommodate more queries B. To accommodate more users C. To accommodate fluctuations in workload D. To accommodate a more complex workloadView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/connecting.html