COF-R02 V1

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:A . Configure the Maximum Clusters setting to “Auto-Scale” B. Set the Warehouse type to “Auto” C. Set the Minimum Clusters and Maximum Clusters settings to the same value D. Set the Minimum Clusters and Maximum Clusters settings to the...

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?A . 4 B. 16 C. 32 D. 128View AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

What features does Snowflake Time Travel enable?A . Querying data-related objects that were created within the past 365 days B. Restoring data-related objects that have been deleted within the past 90 days C. Conducting point-in-time analysis for Bl reporting D. Analyzing data usage/manipulation over all periods of timeView AnswerAnswer: C...

Which of the following objects is not covered by Time Travel?A . Tables B. Schemas C. Databases D. StagesView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?A . It removes the last element of the outer array. B. It removes the outer array structure and loads...

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)A . Growth of storage and compute are tightly coupled together B. Storage expands without the requirement to add more compute C. Compute can be scaled up or down without the requirement...

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

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . True B. FalseView AnswerAnswer: B Explanation: It is not possible to unload structured data directly to semi-structured formats such as JSON and Parquet using Snowflake's native functionality. Snowflake's COPY INTO statement,...

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?A . Create a task that runs a copy into operation from an external stage every 5 minutes B. Create...