Snowflake COF-C02 Real Exam Questions
The questions for COF-C02 were last updated at Jul 24,2024.
- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Jul 24,2024
Question #1
What happens when an external or an internal stage is dropped? (Select TWO).
- A . When dropping an external stage, the files are not removed and only the stage is dropped
- B . When dropping an external stage, both the stage and the files within the stage are removed
- C . When dropping an internal stage, the files are deleted with the stage and the files are recoverable
- D . When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
- E . When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
Correct Answer: A, D
Question #2
A company’s security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days.
Which of the following statements will return the required information?
- A . SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS; - B . SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user()) - C . SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY; - D . SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;
Correct Answer: D
Question #3
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
- A . VARIANT
- B . ARRAY
- C . VARCHAR
- D . XML
- E . BLOB
Correct Answer: A, B
A, B
Explanation:
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data
A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
A, B
Explanation:
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data
A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
Question #4
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
- A . Create a task that runs a copy into operation from an external stage every 5 minutes
- B . Create a task that puts the files in an internal stage and automate the data loading wizard
- C . Create a task that runs a GET operation to intermittently check for new files
- D . Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
Correct Answer: D
D
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
D
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Question #5
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
- A . Compute Credits = 50 Credits Cloud Services = 10
- B . Compute Credits = 80 Credits Cloud Services = 5
- C . Compute Credits = 10 Credits Cloud Services = 9
- D . Compute Credits = 120 Credits Cloud Services = 10
- E . Compute Credits = 200 Credits Cloud Services = 26
Correct Answer: AE
Question #6
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A . Pipe
- B . External stage
- C . Task
- D . Stream
Correct Answer: A
A
Explanation:
Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
A
Explanation:
Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Question #7
What happens when a virtual warehouse is resized?
- A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
- B . When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
- C . The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
- D . Users who are trying to use the warehouse will receive an error message until the resizing is complete
Correct Answer: B
Question #8
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
- A . STATEMENT_TIMEOUT__IN__SECONDS
- B . STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- C . MAX_CONCURRENCY__LEVEL
- D . QUERY_TIMEOUT_IN_SECONDS
Correct Answer: B
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.
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 #9
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
Correct Answer: B
B
Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters %20in%20the%20warehouse.
B
Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters %20in%20the%20warehouse.
Question #10
Which command can be used to stage local files from which Snowflake interface?
- A . SnowSQL
- B . Snowflake classic web interface (Ul)
- C . Snowsight
- D . .NET driver
Correct Answer: A
A
Explanation:
https://docs.snowflake.com/en/user-guide/snowsql-use.html
A
Explanation:
https://docs.snowflake.com/en/user-guide/snowsql-use.html