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
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
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A . Load files that are approximately 25 MB or smaller.
- B . Remove all dates and timestamps.
- C . Load files that are approximately 100-250 MB (or larger)
- D . Avoid using embedded characters such as commas for numeric data types
- E . Remove semi-structured data types
A user has 10 files in a stage containing new customer dat
a. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?
- A . All data from all of the files on the stage will be appended to the table
- B . Only data about new customers from the new files will be appended to the table
- C . The operation will fail with the error uncertain files in stage.
- D . All data from only the newly-added files will be appended to the table.
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
- A . list @file__stage
- B . show @file__stage
- C . view @file__stage
- D . verify @file__stage
What happens when a cloned table is replicated to a secondary database? (Select TWO)
- A . A read-only copy of the cloned tables is stored.
- B . The replication will not be successful.
- C . The physical data is replicated
- D . Additional costs for storage are charged to a secondary account
- E . Metadata pointers to cloned tables are replicated
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
- A . VARIANT
- B . ARRAY
- C . VARCHAR
- D . XML
- E . BLOB
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
- A . Each Snowflake account can be hosted in a different cloud vendor and region.
- B . Each Snowflake account must be hosted in a different cloud vendor and region
- C . All Snowflake accounts must be hosted in the same cloud vendor and region
- D . Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?
- A . It removes the last element of the outer array.
- B . It removes the outer array structure and loads the records into separate table rows,
- C . It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
- D . It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A . Time Travel – 1 day. Fail-safe – 1 day
- B . Time Travel – 0 days. Fail-safe – 1 day
- C . Time Travel – 1 day. Fail-safe – 0 days
- D . Transient tables are retained in neither Fail-safe nor Time Travel
What is a best practice after creating a custom role?
- A . Create the custom role using the SYSADMIN role.
- B . Assign the custom role to the SYSADMIN role
- C . Assign the custom role to the PUBLIC role
- D . Add__CUSTOM to all custom role names
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
