COF-R02試験無料問題集「Snowflake SnowPro Core Recertification 認定」

A. To run a function in another Snowflake database

B. To share data in Snowflake with external parties

C. To call code that executes outside of Snowflake

D. To ingest data from on-premises data sources

A. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

B. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

C. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

D. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

E. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

F. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

A. It removes the outer array structure and loads the records into separate table rows,

B. It removes the last element of the outer array.

C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

A. UPDATE

B. MERGE

C. UPSERT

D. TRUNCATE TABLE

A. True

B. False

A. GET

B. SELECT

C. COPY

D. PUT

A. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

B. STATEMENT_TIMEOUT__IN__SECONDS

C. QUERY_TIMEOUT_IN_SECONDS

D. MAX_CONCURRENCY__LEVEL

A. Create a task that runs a copy into operation from an external stage every 5 minutes

B. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

C. Create a task that runs a GET operation to intermittently check for new files

D. Create a task that puts the files in an internal stage and automate the data loading wizard

A. True

B. False

A. How often the underlying base table is queried

B. How often the base table changes

C. Whether the materialized view has a cluster key defined

D. Whether or not it is also a secure view

E. How often the materialized view is queried

A. The base table gets updated frequently.

B. The results of the query do not change often and are used frequently.

C. The query consumes many compute resources every time it runs.

D. There is minimal cost associated with running the query.

E. The query is highly optimized and does not consume many compute resources.

A. Manages the virtual warehouse cache to speed up queries

B. Executes queries submitted by the Snowflake account users

C. Coordinates activities in the Snowflake account

D. Manages quotas on the Snowflake account storage

A. The query is spilling to remote storage

B. Partitions scanned is equal to partitions total

C. An AggregateOperacor node is present

D. A single join node uses more than 50% of the query time