COF-C01

Which statement best describes Snowflake tables?A . Snowflake tables are logical representations of underlying physical dataB . Snowflake tables ate the physical instantiation of data loaded Into SnowflakeC . Snowflake tables require that clustering keys be defined to perform optimallyD . Snowflake tables are owned by a userView AnswerAnswer: A...

Which type of table corresponds to a single Snowflake session?A . TemporaryB . TranslentC . ProvisionalD . PermanentView AnswerAnswer: A

Which of the following statements are true about Schemas in Snowflake? (Choose two.)A . A Schema may contain one or more DatabasesB . A Database may contain one or more SchemasC . A Schema is a logical grouping of Database ObjectsD . Each Schema is contained within a WarehouseView AnswerAnswer:...

Account-level storage usage can be monitored via:A . The snowflake wet Interface (UI) in the Databases section.B . The Snowflake web interface (UI) in the Account -> Billing a usage sectionC . The Information Schema -> ACCOUNT_USAGE_HISTORY ViewD . The Account usage Schema - > ACCOUNT_USAGE_METRICS ViewView AnswerAnswer: D

True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.A . TrueB . FalseView AnswerAnswer: B

Which of the following commands sets the Virtual Warehouse for a session?A . COPT WAREHOUSE FROM <<Config file> ;B . SET warehouse = <<warehouse name>>;C . USE WAREHOUSE <<warehouse name>>;D . USE VIRTUAL_WAREHOUSE <<warehouse name>>;View AnswerAnswer: C Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

What is the most granular object that the Time Travel retention period can be defined on?A . AccountB . DatabaseC . SchemaD . TableView AnswerAnswer: D

Which of the following statements is true of data loading?A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fastB . The "deal file size for loading is 16MB to match micro-partition sizeC . Marry files in the 10-lOOMB range tend to land...

Which of the following commands are not blocking operations? Choose 2 answersA . UPDATEB . INSERTC . MERGED . COPYView AnswerAnswer: B,D

Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?A . Account -> Schema -> Database -> TableB . Account -> Database -> Schema -> TableC . Database -> Schema -> Table -> AccountD . Database -> Table -> Schema -> AccountView AnswerAnswer: B Explanation:...