COF-C01

When can a Virtual Warehouse start running queries?A . 12am-5amB . Only during administrator defined time slotsC . When its provisioning is completeD . After replicationView AnswerAnswer: C

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 . COPYC . SUM(<< column value >>)D . UPDATEView AnswerAnswer: B,C,D

Select the three types of tables that exist within Snowflake. Choose 3 answersA . TemporaryB . TransientC . ProvisionedD . PermanentView AnswerAnswer: A,B,D Explanation: Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

True or False: Snowpipe via RFST API can only reference External Stages as source.A . TrueB . FalseView AnswerAnswer: A

Which of the following statements is true of Snowflake?A . It was built specifically for the cloudB . It was built as an on-premises solution and then ported to the cloudC . It was designed as a hybrid database to allow customers to store data either on premises or in...

When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.A . The Pipe load history is reset to emptyB . The REFRESH parameter is set to TRUEC . Previously loaded files will be ignoredD . All of the aboveView AnswerAnswer: A

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

What happens when a Data Provider revokes privileges to a Share on an object in their source database?A . The object immediately becomes unavailable for all Data ConsumersB . Any additional data arriving after this point in time will not be visible to Data ConsumersC . The Data Consumers stop...

Which of the following statements about data sharing are true? choose 2 answersA . New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader AccountsB . All database objects can be included In a shared databaseC . Reader Accounts are created and funded by...

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