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

Question 11

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?

A.GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B.ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

C.GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

D.GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Question 12

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A.STRIP_NULL_VALUES

B.SKIP_BYTE_ORDER_MARK

C.REPLACE_INVALID_CHARACTERS

D.VALIDATION_MODE

Question 13

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A.The query is spilling to remote storage

B.Partitions scanned is equal to partitions total

C.An AggregateOperacor node is present

D.A single join node uses more than 50% of the query time

Question 14

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

A.Execute a COPY command

B.Snowpipe

C.AUTOMATIC__CLUSTERING

D.Updating data

E.Scaling up a warehouse

Question 15

True or False: A Virtual Warehouse can be resized while suspended.

A.False

B.True

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 11

Question 12

Question 13

Question 14

Question 15

Download PDF File