Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 491:

  Which Snowflake layer is associated with virtual warehouses?

  A. Cloud services

  B. Query processing

  C. Elastic memory

  D. Database storage

  Correct Answer: B

• Question 492:

  Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?

  A. Only while in the ACCOUNTADMIN role

  B. Only while in the SECURITYADMIN role

  C. Only the role with the OWNERSHIP privilege on the network policy

  D. Only Snowflake Support can set the value for this object property

  Correct Answer: D

• Question 493:

  What authentication method does the Kafka connector use within Snowflake?

  A. Key pair authentication

  B. Multi-Factor Authentication (MFA)

  C. OAuth

  D. Username and password

  Correct Answer: A

• Question 494:

  What is the purpose of the Snowflake SPLIT_TO_TABLE function?

  A. To count the number of characters in a string

  B. To split a string into an array of sub-strings

  C. To split a string and flatten the results into rows

  D. To split a string and flatten the results into columns

  Correct Answer: C

• Question 495:

  What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

  A. Access control

  B. Fail-safe

  C. Network policies

  D. Time Travel

  Correct Answer: D

• Question 496:

  What aspect of an executed query is represented by the remote disk I/O statistic of the Query Profile in Snowflake?

  A. Time spent scanning the table partitions to filter data based on the predicate

  B. Time spent caching the data to remote storage in order to buffer the data being extracted and exported

  C. Time spent reading and writing data from and to remote storage when the data being accessed does not fit into the executing virtual warehouse node memory

  D. Time spent reading and writing data from and to remote storage when the data being accessed does not fit into either the virtual warehouse memory or the local disk

  Correct Answer: D

• Question 497:

  What is generally the FASTEST way to bulk load data files from a stage?

  A. Specifying a list of specific files to load

  B. Loading by path (internal stages) / prefix

  C. Using the Snowpipe REST API

  D. Using pattern matching to identify specific files by pattern

  Correct Answer: A

• Question 498:

  What action can a user take to address query concurrency issues?

  A. Enable the search optimization service.

  B. Enable the query acceleration service.

  C. Add additional clusters to the virtual warehouse.

  D. Resize the virtual warehouse to a larger instance size.

  Correct Answer: C

• Question 499:

  What does the client redirect feature in Snowflake enable?

  A. A redirect of client connections to Snowflake accounts in the same regions for business continuity.

  B. A redirect of client connections to Snowflake accounts in different regions for business continuity.

  C. A redirect of client connections to Snowflake accounts in different regions for data replication.

  D. A redirect of client connections to Snowflake accounts in the same regions for data replication.

  Correct Answer: B

• Question 500:

  Which URL provides access to files in Snowflake without authorization?

  A. File URL

  B. Scoped URL

  C. Pre-signed URL

  D. Scoped file URL

  Correct Answer: C