Snowflake COF-C02 SnowPro Core Certification Exam Online Training
Snowflake COF-C02 Online Training
The questions for COF-C02 were last updated at Nov 23,2024.
- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Nov 23,2024
Which of the following can be executed/called with Snowpipe?
- A . A User Defined Function (UDF)
- B . A stored procedure
- C . A single copy_into statement
- D . A single insert__into statement
What Snowflake role must be granted for a user to create and manage accounts?
- A . ACCOUNTADMIN
- B . ORGADMIN
- C . SECURITYADMIN
- D . SYSADMIN
When unloading to a stage, which of the following is a recommended practice or approach?
- A . Set SINGLE: = true for larger files
- B . Use OBJECT_CONSTRUCT ( * ) when using Parquet
- C . Avoid the use of the CAST function
- D . Define an individual file format
When is the result set cache no longer available? (Select TWO)
- A . When another warehouse is used to execute the query
- B . When another user executes the query
- C . When the underlying data has changed
- D . When the warehouse used to execute the query is suspended
- E . When it has been 24 hours since the last query
Which of the following describes external functions in Snowflake?
- A . They are a type of User-defined Function (UDF).
- B . They contain their own SQL code.
- C . They call code that is stored inside of Snowflake.
- D . They can return multiple rows for each row received
What are ways to create and manage data shares in Snowflake? (Select TWO)
- A . Through the Snowflake web interface (Ul)
- B . Through the DATA_SHARE=TRUE parameter
- C . Through SQL commands
- D . Through the enable__share=true parameter
- E . Using the CREATE SHARE AS SELECT * TABLE command
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;
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
- A . ORC
- B . XML
- C . Avro
- D . Parquet
- E . JSON
What is the purpose of an External Function?
- A . To call code that executes outside of Snowflake
- B . To run a function in another Snowflake database
- C . To share data in Snowflake with external parties
- D . To ingest data from on-premises data sources
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
- A . Create a zero-copy clone of the worksheet and grant permissions to teammates
- B . Create a private Data Exchange so that any teammate can use the worksheet
- C . Share the worksheet with teammates within Snowsight
- D . Create a database and grant all permissions to teammates
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
