COF-C01

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

Which of the following statements is true of Snowflake micro-partitioning?A . Micro-partitioning has been known to introduce data skewB . Micro-partitioning: requires a partitioning schema to be defined up frontC . Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loadedD . Micro-partitioning can be disabled...

The fail-safe retention period is how many days?A . 1 dayB . 7 daysC . 45 daysD . 90 daysView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

What is the maximum compressed row size in Snowflake?A . 8KBB . 16MBC . 50MBD . 4000GBView AnswerAnswer: B

Which statement best describes '' clustering''?A . Clustering represents the way data is grouped together and stored within snowflake's micro-partitionsB . 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 ....

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://acrotrend.com/snowflake-data-sharing/

Select the different types of Internal Stages: (Choose three.)A . Named StageB . User StageC . Table StageD . Schema StageView AnswerAnswer: A,B,C Explanation: Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.A . TrueB . FalseView AnswerAnswer: A

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

What is the recommended method for loading data into Snowflake?A . Load row by rowB . Load data in batchC . Load data by writing it In the Snowflake Web Interface (UI)D . Load data via frequent, angle row DML'sView AnswerAnswer: B