COF-R02 試験問題を無料オンラインアクセス

What is the purpose of multi-cluster virtual warehouses?

• A.To allow the warehouse to resize automatically
• B.To create separate data warehouses to increase query optimization
• C.To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
• D.To eliminate or reduce Queuing of concurrent queries

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

• A.Storage layer
• B.Cloud infrastructure layer
• C.Cloud services layer
• D.Compute layer

Which of the following objects are contained within a schema? (Choose two.)

• A.Stream
• B.Share
• C.Role
• D.Warehouse
• E.External table
• F.User

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

• A.False
• B.True

Which of the following can be used when unloading data from Snowflake? (Choose two.)

• A.Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
• B.When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
• C.The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
• D.By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
• E.Use the ENCODING file format option to change the encoding from the default UTF-8.