Practice Free COF-C02 Exam Online Questions
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
- A . GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE; - B . GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1; - C . GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1; - D . GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
- A . ROW_NUMBER
- B . TABLE
- C . TABULAR
- D . VALUES
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
- A . ROW_NUMBER
- B . TABLE
- C . TABULAR
- D . VALUES
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used.
The following COPY INTO
command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
- A . Compress the file and load the compressed file.
- B . Split the file into multiple files in the recommended size range (100 MB – 250 MB).
- C . Use a larger-sized warehouse.
- D . Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
- A . Cloud Services
- B . Database Storage
- C . Query Processing
- D . Metadata Management
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?
- A . PURGE
- B . MODIFY
- C . REMOVE
- D . DELETE
Which stage type can be altered and dropped?
- A . Database stage
- B . External stage
- C . Table stage
- D . User stage
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
- A . Schema
- B . View
- C . Internal stage
- D . Table
- E . User
- F . Role
Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?
- A . Scale up the existing warehouse.
- B . Create separate warehouses for each user.
- C . Create separate warehouses for each workload.
- D . Stop loading and querying data at the same time.
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse.
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
- A . Use multi-clustered warehousing to scale out warehouse capacity.
- B . Scale up the warehouse size to allow Queries to execute faster.
- C . Stop and start the warehouse to clear the queued queries
- D . Migrate some queries to a new warehouse to reduce load
- E . Limit user access to the warehouse so fewer queries are run against it.