Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1651:

  In a SPLIT_PART function, what will the returned value be if the partNumber is out of range?

  A. -1
  B. An empty string
  C. The full string
  D. An error
  B. An empty string

  ---

  Explanation

  The SPLIT_PART function splits a string into parts using a delimiter and returns the specified part based on its position (partNumber). If the partNumber is out of range, the function returns an empty string.

  Example:

  SELECT SPLIT_PART('a,b,c', ',', 5); -- Returns '' Why Other Options Are Incorrect:

  A. -1: Not returned by the function.

  C. The full string: The function returns only a specific part or an empty string, not the full string.

  D. An error: Out-of-range values do not cause errors in SPLIT_PART.

  References:

  SPLIT_PART Function Documentation

• Question 1652:

  Which statement about data sharing is true?

  A. Accounts can share with other accounts regardless of their Snowflake edition, without requiring help from Snowflake Support.
  B. Data sharing can cross regions, but not cloud providers.
  C. The Data Consumer can only see objects in the Data Provider's source database that have been explicitly added to the share.
  D. A Data Provider can only share with other Snowflake customers.
  C. The Data Consumer can only see objects in the Data Provider's source database that have been explicitly added to the share.

  ---

  Explanation

• Question 1653:

  Which command should be used when loading many flat files into a single table?

  A. PUT
  B. INSERT
  C. COPY INTO
  D. MERGE
  C. COPY INTO

  ---

  Explanation

• Question 1654:

  Loading data into Snowflake requires that source data files be no larger than 16MB.

  A. True
  B. False
  B. False

  ---

  Explanation

  By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.

• Question 1655:

  During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

  A. STATEMENT_TIMEOUT__IN__SECONDS
  B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
  C. MAX_CONCURRENCY__LEVEL
  D. QUERY_TIMEOUT_IN_SECONDS
  B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  ---

  Explanation

  The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter% 20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

• Question 1656:

  How is Single Sign-On (SSO) authentication used in Snowflake?

  A. SSO is an authentication method which uses a pair of keys, a public key and a private key. to verify the identity of a user.
  B. SSO is an authentication method that uses a username and password in the API request header.
  C. SSO is an authentication method that allows a user to sign into multiple applications with a single set of credentials.
  D. SSO is an integrated Snowflake feature, powered by the Duo Security service, which is managed completely by Snowflake.
  C. SSO is an authentication method that allows a user to sign into multiple applications with a single set of credentials.

  ---

  Explanation

  Single Sign-On (SSO) allows users to authenticate once using their organization's identity provider (IdP) and access multiple applications, including Snowflake, without needing to re-enter credentials.

  SSO in Snowflake is implemented via SAML 2.0, integrating with external IdPs such as Okta, Azure AD, or Ping Identity.

  This improves security and simplifies user management.

  References:

  Snowflake Documentation: Federated Authentication and SSO Snowflake Security Overview

• Question 1657:

  What activities can a user with the ORGADMIN role perform? (Choose two.)

  A. Create an account for an organization.
  B. Edit the account data for an organization.
  C. Delete the account data for an organization.
  D. View usage information for all accounts in an organization.
  E. Select all the data in tables for all accounts in an organization.
  A. Create an account for an organization.
  D. View usage information for all accounts in an organization.

  ---

  Explanation

  A user with the ORGADMIN role can perform the following actions:

  Creating an Account.

  View/show all accounts in the Organization.

  Viewing a List of Regions Available for an Organization.

  View usage information for all accounts in the organization.

  Enable database replication for an account in the organization.

  Note: Once an account is created, ORGADMIN can view the account properties but does not have access to the account data.

  https://docs.snowflake.com/en/user-guide/organizations#orgadmin-role

• Question 1658:

  Which COPY INTO statement accurately describes how to unload data from a Snowflake table?

  A. The default value for the SINGLE option is set to TRUE.
  B. By default, COPY INTO statements do not separate table data into a set of output files.
  C. The OBJECT_CONSTRUCT function can be combined with the COPY command to convert the rows in a relational table to a single VARIANT column.
  D. If the COMPRESSION option is set to TRUE, a file's name can be specified with the appropriate file extension so that the output file can be compressed.
  C. The OBJECT_CONSTRUCT function can be combined with the COPY command to convert the rows in a relational table to a single VARIANT column.

  ---

  Explanation

• Question 1659:

  Which table type has a Fail-safe period of 7 days?

  A. Temporary table
  B. Transient table
  C. Permanent table
  D. External table
  C. Permanent table

  ---

  Explanation

• Question 1660:

  What metadata does Snowflake store for rows in micro-partitions? (Choose two.)

  A. Range of values
  B. Distinct values
  C. Index values
  D. Sorted values
  E. Null values
  A. Range of values
  B. Distinct values

  ---

  Explanation