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

出題：1

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

A. Micro-partitions

B. Persisted query results

C. Query history

D. Standard and secure view results

E. Snowflake parameters

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

出題：2

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

A. SELECT FROM STREAM

B. BEGIN COMMIT

C. UPDATE TABLE FROM STREAM

D. INSERT INTO TABLE SELECT FROM STREAM

E. ALTER TABLE AS SELECT FROM STREAM

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

出題：3

True or False: Pipes can be suspended and resumed.

A. True

B. False

正解：A 解答を投票する

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

出題：4

What tasks can be completed using the copy command? (Select TWO)

A. Data can be loaded without the need to spin up a virtual warehouse

B. Columns can be reordered

C. Columns can be joined with an existing table

D. Columns can be aggregated

E. Columns can be omitted

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

出題：5

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

A. Stop and start the warehouse to clear the queued queries

B. Limit user access to the warehouse so fewer queries are run against it.

C. Migrate some queries to a new warehouse to reduce load

D. Use multi-clustered warehousing to scale out warehouse capacity.

E. Scale up the warehouse size to allow Queries to execute faster.

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

出題：6

Which of the following can be executed/called with Snowpipe?

A. A stored procedure

B. A single insert__into statement

C. A User Defined Function (UDF)

D. A single copy_into statement

正解：D 解答を投票する

出題：7

By default, which Snowflake role is required to create a share?

A. ACCOUNTADMIN

B. SHAREADMIN

C. SECURITYADMIN

D. ORGADMIN

正解：B 解答を投票する

出題：8

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 解答を投票する

出題：9

What are supported file formats for unloading data from Snowflake? (Choose three.)

A. ORC

B. Parquet

C. CSV

D. AVRO

E. XML

F. JSON

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

出題：10

Where can a user find and review the failed logins of a specific user for the past 30 days?

A. The ACCESS_HISTORY view in ACCOUNT_USAGE

B. The USERS view in ACCOUNT_USAGE

C. The LOGIN_HISTORY view in ACCOUNT_USAGE

D. The SESSIONS view in ACCOUNT_USAGE

正解：C 解答を投票する

出題：11

Which of the following describes the Snowflake Cloud Services layer?

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

正解：C 解答を投票する

出題：12

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

A. The clone is created almost instantly.

B. The clone will have time travel history from the original table.

C. The clone saves space by not duplicating storage.

D. The clone always stays in sync with the original table.

E. The clone has better query performance.

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

出題：13

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

A. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

B. A user cannot specify a default warehouse when using the ODBC driver.

C. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

D. The default virtual warehouse size can be changed at any time.

E. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

正解：E 解答を投票する

出題：14

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A. Each Schema is contained within a Warehouse

B. A Schema may contain one or more Databases

C. A Database may contain one or more Schemas

D. A Schema is a logical grouping of Database Objects

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

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

出題：15

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

A. True

B. False

正解：B 解答を投票する

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

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