SnowPro Core

True or False: The COPY command must specify a File Format in order to execute.A . TrueB . FalseView AnswerAnswer: B

How many shares can be consumed by single Data Consumer?A . 1B . 10C . 100, but can be increased by contacting supportD . UnlimitedView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

Which of the following statements are true about Schemas in Snowflake? (Choose two.)A . A Schema may contain one or more DatabasesB . A Database may contain one or more SchemasC . A Schema is a logical grouping of Database ObjectsD . Each Schema is contained within a WarehouseView AnswerAnswer:...

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?A . INITTIALLY_SUSPENDED = TRUE/FALSEB . START_AFTCR_CREATE = TRUE/FALSEC . START_TTIME = 60 // (seconds from now)D . STARE . TIME = CURRENF . DATE()View AnswerAnswer: A

True or False: A single database can exist in more than one Snowflake account.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

When loading data into Snowflake, the COPY command supports: Choose 2 answersA . JoinsB . FittersC . Data type conversionsD . Column reorderingE . AggregatesView AnswerAnswer: C,D

Snowflake is designed for which type of workloads? (Choose two.)A . OLAP (Analytics) workloadsB . OLTP (Transactional) workloadsC . Concurrent workloadsD . On-premise workloadsView AnswerAnswer: A,C

True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:A . Configure the Maximum Clusters setting to “Auto-Scale”B . Set the Warehouse type to “Auto”C . Set the Minimum Clusters and Maximum Clusters settings to the same valueD . Set the Minimum Clusters and Maximum Clusters settings to the...

Which formats are supported for unloading data from Snowflake? Choose 2 answersA . Delimited (CSV, TSV, etc.)B . AvroC . JSOND . ORCView AnswerAnswer: A,C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html