Snowflake SnowPro Core (COF-C02) – Quiz 1 / 15 Category: Snowflake SnowPro Core (COF) 1. 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 using the same virtual warehouse as the previous query D. The query includes a User Defined Function (UDF) E. The query has been run within 24 hours of the previously-run query 2 / 15 Category: Snowflake SnowPro Core (COF) 2. A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following? A. The primary cluster in the virtual warehouse B. The entire virtual warehouse C. The database in which the virtual warehouse resides D. The Queries currently being run on the virtual warehouse 3 / 15 Category: Snowflake SnowPro Core (COF) 3. What are two ways to create and manage Data Shares in Snowflake? (Choose two.) A. Via the Snowflake Web Interface (Ul) B. Via the data_share=true parameter C. Via SQL commands D. Via Virtual Warehouses 4 / 15 Category: Snowflake SnowPro Core (COF) 4. The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.) A. Users B. Tables C. Databases D. Internal Stages 5 / 15 Category: Snowflake SnowPro Core (COF) 5. The fail-safe retention period is how many days? A. 1 day B. 7 days C. 45 days D. 90 days 6 / 15 Category: Snowflake SnowPro Core (COF) 6. Which of the following significantly improves the performance of selective point lookup queries on a table? A. Clustering B. Materialized Views C. Zero-copy Cloning D. Search Optimization Service 7 / 15 Category: Snowflake SnowPro Core (COF) 7. Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.) A. Management of metadata B. Computing the data C. Maintaining Availability Zones D. Infrastructure security E. Parsing and optimizing queries 8 / 15 Category: Snowflake SnowPro Core (COF) 8. What is the purpose of multi-cluster virtual warehouses? A. To create separate data warehouses to increase query optimization B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster C. To eliminate or reduce Queuing of concurrent queries D. To allow the warehouse to resize automatically 9 / 15 Category: Snowflake SnowPro Core (COF) 9. 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 sources 10 / 15 Category: Snowflake SnowPro Core (COF) 10. Which semi-structured file formats are supported when unloading data from a table? (Select TWO). A. ORC B. XML C. Avro D. Parquet E. JSON 11 / 15 Category: ServiceNow CSA 11. 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 been 24 hours since the last query 12 / 15 Category: Snowflake SnowPro Core (COF) 12. Which of the following can be executed/called with Snowpipe? A. A User Defined Function (UDF) B. A stored procedure C. A single copy_into statement D. A single insert into statement 13 / 15 Category: Snowflake SnowPro Core (COF) 13. 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. 14 / 15 Category: Snowflake SnowPro Core (COF) 14. Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.) A. Files B. External tables C. Secure User-Defined Functions (UDFs) D. Sequences E. Streams 15 / 15 Category: Snowflake SnowPro Core (COF) 15. How would a user run a multi-cluster warehouse in maximized mode? A. Configure the maximum clusters setting to "Maximum." B. Turn on the additional clusters manually after starting the warehouse. C. Set the minimum Clusters and maximum Clusters settings to the same value. D. Set the minimum clusters and maximum clusters settings to different values. Your score is 0% Restart quiz Send feedback
