Practice Free COF-C02 Exam Online Questions
What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?
- A . Reorder the rows in a relational table and then unload the rows into a file
- B . Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.
- C . Reorder the data columns according to a target table definition and then unload the rows into the table.
- D . Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.
Which kind of Snowflake table stores file-level metadata for each file in a stage?
- A . Directory
- B . External
- C . Temporary
- D . Transient
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
- A . Compute resources
- B . Query execution
- C . Authentication
- D . Data storage
- E . Metadata
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
- A . When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- B . When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- C . When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
- D . When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
What is the name of the SnowSQLfile that can store connection information?
- A . history
- B . config
- C . snowsqLcnf
- D . snowsql.pubkey
What happens to historical data when the retention period for an object ends?
- A . The data is cloned into a historical object.
- B . The data moves to Fail-safe
- C . Time Travel on the historical data is dropped.
- D . The object containing the historical data is dropped.
How does Snowflake handle the bulk unloading of data into single or multiple files?
- A . It assigns each unloaded data file a unique name.
- B . It uses the put command to download the data by default.
- C . It uses COPY INTO <location> for bulk unloading where the default option is SINGLE – TRUE.
- D . It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
- A . Pre-signed URL
- B . Scoped URL
- C . Signed URL
- D . File URL
Which command is used to unload data from a Snowflake table into a file in a stage?
- A . COPY INTO
- B . GET
- C . WRITE
- D . EXTRACT INTO
Which command is used to unload data from a Snowflake table into a file in a stage?
- A . COPY INTO
- B . GET
- C . WRITE
- D . EXTRACT INTO