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

Question 31

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A.Removing a column from the query SELECT list

B.Clustering of the data used by the query

C.Changing a column that is not in the cached query

D.Executing the RESULTS_SCAN() table function

E.Stopping the virtual warehouse that the query is running against

Question 32

Users are responsible for data storage costs until what occurs?

A.Data expires from Time Travel

B.Data is deleted from a table

C.Data expires from Fail-safe

D.Data is truncated from a table

Question 33

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

A.Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

B.Produce the largest files possible, reducing the overall number of files to process.

C.Use auto-ingest Snowpipes to load large files in a serverless model.

D.Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

Question 34

Which of the following are benefits of micro-partitioning? (Select TWO)

A.Micro-partitions cannot overlap in their range of values

B.Micro-partitions are immutable objects that support the use of Time Travel.

C.Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

D.Rows are automatically stored in sorted order within micro-partitions

E.Micro-partitions can be defined on a schema-by-schema basis

Question 35

When should a multi-cluster warehouse be used in auto-scaling mode?

A.When a large number of concurrent queries are run on the same warehouse

B.If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C.When it is unknown how much compute power is needed

D.If the runtime of the executed query is very slow

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 31

Question 32

Question 33

Question 34

Question 35

Download PDF File