Snowflake COF-R02 SnowPro Core Recertification Exam Online Training
Snowflake COF-R02 Online Training
The questions for COF-R02 were last updated at Nov 23,2024.
- Exam Code: COF-R02
- Exam Name: SnowPro Core Recertification Exam
- Certification Provider: Snowflake
- Latest update: Nov 23,2024
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
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
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
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
- A . Data is hashed by the cluster key to facilitate fast searches for common data values
- B . Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
- C . Smaller micro-partitions are created for common data values to allow for more parallelism
- D . Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
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
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
What is the default File Format used in the COPY command if one is not specified?
- A . CSV
- B . JSON
- C . Parquet
- D . XML
True or False: A Virtual Warehouse can be resized while suspended.
- A . True
- B . False
What features does Snowflake Time Travel enable?
- A . Querying data-related objects that were created within the past 365 days
- B . Restoring data-related objects that have been deleted within the past 90 days
- C . Conducting point-in-time analysis for Bl reporting
- D . Analyzing data usage/manipulation over all periods of time
In which use cases does Snowflake apply egress charges?
- A . Data sharing within a specific region
- B . Query result retrieval
- C . Database replication
- D . Loading data into Snowflake
Latest COF-R02 Dumps Valid Version with 330 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
