Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 241:

  Which of the following terms best describes Snowflake's database architecture?

  A. Columnar shared nothing
  B. Shared disk
  C. Multi-cluster, shared data
  D. Cloud-native shared memory
  C. Multi-cluster, shared data

  ---

  Explanation/Reference:

  https://www.snowflake.com/product/architecture/

  Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.

• Question 242:

  When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

  A. A single join node uses more than 50% of the query time
  B. Partitions scanned is equal to partitions total
  C. An AggregateOperacor node is present
  D. The query is spilling to remote storage
  D. The query is spilling to remote storage

• Question 243:

  What happens to historical data when the retention period for an object ends?

  A. The data is cloned into a historical object.
  B. The data moves to Fail-safe
  C. Time Travel on the historical data is dropped.
  D. The object containing the historical data is dropped.
  D. The object containing the historical data is dropped.

• Question 244:

  Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

  A. Internal stages
  B. Incremental backups
  C. Time Travel
  D. Zero-copy clones
  E. Fail-safe
  C. Time Travel
  E. Fail-safe

  ---

  Explanation/Reference:

  Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.

  Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):

  Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel. Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe. https://docs.snowflake.com/

  en/user-guide/data-availability.html

• Question 245:

  Where would a Snowflake user find information about query activity from 90 days ago?

  A. account__usage . query history view
  B. account__usage.query__history__archive View
  C. information__schema . cruery_history view
  D. information__schema-query history_by_ses s i on view
  A. account__usage . query history view

• Question 246:

  Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

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

  ---

  Explanation/Reference:

  Reference: https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privilege

• Question 247:

  A user has unloaded data from Snowflake to a stage

  Which SQL command should be used to validate which data was loaded into the stage?

  A. list @file__stage
  B. show @file__stage
  C. view @file__stage
  D. verify @file__stage
  A. list @file__stage

• Question 248:

  What happens when a cloned table is replicated to a secondary database? (Select TWO)

  A. A read-only copy of the cloned tables is stored.
  B. The replication will not be successful.
  C. The physical data is replicated
  D. Additional costs for storage are charged to a secondary account
  E. Metadata pointers to cloned tables are replicated
  C. The physical data is replicated
  D. Additional costs for storage are charged to a secondary account

  ---

  Explanation/Reference:

  Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.

  https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20areandtext=However%2C%20when%20a%20cloned%20table,storag e%20usage%20for% 20your%20account.

• Question 249:

  Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

  A. Schema Stage
  B. User Stage
  C. Database Stage
  D. Table Stage
  E. External Named Stage
  F. Internal Named Stage
  A. Schema Stage
  E. External Named Stage
  F. Internal Named Stage

• Question 250:

  What privilege should a user be granted to change permissions for new objects in a managed access schema?

  A. Grant the OWNERSHIP privilege on the schema.
  B. Grant the OWNERSHIP privilege on the database.
  C. Grant the MANAGE GRANTS global privilege.
  D. Grant ALL privileges on the schema.
  C. Grant the MANAGE GRANTS global privilege.