COF-R02 무료 덤프문제 온라인 액세스

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

• A.Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
• B.Data is hashed by the cluster key to facilitate fast searches for common data values
• C.Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
• D.Smaller micro-partitions are created for common data values to allow for more parallelism

Which of the following statements describe features of Snowflake data caching? (Choose two.)

• A.A user can only access their own queries from the query result cache.
• B.When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
• C.The RESULT_SCAN table function can access and filter the contents of the query result cache.
• D.A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
• E.When the data cache is full, the least-recently used data will be cleared to make room.

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

• A.Metadata
• B.Data storage
• C.Query execution
• D.Compute resources
• E.Authentication

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

• A.Custom
• B.Standard
• C.Economy
• D.Optimized

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

• A.Increases the latency staging and accuracy when loading the data
• B.Optimizes the virtual warehouse size and multi-cluster setting to economy mode
• C.Allows optimization of parallel operations
• D.Allows a user to import the files in a sequential order