COF-C02 Questions Bank

SnowPro Core Certification Exam Questions and Answers

Question 129

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?

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Question 130

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

True

False

Question 131

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Compute resources

Query execution

Authentication

Data storage

Metadata

Question 132

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

list @mytable;

list @%raytable;

list @ %m.ystage;

list @mystage;