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

Question 66

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

A.24 minutes

B.14 minutes

C.4 minutes

D.10 minutes

Question 67

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

A.Standard

B.Premium

C.Enterprise

D.Business Critical

Question 68

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A.Each Snowflake account can be hosted in a different cloud vendor and region.

B.Each Snowflake account must be hosted in a different cloud vendor and region

C.All Snowflake accounts must be hosted in the same cloud vendor and region

D.Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Question 69

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

A.The ACCOUNTADMIN role must be granted to only one user.

B.All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

C.Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

D.All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

E.Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

Question 70

How would a user run a multi-cluster warehouse in maximized mode?

A.Set the minimum Clusters and maximum Clusters settings to the same value.

B.Turn on the additional clusters manually after starting the warehouse.

C.Set the minimum clusters and maximum clusters settings to different values.

D.Configure the maximum clusters setting to "Maximum."

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

Latest Upload: 101OCEG.GRCP.v2025-09-11.q211; 101HP.HPE0-V27.v2025-09-11.q78; 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 156PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 140Adobe.AD0-E605.v2025-09-05.q50

Question 66

Question 67

Question 68

Question 69

Question 70

Download PDF File