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 Snowflake objects can be shared using a secure share? (Select TWO).
- A . Materialized views
- B . Sequences
- C . Procedures
- D . Tables
- E . Secure User Defined Functions (UDFs)
Will data cached in a warehouse be lost when the warehouse is resized?
- A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
- B . Yes. because the compute resource is replaced in its entirety with a new compute resource.
- C . No. because the size of the cache is independent from the warehouse size
- D . Yes. became the new compute resource will no longer have access to the cache encryption key
Which Snowflake partner specializes in data catalog solutions?
- A . Alation
- B . DataRobot
- C . dbt
- D . Tableau
What is the MOST performant file format for loading data in Snowflake?
- A . CSV (Unzipped)
- B . Parquet
- C . CSV (Gzipped)
- D . ORC
Which copy INTO command outputs the data into one file?
- A . SINGLE=TRUE
- B . MAX_FILE_NUMBER=1
- C . FILE_NUMBER=1
- D . MULTIPLE=FAISE
Where would a Snowflake user find information about query activity from 90 days ago?
- A . account__usage . query history view
- B . account__usage.query__history__archive View
- C . information__schema . cruery_history view
- D . information__schema – query history_by_ses s i on view
Which Snowflake technique can be used to improve the performance of a query?
- A . Clustering
- B . Indexing
- C . Fragmenting
- D . Using INDEX__HINTS
User-level network policies can be created by which of the following roles? (Select TWO).
- A . ROLEADMIN
- B . ACCOUNTADMIN
- C . SYSADMIN
- D . SECURITYADMIN
- E . USERADMIN
Which command can be used to load data into an internal stage?
- A . LOAD
- B . copy
- C . GET
- D . PUT
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
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
