COF-C02 V2

Which command can be used to load data into an internal stage?A . LOAD B. copy C. GET D. PUTView AnswerAnswer: D Explanation: https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....)statement? (Select TWO.)A . Data can be filtered by an optional where clause B. Incoming data can be joined with other tables C. Columns can be reordered D. Columns can be omitted E. Row level access can...

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).A . Load files that are approximately 25 MB or smaller. B. Remove all dates and timestamps. C. Load files that are approximately 100-250 MB (or larger) D. Avoid using embedded characters...

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).A . Materialized views B. Sequences C. Procedures D. Tables E. Secure User Defined Functions (UDFs)View AnswerAnswer: D,E Explanation: Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts....

Which services does the Snowflake Cloud Services layer manage? (Select TWO).A . Compute resources B. Query execution C. Authentication D. Data storage E. MetadataView AnswerAnswer: C,E Explanation: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different...

How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution B. Querying (select) the size of the stream content...

Which of the following commands cannot be used within a reader account?A . CREATE SHARE B. ALTER WAREHOUSE C. DROP ROLE D. SHOW SCHEMAS E. DESCRBE TABLEView AnswerAnswer: A Explanation: A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to...

What happens when an external or an internal stage is dropped? (Select TWO).A . When dropping an external stage, the files are not removed and only the stage is dropped B. When dropping an external stage, both the stage and the files within the stage are removed C. When dropping...

What is the recommended file sizing for data loading using Snowpipe?A . A compressed file size greater than 100 MB, and up to 250 MB B. A compressed file size greater than 100 GB, and up to 250 GB C. A compressed file size greater than 10 MB, and up...

Which data types does Snowflake support when querying semi-structured data? (Select TWO)A . VARIANT B. ARRAY C. VARCHAR D. XML E. BLOBView AnswerAnswer: A,B Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length of...