COF-R02

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.A . True B. FalseView AnswerAnswer: A

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: A Explanation: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated,...

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answersA . On-premise availability B. Simplicity C. Open source based D. Concurrency E. PerformanceView AnswerAnswer: B,D,E

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

How a Snowpipe charges calculated?A . Per-second/per Warehouse size B. Per-second/per-core granularity C. Number of Pipes in account D. Total storage bucket sizeView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimum B. Credits are used to pay for cloud data storage usage C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs D. Credits are consumed...

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

Which type of table corresponds to a single Snowflake session?A . Temporary B. Translent C. Provisional D. PermanentView AnswerAnswer: A Explanation: Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist...

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/