SnowPro Core

Which type of table corresponds to a single Snowflake session?A . TemporaryB . TranslentC . ProvisionalD . PermanentView AnswerAnswer: A

What is the most granular object that the Time Travel retention period can be defined on?A . AccountB . DatabaseC . SchemaD . TableView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html#data-retention-period

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

Which of the following commands sets the Virtual Warehouse for a session?A . COPT WAREHOUSE FROM <<Config file> ;B . SET warehouse = <<warehouse name>>;C . USE WAREHOUSE <<warehouse name>>;D . USE VIRTUAL_WAREHOUSE <<warehouse name>>;View AnswerAnswer: C Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/ui-worksheet.html

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

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

Snowflake is designed for which type of workloads? (Choose two.)A . OLAP (Analytics) workloadsB . OLTP (Transactional) workloadsC . Concurrent workloadsD . On-premise workloadsView AnswerAnswer: A,B Explanation: Reference: https://blog.couchbase.com/its-the-workload-stupid/

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)A . Is available to all Snowflake EditionsB . Is only available to customers with Business Critical EditionC . Restricts or enables access to specific IP addressesD . Is activated using an “ALTER DATABASE” commandView AnswerAnswer: A,C Explanation:...