Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 261:

  When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

  A. USAGE on the specific tables in the database.

  B. USAGE on the specific tables in the database.

  C. MODIFY on 1Mb specific tables in the database.

  D. USAGE on the database and the schema containing the tables to share

  E. OPEBATE on the database and the schema containing the tables to share.

  Correct Answer: CD

• Question 262:

  A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?

  A. The file will continue to load until all contents arc loaded.

  B. The tile will slop loading and all data up to that point will be committed.

  C. The file loading could be aborted without any portion of the file being committed.

  D. The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake

  Correct Answer: C

• Question 263:

  How can a user get the MOST detailed information about individual table storage details in Snowflake?

  A. SHOW TABLES command

  B. SHOW EXTERNAL TABLES command

  C. TABLES view

  D. TABLE STORAGE METRICS view

  Correct Answer: D

• Question 264:

  How are network policies defined in Snowflake?

  A. They are a set of rules that define the network routes within Snowflake.

  B. They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

  C. They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

  D. They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect to Snowflake.

  Correct Answer: D

• Question 265:

  Which Snowflake objects can be restored using Time Travel? (Select VNO).

  A. Roles

  B. Users

  C. Databases

  D. Schemas

  E. Virtual warehouses

  Correct Answer: CD

• Question 266:

  Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

  A. ACCOUNTADMIN

  B. SECURITYADMIN

  C. SYSADMIN

  D. ORGADMIN

  Correct Answer: A

• Question 267:

  Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

  A. The column name and element names are both case-sensitive.

  B. The column name and element names are both case-insensitive.

  C. The column name is case-sensitive but element names are case-insensitive.

  D. The column name is case-insensitive but element names are case-sensitive.

  Correct Answer: D

• Question 268:

  If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

  A. 60

  B. 91

  C. 120

  D. 121

  Correct Answer: C

• Question 269:

  How does Snowflake describe its unique architecture?

  A. A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)

  B. A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

  C. A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)

  D. A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

  Correct Answer: B

• Question 270:

  Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?

  A. External

  B. Permanent

  C. Temporary

  D. Transient

  Correct Answer: D