Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 221:

  When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

• Question 222:

  Which function will generate a URL that can be accessed by a non-Snow ake user?

  A. GET_PRESIGNED_URL
  B. GET_STAGE_LOCATION
  C. BUILD_SCOPED_FILE_URL
  D. BUILD_STAGE_FILE_URL
  A. GET_PRESIGNED_URL

  ---

  Explanation

• Question 223:

  What is the MAXIMUM Time Travel retention period for a transient table?

  A. 0 days
  B. 1 day
  C. 7 days
  D. 90 days
  B. 1 day

  ---

  Explanation

• Question 224:

  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

  ---

  Explanation

• Question 225:

  How should a data provider securely share Snowflake objects with a data consumer who does not have a Snowflake account?

  A. Give the consumer owner's rights on the provider's Snowflake account.
  B. Unload the data into the consumer's cloud storage.
  C. Create a reader account for the consumer.
  D. Create and replicate a share, then give the consumer access to the replication.
  C. Create a reader account for the consumer.

  ---

  Explanation

• Question 226:

  What are the correct settings for column and element names, regardless of which notation is used while accessing elements in a JSON object?

  A. Both the column name and the element name are case-insensitive.
  B. Both the column name and the element name are case-sensitive.
  C. The column name is case-sensitive and the element names are case-insensitive.
  D. The column name is case-insensitive and the element name is case-sensitive.
  D. The column name is case-insensitive and the element name is case-sensitive.

  ---

  Explanation

• Question 227:

  In Snow ake, where can query pruning information statistics be identified?

  A. Partitions scanned
  B. Bytes scanned
  C. Bytes spilled to remote storage
  D. Percentage scanned from cache
  A. Partitions scanned

  ---

  Explanation

• Question 228:

  What privilege does a user need in order to receive or request data from the Snowflake Marketplace?

  A. CREATE DATA EXCHANGE LISTING
  B. CREATE SHARE
  C. IMPORT SHARE
  D. IMPORTED PRIVILEGES
  D. IMPORTED PRIVILEGES

  ---

  Explanation

• Question 229:

  Where can a user find and review the failed logins of a specific user for the past 30 days?

  A. The USERS view in ACCOUNT_USAGE
  B. The LOGIN_HISTORY view in ACCOUNT_USAGE
  C. The ACCESS_HISTORY view in ACCOUNT_USAGE
  D. The SESSIONS view in ACCOUNT_USAGE
  B. The LOGIN_HISTORY view in ACCOUNT_USAGE

  ---

  Explanation

• Question 230:

  Which statement best describes ''clustering''?

  A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions
  B. The database administrator must define the clustering methodology for each Snowflake table.
  C. The clustering key must be included on the COPV command when loading data into Snowflake.
  D. Clustering can be disabled within a Snowflake account.
  A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html