Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 331:

  What user setting can be configured to disable Multi-Factor Authentication (MFA) for a Snowflake user? (Choose two.)

  A. DISABLE_MFA
  B. MINS_TO_BYPASS_MFA
  C. PASSWORD
  D. MINS_TO_UNLOCK
  E. MUST_CHANGE_PASSWORD
  A. DISABLE_MFA
  B. MINS_TO_BYPASS_MFA

  ---

  Explanation

• Question 332:

  How does Snowflake improve the performance of queries that are designed to filter out a significant amount of data?

  A. The use of indexing
  B. The use of pruning
  C. The use of TableScan
  D. By increasing the number of partitions scanned
  B. The use of pruning

  ---

  Explanation

  Purring improves query efficiency

• Question 333:

  A user needs to ingest 1 GB of data that is available in an external stage using a COPY INTO command.

  How can this be done with MAXIMUM performance and the LEAST cost?

  A. Ingest the data in a compressed format as a single file.
  B. Ingest the data in an uncompressed format as a single file.
  C. Split the file into smaller files of 100-250 MB each, compress and ingest each of the smaller files.
  D. Split the file into smaller files of 100-250 MB each and ingest each of the smaller files in an uncompressed format.
  C. Split the file into smaller files of 100-250 MB each, compress and ingest each of the smaller files.

  ---

  Explanation

• Question 334:

  Which Snowflake objects can be restored using Time Travel? (Select two).

  A. Roles
  B. Users
  C. Databases
  D. Schemas
  E. Virtual warehouses
  C. Databases
  D. Schemas

  ---

  Explanation

• Question 335:

  Which process does Snowflake follow when a stored procedure with owner's rights is called within a session?

  A. The procedure will be run with the privileges of the caller.
  B. The owner can set the caller's session variables.
  C. The owner will inherit the caller's current virtual warehouse.
  D. The owner can view the caller's session variables.
  B. The owner can set the caller's session variables.

  ---

  Explanation

• Question 336:

  When regularly unloading similarly formatted semi-structured data, where should copy options be specified?

  A. In a table definition
  B. In a named file format
  C. In a named stage definition
  D. In the copy command
  B. In a named file format

  ---

  Explanation

• Question 337:

  What role should be used when creating a new user?

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

  ---

  Explanation

• Question 338:

  What virtual warehouse configuration should be used when processing a large number of complex queries?

  A. Use the auto-resume feature.
  B. Run the warehouse in auto-scale mode.
  C. Increase the size of the warehouse.
  D. Increase the number of warehouse clusters.
  D. Increase the number of warehouse clusters.

  ---

  Explanation

  To handle a large number of complex queries, configuring the warehouse in auto-scale mode by increasing the number of warehouse clusters is recommended. This setup allows Snowflake to dynamically add clusters as demand increases, ensuring better performance and concurrency. Increasing the number of clusters provides scalability for concurrent users and heavy workloads, improving response times without impacting individual query performance.

• Question 339:

  Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

  A. Pipes
  B. Streams
  C. Tasks
  D. Procedures
  B. Streams

  ---

  Explanation

  https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about% 20each%20change.

• Question 340:

  What type of policy states 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