Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 201:

  Which of the following is the Snowflake Account_Usage.Metering_History view used for?

  A. Gathering the hourly credit usage for an account
  B. Compiling an account's average cloud services cost over the previous month
  C. Summarizing the throughput of Snowpipe costs for an account
  D. Calculating the funds left on an account's contract
  A. Gathering the hourly credit usage for an account

• Question 202:

  True or False: During data unloading, only JSON and CSV files can be compressed.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

• Question 203:

  A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

  How can this requirement be met?

  A. Use data encryption.
  B. Use dynamic data masking.
  C. Use secure materialized views.
  D. Revoke all roles for functional managers and end users.
  B. Use dynamic data masking.

• Question 204:

  When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

  A. The Pipe load history is reset to empty
  B. The REFRESH parameter is set to TRUE
  C. Previously loaded files will be ignored
  D. All of the above
  A. The Pipe load history is reset to empty

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

• Question 205:

  Which stage type can be altered and dropped?

  A. Database stage
  B. External stage
  C. Table stage
  D. User stage
  C. Table stage

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

• Question 206:

  What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

  A. 30 days
  B. 7 days
  C. 48 hours
  D. 24 hours
  D. 24 hours

• Question 207:

  True or False: The COPY command must specify a File Format in order to execute.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html

  Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.html Copy Into: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

• Question 208:

  A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

  What will occur?

  A. No virtual warehouse will be used, data will be read from the result cache.
  B. No virtual warehouse will be used, data will be read from the local disk cache.
  C. The default virtual warehouse will be used to read all data.
  D. The virtual warehouse that is defined at the session level will be used to read all data.
  A. No virtual warehouse will be used, data will be read from the result cache.

• Question 209:

  Which of the following statements is true of Snowflake?

  A. It was built specifically for the cloud
  B. It was built as an on-premises solution and then ported 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

  ---

  Explanation/Reference:

  Reference: https://www.stitchdata.com/resources/snowflake/

• Question 210:

  True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

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