COF-C02

How long is Snowpipe data load history retained?A . As configured in the create pipe settings B. Until the pipe is dropped C. 64 days D. 14 daysView AnswerAnswer: C Explanation: Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the...

What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMIN B. ORGADMIN C. SECURITYADMIN D. SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.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 statement best describes '' clustering''?A . Clustering represents the way data is grouped together and stored within snowflake's micro-partitions B. The database administrator must define the clustering methodology for each Snowflake table. C. The clustering key must be included on the COPV command when loading data into Snowflake. D....

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

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answersA . MIN(< < column value>>) B. COPY C. SUM(<< column value >>) D. UPDATEView AnswerAnswer: B,C,D

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?A . 1 Hour B. 3 Hours C. 12 hours D. 24 hoursView AnswerAnswer: D Explanation: Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

The FLATEEN function is used to query which type of data in Snowflake?A . Structured data B. Semi-structured data C. Both of the above D. None of the aboveView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by...

How many shares can be consumed by single Data Consumer?A . 1 B. 10 C. 100, but can be increased by contacting support D. UnlimitedView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

What is a limitation of a Materialized View?A . A Materialized View cannot support any aggregate functions B. A Materialized View can only reference up to two tables C. A Materialized View cannot be joined with other tables D. A Materialized View cannot be defined with a JOINView AnswerAnswer: D...