COF-C02 V2

When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the query B. When another user executes the query C. When the underlying data has changed D. When the warehouse used to execute the query is suspended E. When it has...

A user has unloaded data from Snowflake to a stage Which SQL command should be used to validate which data was loaded into the stage?A . list @file__stage B. show @file__stage C. view @file__stage D. verify @file__stageView AnswerAnswer: A

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).A . The user has the appropriate privileges on the objects associated with the query B. Micro-partitions have been reclustered since the query was last run C. The new query is run...

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query time B. Partitions scanned is equal to partitions total C. An AggregateOperacor node is present D. The query...

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)A . Reader B. Consumer C. Vendor D. Standard E. PersonalizedView AnswerAnswer: D,E

What can be used to view warehouse usage over time? (Select Two).A . The load HISTORY view B. The Query history view C. The show warehouses command D. The WAREHOUSE_METERING__HISTORY View E. The billing and usage tab in the Snowflake web UlView AnswerAnswer: D,E

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).A . ORC B. XML C. Avro D. Parquet E. JSONView AnswerAnswer: D,E Explanation: Semi-structured JSON, Parquet https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)

What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMIN B. ORGADMIN C. SECURITYADMIN D. SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure management B. Metadata management C. Query execution D. Query parsing and optimization E. Management of the storage layerView AnswerAnswer: C

What is the purpose of an External Function?A . To call code that executes outside of Snowflake B. To run a function in another Snowflake database C. To share data in Snowflake with external parties D. To ingest data from on-premises data sourcesView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/sql-reference/external-functions.html