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

出題：1

What happens when a cloned table is replicated to a secondary database? (Select TWO)

A. The physical data is replicated

B. A read-only copy of the cloned tables is stored.

C. Additional costs for storage are charged to a secondary account

D. The replication will not be successful.

E. Metadata pointers to cloned tables are replicated

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

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

出題：2

Which stage type can be altered and dropped?

A. External stage

B. Table stage

C. Database stage

D. User stage

正解：B 解答を投票する

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

出題：3

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

A. The columns with very high cardinality.

B. The columns most actively used in the select filters.

C. The columns with many different values.

D. The columns that are queried in the select clause.

正解：B 解答を投票する

出題：4

Which of the following are best practices for loading data into Snowflake? (Choose three.)

A. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

B. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

C. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

D. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

E. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

F. Enclose fields that contain delimiter characters in single or double quotes.

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

出題：5

When cloning a database, what is cloned with the database? (Choose two.)

A. Privileges on the schemas within the database

B. Privileges on the database

C. Only schemas and tables within the database

D. Existing child objects within the database

E. Future child objects within the database

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

出題：6

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A. VALIDATION_MODE

B. REPLACE_INVALID_CHARACTERS

C. STRIP_NULL_VALUES

D. SKIP_BYTE_ORDER_MARK

正解：A 解答を投票する

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

出題：7

The is the minimum Fail-safe retention time period for transient tables?

A. 12 hours

B. 7 days

C. 1 day

D. 0 days

正解：D 解答を投票する

出題：8

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

A. GET

B. SELECT

C. COPY

D. PUT

正解：A 解答を投票する

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

出題：9

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

A. True

B. False

正解：B 解答を投票する

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

出題：10

Which Snowflake architectural layer is responsible for a query execution plan?

A. Data storage

B. Cloud services

C. Cloud provider

D. Compute

正解：C 解答を投票する

出題：11

A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

A. Query against the metadata excite

B. Query against the result set cache

C. Query against the most-recently created micro-partition

D. Query against a virtual warehouse cache

正解：A 解答を投票する

出題：12

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

A. True

B. False

正解：A 解答を投票する

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

出題：13

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

A. Compute Credits = 80 Credits Cloud Services = 5

B. Compute Credits = 50 Credits Cloud Services = 10

C. Compute Credits = 120 Credits Cloud Services = 10

D. Compute Credits = 200 Credits Cloud Services = 26

E. Compute Credits = 10 Credits Cloud Services = 9

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

出題：14

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

A. Customer managed keys (Tri-secret secure)

B. Native support for geospatial data

C. Extended time travel

D. Automated index management

E. Database replication and failover

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

出題：15

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

A. True

B. False

正解：A 解答を投票する

出題：16

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

A. An explain plan can be used to conduct performance analysis without executing a query.

B. An explain plan will handle queries with temporary tables and the query profiler will not.

C. An explain plan's output will display automatic data skew optimization information.

D. The explain plan output is available graphically.

正解：A 解答を投票する

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