Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 121:

  What kind of value does a User-Defined Function (UDF) return? (Select TWO).

  A. Dictionary
  B. List
  C. Object
  D. Scalar
  E. Tabular
  D. Scalar
  E. Tabular

  ---

  Explanation

  Snowflake User-Defined Functions (UDFs) allow users to define custom functions that can return specific types of values. The two types of values a UDF can return are Scalar and Tabular, depending on its implementation and use case. Here's a detailed Scalar UDF CREATE OR REPLACE FUNCTION multiply_by_two(val INT) RETURNS INT LANGUAGE SQL AS 'val * 2'; uk.co.certification.simulator.questionpool.PList@3646d680 SELECT multiply_by_two(4); -- Output: 8 Tabular UDF CREATE OR REPLACE FUNCTION get_filtered_table(val INT) RETURNS TABLE (col1 INT, col2 STRING) LANGUAGE SQL AS ' SELECT col1, col2 FROM my_table WHERE col1 > val '; uk.co.certification.simulator.questionpool.PList@9a587e4 SELECT * FROM TABLE(get_filtered_table(10)); Key Points about UDF Return Values: UDFs do not return Python objects like dictionaries (Dictionary) or lists (List) directly because Snowflake operates in a SQL-based environment. UDFs also cannot return arbitrary objects (Object) in the sense of programming object-oriented paradigms. The two valid return types supported by UDFs are Scalar and Tabular, making them highly flexible for database-specific operations.

  References: Snowflake Documentation: User-Defined Functions Snowflake Documentation: Table Functions Snowflake UDF Best Practices

• Question 122:

  What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

  A. The type of SQL statements executed
  B. The number of tables or databases queried
  C. The amount of data stored in the warehouse
  D. The length of time the compute resources in each cluster run
  D. The length of time the compute resources in each cluster run

  ---

  Explanation

• Question 123:

  Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

  A. Fail-safe
  B. Network policies
  C. End-to-end encryption
  D. Multi-Factor Authentication (MFA)
  A. Fail-safe

  ---

  Explanation

• Question 124:

  What is the primary purpose of a directory table in Snowflake?

  A. To store actual data from external stages
  B. To automatically expire file URLs for security
  C. To manage user privileges and access control
  D. To store file-level metadata about data files in a stage
  D. To store file-level metadata about data files in a stage

  ---

  Explanation

• Question 125:

  A stream can be created on which Snowflake objects to record data manipulation language (DML) changes? (Choose two.)

  A. Databases
  B. Standard tables
  C. Standard views
  D. Schemas
  E. Pipes
  B. Standard tables
  C. Standard views

  ---

  Explanation

• Question 126:

  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
  D. Time Travel

  ---

  Explanation

• Question 127:

  Which ACCOUNT_USAGE view will identify long-running queries?

  A. DATA_TRANSFER_HISTORY
  B. TASK_HISTORY
  C. QUERY_HISTORY
  D. METERING_DAILY_HISTORY
  C. QUERY_HISTORY

  ---

  Explanation

• Question 128:

  What can a reader account user do when accessing shared data? (Choose two.)

  A. Insert new data using the COPY INTO command.
  B. Execute secure User-De ned Functions (UDFs).
  C. Remove records using the DELETE command.
  D. Select data from secure views.
  E. Modify records using the UPDATE and MERGE commands.
  B. Execute secure User-De ned Functions (UDFs).
  D. Select data from secure views.

  ---

  Explanation

• Question 129:

  What is required to set a stored procedure to EXECUTE AS? (Select TWO).

  A. ACCOUNTADMIN role
  B. SCHEMA_USER
  C. Owner's rights
  D. Caller's rights
  E. USER
  C. Owner's rights
  D. Caller's rights

  ---

  Explanation

• Question 130:

  Which access control entity in Snowflake can be created as part of a hierarchy within an account?

  A. Securable object
  B. Role
  C. Privilege
  D. User
  B. Role

  ---

  Explanation