Free Access Snowflake.COF-C02.v2023-02-20.q85 Practice Test (Page 5)

Question 16

What is the purpose of multi-cluster virtual warehouses?

A.To create separate data warehouses to increase query optimization

B.To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

C.To eliminate or reduce Queuing of concurrent queries

D.To allow the warehouse to resize automatically

Question 17

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 JOIN

Question 18

What happens when an external or an internal stage is dropped? (Select TWO).

A.When dropping an external stage, the files are not removed and only the stage is dropped

B.When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

C.When dropping an external stage, both the stage and the files within the stage are removed

D.When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

E.When dropping an internal stage, the files are deleted with the stage and the files are recoverable

Question 19

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 days

Question 20

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

A.Contact Snowflake Support to have the data retrieved from Fail-safe storage.

B.Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

C.Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

D.The transient table version cannot be retrieved after 24 hours.

Other Version: 765Snowflake.COF-C02.v2025-06-30.q512; 1077Snowflake.COF-C02.v2023-09-01.q136

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 156TheSecOpsGroup.CNSP.v2025-09-08.q20; 207CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 144Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 177Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File