Free Snowflake COF-C03 Exam Dumps Questions & Answers

Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)

• A.Directory tables store data file metadata.
• B.A directory table will be automatically added to a stage.
• C.Directory tables do not have their own grantable privileges.
• D.A directory table is a separate database object.
• E.Directory table data can not be refreshed manually.

What actions can be taken to reduce memory spilling for queries that are too large to fit into memory? Select TWO.

• A.Set a clustering key on the tables used in the queries.
• B.Increase the size of the virtual warehouse clusters.
• C.Edit the queries to process the data in smaller batches.
• D.Suspend and then resume the virtual warehouse.
• E.Increase the size of the virtual warehouse.

When used with a SELECT statement in the COPY INTO < location > command, what statement will unload data from a table as JSON?

• A.TO_JSON
• B.TO_OBJECT
• C.PARSE_JSON
• D.OBJECT_CONSTRUCT

Which Snowflake table stores file-level metadata about unstructured data files in a stage, including size, last- modified timestamp, and Snowflake file URL?

• A.Iceberg table
• B.Directory table
• C.External table
• D.Dynamic table

Which virtual warehouse configuration requires the maximum number of clusters to be equal to the minimum number of clusters?

• A.Standard scaling policy
• B.Economy scaling policy
• C.Maximized mode
• D.Auto-scale mode