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

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

A.Force an immediate password change.

B.Set the number of minutes to unlock to 15 minutes.

C.Set a default role for the user.

D.Set the user's access to expire within a specified timeframe.

E.Configure the user to be initially disabled.

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

A.Enterprise

B.Business Critical

C.Virtual Private Snowflake

D.Standard

Which command sets the Virtual Warehouse for a session?

A.COPY WAREHOUSE FROM <<config file>>;

B.USE WAREHOUSE <<warehouse name>>;

C.SET WAREHOUSE = <<warehouse name>>;

D.USE VIRTUAL_WAREHOUSE <<warehouse name>>;

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

A.Query execution

B.Authentication

C.Physical storage of micro-partitions

D.Query parsing and optimization

E.Resource management

F.Virtual warehouse caching

What are ways to create and manage data shares in Snowflake? (Select TWO)

A.Through the DATA_SHARE=TRUE parameter

B.Using the CREATE SHARE AS SELECT * TABLE command

C.Through SQL commands

D.Through the enable__share=true parameter

E.Through the Snowflake web interface (Ul)

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

Download PDF File