Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 121:

  The Query History in the Snowflake Web Interface (UI) is kept for approximately:

  A. 60 minutes
  B. 24 hours
  C. 14 days
  D. 30 days
  E. 1 year
  C. 14 days

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

• Question 122:

  Which of the following statements describes a schema in Snowflake?

  A. A logical grouping of objects that belongs to a single database
  B. A logical grouping of objects that belongs to multiple databases
  C. A named Snowflake object that includes all the information required to share a database
  D. A uniquely identified Snowflake account within a business entity
  A. A logical grouping of objects that belongs to a single database

• Question 123:

  True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

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

• Question 124:

  When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

  A. Concurrency
  B. Performance
  A. Concurrency

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 125:

  Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

  A. parse_json()
  B. json_extract_path_text()
  C. object_construct()
  D. flatten
  B. json_extract_path_text()

• Question 126:

  Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

  A. SCIM
  B. Federated authentication
  C. TLS 1.2
  D. Key-pair authentication
  E. OAuth
  F. OCSP authentication
  B. Federated authentication
  D. Key-pair authentication
  E. OAuth

• Question 127:

  True or False: Fail-safe can be disabled within a Snowflake account.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Reference: 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 128:

  A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

  A. The primary cluster in the virtual warehouse
  B. The entire virtual warehouse
  C. The database in which the virtual warehouse resides
  D. The Queries currently being run on the virtual warehouse
  B. The entire virtual warehouse

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.

• Question 129:

  True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

• Question 130:

  A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

  COPY INTO my__table FROM @my__stage;

  The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

  If the user runs the same copy into command what will happen?

  A. All data from all of the files on the stage will be appended to the table
  B. Only data about new customers from the new files will be appended to the table
  C. The operation will fail with the error uncertain files in stage.
  D. All data from only the newly-added files will be appended to the table.
  A. All data from all of the files on the stage will be appended to the table