最新のCOF-R02問題集で試験を準備する

Snowflake COF-R02 試験概要:

Snowflake COF-R02 試験シラバストピック:

Snowflake SnowPro Core Recertification 認定 COF-R02 試験問題：

1. What data is stored in the Snowflake storage layer? (Select TWO).

A) Query history
B) Snowflake parameters
C) Standard and secure view results
D) Persisted query results
E) Micro-partitions

2. A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

A) Only data about new customers from the new files will be appended to the table
B) The operation will fail with the error uncertain files in stage.
C) All data from all of the files on the stage will be appended to the table
D) All data from only the newly-added files will be appended to the table.

3. Which Snowflake feature is used for both querying and restoring data?

A) Cloning
B) Cluster keys
C) Time Travel
D) Fail-safe

4. What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

A) Incoming data can be joined with other tables
B) Columns can be reordered
C) Columns can be omitted
D) Data can be filtered by an optional where clause
E) Row level access can be defined

5. The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.
How can this be accomplished?

A) select dealership from car_sales;
B) select src:Dealership from car_sales;
C) select src:dealership from car_sales;
D) select src.dealership from car_sales;

質問と回答：