Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1481:

  What does a masking policy consist of in Snowflake?

  A. A single data type, with one or more conditions, and one or more masking functions
  B. A single data type, with only one condition, and only one masking function
  C. Multiple data types, with only one condition, and one or more masking functions
  D. Multiple data types, with one or more conditions, and one or more masking functions
  A. A single data type, with one or more conditions, and one or more masking functions

  ---

  Explanation

  A masking policy consists of a single data type, one or more conditions, and one or more masking functions

• Question 1482:

  Why should a Snowflake user implement a secure view? (Choose two.)

  A. To store unstructured data
  B. To increase query performance
  C. To limit access to sensitive data
  D. To optimize query concurrency and queuing
  E. To hide view definition and details from unauthorized users
  C. To limit access to sensitive data
  E. To hide view definition and details from unauthorized users

  ---

  Explanation

• Question 1483:

  Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

  A. Query execution
  B. Data loading
  C. Time Travel data
  D. Security
  E. Authentication and access control
  D. Security
  E. Authentication and access control

  ---

  Explanation

  all the rest are not mentioned as a cloud services service https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

• Question 1484:

  Use of what parameter will allow files to be loaded even if the file metadata has expired?

  A. MATCH_BY_COLUMN_NAME = CASE_INSENSITIVE
  B. ENFORCE_LENGTH = TRUE
  C. PURGE = TRUE
  D. LOAD_UNCERTAIN_FILES = TRUE
  C. PURGE = TRUE

  ---

  Explanation

• Question 1485:

  Which transformation is supported by a COPY INTO [table] command?

  A. Filter using a WHERE clause
  B. Filter using a LIMIT keyword
  C. Cast using a SELECT statement
  D. Order using an ORDER BY Clause
  C. Cast using a SELECT statement

  ---

  Explanation

• Question 1486:

  Which of the following are options when creating a Virtual Warehouse?

  A. Auto-suspend
  B. Auto-resume
  C. Local SSD size
  D. User count
  A. Auto-suspend
  B. Auto-resume

  ---

  Explanation

• Question 1487:

  What does a Query Profile metric that shows excessive spillage indicate?

  A. Poor query optimization
  B. Expired temporary tables
  C. Improper virtual warehouse sizing
  D. Improper Common Table Expressions (CTEs)
  C. Improper virtual warehouse sizing

  ---

  Explanation

  Excessive spillage in the Query Profile indicates that intermediate query results are being written to remote storage (disk) instead of being processed in memory.

  This usually happens when:

  Solution:

  Increase the size of the virtual warehouse to provide more compute and memory resources.

  Why Other Options Are Incorrect:

  A. Poor query optimization: This could contribute, but spillage is primarily tied to resource constraints.

  B. Expired temporary tables: Temporary tables have no relation to spillage.

  D. Improper CTEs: The use of CTEs does not directly cause spillage.

  References:

  Query Profile and Performance

• Question 1488:

  Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

  A. CONTENT
  B. PATH
  C. BYTE_SIZE
  D. INDEX
  E. DATATYPE
  B. PATH
  D. INDEX

  ---

  Explanation

• Question 1489:

  What are the available Snowflake scaling modes for configuring multi-cluster virtual warehouses? (Choose two.)

  A. Auto-Scale
  B. Economy
  C. Maximized
  D. Scale-Out
  E. Standard
  A. Auto-Scale
  C. Maximized

  ---

  Explanation

• Question 1490:

  At which point is data encrypted when using a PUT command?

  A. When it reaches the virtual warehouse
  B. When it gets micro-partitioned
  C. Before it is sent from the user's machine
  D. After it reaches the internal stage
  C. Before it is sent from the user's machine

  ---

  Explanation