Skip to main content

COF-C02 Real Exam Questions

SnowPro Core Certification (COF-C02)

1,700 questions available · Page 1 of 170

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

What is the expiration period tor a file URL used to access unstructured data in cloud storage?

  1. A

    The remainder of the session

  2. B

    An unlimited amount of time

  3. C

    The length of time specified in the expiration_time argument

  4. D

    The same length of time as the expiration period for the query results cache

Show answer and explanation

Correct answer: D

Question 2 Multiple choice

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

  1. A

    Execute a COPY command

  2. B

    Updating data

  3. C

    Snowpipe

  4. D

    AUTOMATIC__CLUSTERING

  5. E

    Scaling up a warehouse

Show answer and explanation

Correct answers: C, D

Question 3 Single choice

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

  1. A

    STATEMENT_TIMEOUT__IN__SECONDS

  2. B

    STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  3. C

    MAX_CONCURRENCY__LEVEL

  4. D

    QUERY_TIMEOUT_IN_SECONDS

Show answer and explanation

Correct answer: B

Explanation

The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit.
By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

Question 4 Single choice

A query against which table will provide details about bytes consumed by active, Time Travel, and Fail-safe storage?

  1. A

    METERING_HISTORY

  2. B

    DATA_TRANSFER_HISTORY

  3. C

    CREDIT_USAGE_HISTORY

  4. D

    TABLE_STORAGE_METRICS

Show answer and explanation

Correct answer: D

Question 5 Single choice

Which function should be used to find the query ID of the second query executed in a current session?

  1. A

    Select LAST_QUERY_ID(-2)

  2. B

    Select LAST_QUERY_ID(-1)

  3. C

    Select LAST_QUERY_ID(1)

  4. D

    Select LAST_QUERY_ID(2)

Show answer and explanation

Correct answer: D

Question 6 Multiple choice

What type of NULL values are supported in semi-structured data? (Choose two.)

  1. A

    Avro

  2. B

    JSON

  3. C

    ORC

  4. D

    Parquet

  5. E

    SQL

Show answer and explanation

Correct answers: B, E

Question 7 Multiple choice

What is the impact of selecting one Snowflake edition over another? (Choose two.)

  1. A

    The edition will impact the unit costs for storage.

  2. B

    The edition will impact which regions can be accessed by the accounts.

  3. C

    The edition will determine the unit costs for the compute credits.

  4. D

    The edition will impact the total allowed storage space.

  5. E

    The edition will set a limit on the number of compute credits that can be consumed.

Show answer and explanation

Correct answers: A, C

Question 8 Multiple choice

Who can create and manage reader accounts? (Select TWO).

  1. A

    A user with ACCOUNTADMIN role

  2. B

    A user with securityadmin role

  3. C

    A user with SYSADMIN role

  4. D

    A user with ORGADMIH role

  5. E

    A user with CREATE ACCOUNT privilege

Show answer and explanation

Correct answers: A, D

Explanation

In Snowflake, reader accounts are special types of accounts that allow data sharing with external consumers without them having their own Snowflake account. The creation and management of reader accounts can be performed by users with the ACCOUNTADMIN role or the ORGADMIN role. The ACCOUNTADMIN role has comprehensive administrative privileges within a Snowflake account, including managing other accounts and roles. The ORGADMIN role, which is higher in hierarchy, oversees multiple accounts within an organization and can manage reader accounts across those accounts.
References:
Snowflake Documentation: Creating and Managing Reader Accounts

Question 9 Single choice

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  1. A

    Compute layer

  2. B

    Storage layer

  3. C

    Cloud infrastructure layer

  4. D

    Cloud services layer

Show answer and explanation

Correct answer: D

Question 10 Single choice

What will happen if multiple identical COPY INTO <location> statements using the default settings are executed in parallel on the same data file?

  1. A

    The COPY INTO <location> commands will load the data only once in the table.

  2. B

    The COPY INTO <location> commands will duplicate the data in the table.

  3. C

    The COPY INTO <location> commands will all fail with an error due to reading the same file.

  4. D

    The COPY INTO <location> commands will overwrite the data in the table.

Show answer and explanation

Correct answer: B