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

出題：1

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

A. ORC

B. Parquet

C. Avro

D. XML

E. JSON

正解：B,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

What is the default file size when unloading data from Snowflake using the COPY command?

A. 8 GB

B. 16 MB

C. 32 MB

D. 5 MB

正解：B 解答を投票する

出題：3

How a Snowpipe charges calculated?

A. Per-second/per-core granularity

B. Total storage bucket size

C. Per-second/per Warehouse size

D. Number of Pipes in account

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which file formats are supported for unloading data from Snowflake? (Choose two.)

A. ORC

B. Avro

C. Delimited (CSV, TSV, etc.)

D. XML

E. JSON

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

A. Summarizing the throughput of Snowpipe costs for an account

B. Calculating the funds left on an account's contract

C. Gathering the hourly credit usage for an account

D. Compiling an account's average cloud services cost over the previous month

正解：C 解答を投票する

出題：6

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A. Fail-safe

B. External stages

C. Time Travel

D. Data encryption

E. Tri-Secret Secure

正解：A,C 解答を投票する

出題：7

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;

正解：D 解答を投票する

出題：8

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

A. VIEWS_HISTORY

B. OBJECT_HISTORY

C. ACCESS_HISTORY

D. LOGIN_HISTORY

正解：C 解答を投票する

出題：9

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

A. True

B. False

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

What internal stages are available in Snowflake? (Choose three.)

A. Stream stage

B. Table stage

C. Named stage

D. Schema stage

E. Database stage

F. User stage

正解：B,C,D 解答を投票する

出題：11

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

A. object_construct()

B. parse_json()

C. flatten

D. json_extract_path_text()

正解：D 解答を投票する

出題：12

True or False: The COPY command must specify a File Format in order to execute.

A. True

B. False

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：13

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

B. A multi-cluster Warehouse can add clusters automatically based on query activity

C. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

D. A multi-cluster Warehouse can scale down when query activity slows

正解：A,B,C,D 解答を投票する

出題：14

Which of the following is a data tokenization integration partner?

A. DBeaver

B. SAP

C. Protegrity

D. Tableau

正解：C 解答を投票する

出題：15

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

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

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：16

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

A. True

B. False

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：17

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

A. VARRAY

B. VARIANT

C. QUEUE

D. STRUCT

E. ARRAY

正解：B,E 解答を投票する

出題：18

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

A. MODIFY

B. PURGE

C. REMOVE

D. DELETE

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：19

How can a user change which columns are referenced in a view?

A. Modify the columns in the underlying table

B. Use the ALTER VIEW command to update the view

C. Recreate the view with the required changes

D. Materialize the view to perform the changes

正解：B 解答を投票する

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