최신Snowflake SnowPro Core Recertification - COF-R02무료샘플문제

A. True

B. False

A. OLTP (Transactional) workloads

B. On-premise workloads

C. OLAP (Analytics) workloads

D. Concurrent workloads

A. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

B. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

A. Amazon Web Services

B. Google Cloud Platform

C. IBM Cloud

D. Microsoft Azure Cloud

E. Oracle Cloud

F. Docker

A. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

B. Scaling up resizes a virtual warehouse so it can handle more complex workloads.

C. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

D. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

E. Scaling out adds clusters of varying sizes to a virtual warehouse.

F. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

A. Via the Snowflake Web Interface (Ul)

B. Via Virtual Warehouses

C. Via the data_share=true parameter

D. Via SQL commands

A. No, because masking policies must always reference specific access roles.

B. Yes, because masking policies only apply to cloned tables.

C. No, because ownership of a table does not include the ability to change masking policies

D. Yes, because a table owner has full control and can unset masking policies.

A. 14 days

B. 64 days

C. Until the pipe is dropped

D. As configured in the create pipe settings