Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 181:

  Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

  A. COPY INTO
  B. CREATE PIPE
  C. INSERT INTO
  D. TABLE STREAM
  B. CREATE PIPE

  ---

  Explanation

• Question 182:

  What type of policy stales that each object within Snowflake has a unique owner who can grant access to that object?

  A. Role-Based Access Control (RBAC)
  B. Discretionary Access Control (DAC)
  C. Mandatory Access Control (MAC)
  D. Rule-Based Access Control (RuBAC)
  B. Discretionary Access Control (DAC)

  ---

  Explanation

  Discretionary Access Control (DAC) is the policy used in Snowflake, where each object has a unique owner who can grant or revoke access to the object. The owner has full control over permissions for the object.

  References:

  Snowflake Documentation: Access Control Overview Snowflake Object Ownership

• Question 183:

  When should a multi-cluster warehouse be used in auto-scaling mode?

  A. When it is unknown how much compute power is needed
  B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
  C. If the runtime of the executed query is very slow
  D. When a large number of concurrent queries are run on the same warehouse
  D. When a large number of concurrent queries are run on the same warehouse

  ---

  Explanation

• Question 184:

  Setting what parameter and value will keep a session active indefinitely as long as the connection is active, even if there is no user activity?

  A. CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY - 900
  B. CLIENT_SESSION_KEEP_ALIVE = TRUE
  C. CLIENT_PREFETCH_THREADS = 5
  D. DATA RETENTION TIME IN DAYS = 1
  B. CLIENT_SESSION_KEEP_ALIVE = TRUE

  ---

  Explanation

  The parameter CLIENT_SESSION_KEEP_ALIVE ensures that a session remains active indefinitely as long as the connection is active, even if there is no user activity.

  Setting this to TRUE overrides session inactivity timeouts.

  References:

  Snowflake Documentation: Session Parameters

  Snowflake Session Management

• Question 185:

  The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

  A. USERADMIN
  B. PUBLIC
  C. ORGADMIN
  D. SYSADMIN
  A. USERADMIN

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html#using-the-accountadmin-role By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user should then create one or more additional users who are assigned the USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN role or another role that is granted the global CREATE USER privilege

• Question 186:

  What features does Snowflake Time Travel enable?

  A. Querying data-related objects that were created within the past 365 days
  B. Restoring data-related objects that have been deleted within the past 90 days
  C. Conducting point-in-time analysis for Bl reporting
  D. Analyzing data usage/manipulation over all periods of time
  B. Restoring data-related objects that have been deleted within the past 90 days

  ---

  Explanation

  Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:

  Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted. Duplicating and backing up data from key points in the past. Analyzing data usage/manipulation over specified

  periods of time.

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

• Question 187:

  Which Snowflake virtual warehouse configuration enables horizontal scaling?

  A. Increasing the WAREHOSE_SIZE.
  B. Increasing the MAX_CLUSTER_COUNT.
  C. Increasing the MAX_CONCURRENCY_LEVEL.
  D. Increasing the MIN_CLUSTER_C0UNT.
  B. Increasing the MAX_CLUSTER_COUNT.

  ---

  Explanation

  In Snowflake, horizontal scaling refers to adding more compute clusters to a virtual warehouse to handle higher query concurrency. MAX_CLUSTER_COUNT determines the maximum number of clusters that can run simultaneously for a multi-cluster warehouse. Why Other Options Are Incorrect:

  A. WAREHOUSE_SIZE: Increasing warehouse size changes the compute capacity of a single cluster (vertical scaling), not horizontal scaling.

  C. MAX_CONCURRENCY_LEVEL: This controls query queuing and is unrelated to scaling the number of clusters.

  D. MIN_CLUSTER_COUNT: This sets the minimum number of clusters but does not affect maximum horizontal scaling.

  References:

  Multi-Cluster Warehouses

  Virtual Warehouse Scaling

• Question 188:

  A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day.

  What will happen at the 24-hour mark?

  A. The file will continue to load until all contents are loaded.
  B. The file will stop loading and all data up to that point will be committed.
  C. The file loading could be aborted without any portion of the file being committed.
  D. The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake.
  C. The file loading could be aborted without any portion of the file being committed.

  ---

  Explanation

• Question 189:

  Which Snowflake data type is used to store JSON key value pairs?

  A. TEXT
  B. BINARY
  C. STRING
  D. VARIANT
  D. VARIANT

  ---

  Explanation

• Question 190:

  Which privilege is required on a virtual warehouse to abort any existing executing queries?

  A. USAGE
  B. OPERATE
  C. MODIFY
  D. MONITOR
  B. OPERATE

  ---

  Explanation