Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1091:

  Which Snowflake feature is used to track sensitive data to ensure compliance, identify data, and monitor resource usage?

  A. Data classification
  B. Data quality monitoring
  C. Object tagging
  D. Multi-Factor Authentication (MFA)
  B. Data quality monitoring

  ---

  Explanation

• Question 1092:

  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
  C. To split a string and flatten the results into rows

  ---

  Explanation

• Question 1093:

  What is the advantage of using a reader account?

  A. It can be used by a client that does not have a Snowflake account
  B. It is read-only and prevents the shared data from being updated by the provider.
  C. It can be connected to a Snowflake account in a different region.
  D. It provides limited access to the data share and is therefore cheaper for the data provider.
  A. It can be used by a client that does not have a Snowflake account

  ---

  Explanation

• Question 1094:

  A Snowflake user is writing a User-Defined Function (UDF) with some unqualified object names.

  How will those object names be resolved during execution?

  A. Snowflake will resolve them according to the SEARCH_PATH parameter.
  B. Snowflake will only check the schema the UDF belongs to.
  C. Snowflake will first check the current schema, and then the schema the previous query used.
  D. Snowflake will first check the current schema, and then the PUBLIC schema of the current database.
  B. Snowflake will only check the schema the UDF belongs to.

  ---

  Explanation

• Question 1095:

  Which of the following are options when creating a virtual Warehouse? (Choose two)

  A. Auto-drop
  B. Auto resize
  C. Auto-resume
  D. Auto-suspend
  C. Auto-resume
  D. Auto-suspend

  ---

  Explanation

  https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse https://www.analytics.today/blog/what-is-a-snowflake-virtual-warehouse

• Question 1096:

  What command would a user execute to load unstructured data files into a Snowflake internal stage?

  A. PUT
  B. GET
  C. LIST
  D. COPY INTO
  A. PUT

  ---

  Explanation

• Question 1097:

  Which roles can make grant decisions to objects within a managed access schema? (Choose two.)

  A. ACCOUNTADMIN
  B. SECURITYADMIN
  C. SYSADMIN
  D. ORGADMIN
  E. USERADMIN
  A. ACCOUNTADMIN
  B. SECURITYADMIN

  ---

  Explanation

• Question 1098:

  Which command would return an empty sample?

  A. select * from testtable sample ();
  B. select * from testtable sample (0);
  C. select * from testtable sample (null);
  D. select * from testtable sample (none);
  B. select * from testtable sample (0);

  ---

  Explanation

• Question 1099:

  Which view can be used to track the read and write operations that have been performed on a table?

  A. COPY_HISTORY
  B. ACCESS_HISTORY
  C. QUERY_HISTORY
  D. TASK_HISTORY
  B. ACCESS_HISTORY

  ---

  Explanation

• Question 1100:

  What step must be taken to ensure that a user can only access Snowsight from a specific location, or when working from home?

  A. Use a company Virtual Private Network (VPN) connection.
  B. Use Multi-Factor Authentication (MFA)
  C. Use Single Sign-On (SSO).
  D. Add the user's IP address to the network policy allowed list.
  D. Add the user's IP address to the network policy allowed list.

  ---

  Explanation

  To restrict access to Snowsight from a specific location, a network policy must be configured.

  The network policy allows only specific IP addresses (e.g., home or office networks) to access the Snowflake account.

  Example:

  CREATE NETWORK POLICY my_policy

  ALLOWED_IP_LIST = ('192.168.1.1', '203.0.113.0/24'); ALTER ACCOUNT SET NETWORK_POLICY = my_policy;

  References:

  Snowflake Documentation: Network Policies