Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1251:

  Fail-safe can be disabled within a Snowflake account.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-failsafe.html

  Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

• Question 1252:

  How should a Snowflake user access a third-party SaaS service to process unstructured data?

  A. Use internal functions.
  B. Use external functions.
  C. Use process functions.
  D. Use an API gateway.
  D. Use an API gateway.

  ---

  Explanation

• Question 1253:

  What is a key feature of Snowflake architecture?

  A. Zero-copy cloning creates a mirror copy of a database that updates with the original
  B. Software updates are automatically applied on a quarterly basis
  C. Snowflake eliminates resource contention with its virtual warehouse implementation
  D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
  E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
  C. Snowflake eliminates resource contention with its virtual warehouse implementation

  ---

  Explanation

• Question 1254:

  What is the MAXIMUM number of days that Snowflake resets the 24-hour retention period for a query result every time the result is used?

  A. 1 day
  B. 10 days
  C. 31 days
  D. 60 days
  C. 31 days

  ---

  Explanation

• Question 1255:

  Which of the following statements describes a benefit of Snowflake's separation of compute and storage?

  A. Growth of storage and compute are tightly coupled together
  B. Storage expands without the requirement to add more compute
  C. Compute can be scaled up or down without the requirement to add more storage
  D. Multiple compute clusters can access stored data without contention
  B. Storage expands without the requirement to add more compute
  C. Compute can be scaled up or down without the requirement to add more storage
  D. Multiple compute clusters can access stored data without contention

  ---

  Explanation

  https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt-separate-storage-and-compute-65d2dffd450f

• Question 1256:

  Which of the following objects are contained within a schema? (Choose two.)

  A. Role
  B. Stream
  C. Warehouse
  D. External table
  E. User
  F. Share
  B. Stream
  D. External table

  ---

  Explanation

• Question 1257:

  Which virtual warehouse configuration requires the maximum number of clusters to be equal to the minimum number of clusters?

  A. Auto-scale mode
  B. Maximized mode
  C. Standard scaling policy
  D. Economy scaling policy
  B. Maximized mode

  ---

  Explanation

  Maximized Mode:

  Why Other Options Are Incorrect:

  A. Auto-scale mode: Allows different values for MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT to dynamically adjust cluster count.

  C. Standard scaling policy: Refers to cluster management policies, not requiring equal MIN and MAX values.

  D. Economy scaling policy: Similar to standard policy but conserves compute costs by scaling down aggressively.

  References:

  Multi-Cluster Warehouse Modes

• Question 1258:

  Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

  A. Database replication and failover
  B. Automated index management
  C. Customer managed keys (Tri-secret secure)
  D. Extended time travel
  E. Native support for geospatial data
  D. Extended time travel
  E. Native support for geospatial data

  ---

  Explanation

• Question 1259:

  How does conditional data masking work in Snowflake?

  A. It selectively masks plain text data.
  B. It selectively masks multiple columns.
  C. It masks all values in a given column.
  D. It selectively masks a column value based on another column.
  D. It selectively masks a column value based on another column.

  ---

  Explanation

• Question 1260:

  Which Snowflake tool would be BEST to troubleshoot network connectivity?

  A. SnowCLI
  B. SnowUI
  C. SnowSQL
  D. SnowCD
  D. SnowCD

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection %20to%20Snowflake.