Practice Free COF-C02 Exam Online Questions
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
- A . Authy
- B . Duo Security
- C . One Login
- D . RSA SecurlD Access
Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
- A . A User-Defined Table Function (UDTF)
- B . A Scalar User Function (UDF)
- C . A stored procedure
- D . A task
What is a limitation of a Materialized View?
- A . A Materialized View cannot support any aggregate functions
- B . A Materialized View can only reference up to two tables
- C . A Materialized View cannot be joined with other tables
- D . A Materialized View cannot be defined with a JOIN
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
- A . Bytes spilled to local cache.
- B . Bytes spilled to local storage.
- C . Bytes spilled to remote cache.
- D . Bytes spilled to remote storage.
- E . Bytes spilled to remote metastore.
Which of the following describes a Snowflake stored procedure?
- A . They can be created as secure and hide the underlying metadata from the user.
- B . They can only access tables from a single database.
- C . They can contain only a single SQL statement.
- D . They can be created to run with a caller’s rights or an owner’s rights.
Which formats does Snowflake store unstructured data in? (Choose two.)
- A . GeoJSON
- B . Array
- C . XML
- D . Object
- E . BLOB
How can a user change which columns are referenced in a view?
- A . Modify the columns in the underlying table
- B . Use the ALTER VIEW command to update the view
- C . Recreate the view with the required changes
- D . Materialize the view to perform the changes
Which TABLE function helps to convert semi-structured data to a relational representation?
- A . CHECK_JSON
- B . TO_JSON
- C . FLATTEN
- D . PARSE_JSON
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
- A . 1 second
- B . 60 seconds
- C . 5 minutes
- D . 60 minutes
A user has 10 files in a stage containing new customer data.
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.