Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 151:

  Which of the following objects can be cloned? (Choose four.)

  A. Tables
  B. Named File Formats
  C. Schemas
  D. Shares
  E. Databases
  F. Users
  A. Tables
  B. Named File Formats
  C. Schemas
  E. Databases

  ---

  Explanation/Reference:

  Which Objects Can Be Cloned?

  Data Containment Objects. Databases. Schemas. Tables. Streams. Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

• Question 152:

  Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

  A. External Tokenization
  B. External Tables
  C. Materialized Views
  D. User-Defined Table Functions (UDTF)
  A. External Tokenization

• Question 153:

  Which of the following statement is true of Snowflake? Select one.

  A. It was built specifically for the cloud
  B. it was built as an on-premises solution and then potted to the cloud
  C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
  D. It was built for Hadoop architecture
  E. It's based on an Oracle Architecture
  A. It was built specifically for the cloud

• Question 154:

  True or False: A single database can exist in more than one Snowflake account.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

• Question 155:

  What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

  A. Standard
  B. Premier
  C. Enterprise
  D. Business Critical Edition
  C. Enterprise

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 156:

  What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

  A. The warehouse size does not change until all queries currently running in the warehouse have completed.
  B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
  C. The warehouse size does not change until the warehouse is suspended and restarted.
  D. It does not return from the command until the warehouse has finished changing its size.
  D. It does not return from the command until the warehouse has finished changing its size.

• Question 157:

  Which of the following describes external functions in Snowflake?

  A. They are a type of User-defined Function (UDF).
  B. They contain their own SQL code.
  C. They call code that is stored inside of Snowflake.
  D. They can return multiple rows for each row received
  A. They are a type of User-defined Function (UDF).

  ---

  Explanation/Reference:

  External functions are user-defined functions that are stored and executed outside of Snowflake.

  External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using

  third-party services, significantly simplifying your data pipelines.

  https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.

• Question 158:

  True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  A. True
  B. False
  A. True

• Question 159:

  What impacts the credit consumption of maintaining a materialized view? (Choose two.)

  A. Whether or not it is also a secure view
  B. How often the underlying base table is queried
  C. How often the base table changes
  D. Whether the materialized view has a cluster key defined
  E. How often the materialized view is queried
  D. Whether the materialized view has a cluster key defined
  E. How often the materialized view is queried

• Question 160:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management
  B. Metadata management
  C. Query execution
  D. Query parsing and optimization
  E. Management of the storage layer
  C. Query execution