Snowflake SnowPro Core Practice Test - Questions Answers, Page 27

TheVALIDATION_MODEparameter can be used with theCOPYcommand to verify data files without loading them into the specified table.This parameter allows users to check for errors in the files

SnowCD (Snowflake Connectivity Diagnostic Tool) is the best tool provided by Snowflake for troubleshooting network connectivity issues.It helps diagnose and resolve issues related to connecting to Snowflake services

https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.

The Cloud Services layer in Snowflake includes activities such as user authentication and infrastructure management.This layer coordinates activities across Snowflake, including security enforcement, query compilation and optimization, and more

TheOBJECT_CONSTRUCTfunction is used with theCOPY INTOcommand to convert the rows in a relational table to a single VARIANT column, which can then be unloaded into a file.This is useful for transforming table data into a semi-structured JSON format

In Snowflake, a User-Defined Table Function (UDTF) can be accessed in theFROMclause of a query.UDTFs return a set of rows with one or more columns, which can be queried like a regular table

An outer join, specifically a left outer join, will list all rows from the left table and match them with rows from the right table. If there is no match, the result will still include the row from the left table, with NULLs for columns from the right table.Reference:Based on general SQL knowledge as of 2021.

The Cloud Services layer in Snowflake is responsible for various services, including security (like authentication and authorization) and metadata management (like query parsing and optimization).Reference:Based on general cloud architecture knowledge as of 2021.

To ensure a data consumer has access to the required objects, a data provider can enable the data sharing feature and validate that the consumer can access the views or tables shared with them.Reference:Based on general data sharing practices in cloud services as of 2021.

Scaling up the virtual warehouse in Snowflake involves increasing the compute resources available for a single warehouse, which can improve the performance of large and complex queries by providing more CPU and memory resources.Reference:Based on general cloud data warehousing knowledge as of 2021.