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

出題：1

A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

A. list @my_stage

B. display @my_stage

C. view @my_stage

D. show @my_stage

正解：A 解答を投票する

出題：2

Which of the following DML commands isn't supported by Snowflake?

A. UPDATE

B. MERGE

C. UPSERT

D. TRUNCATE TABLE

正解：C 解答を投票する

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

出題：3

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

A. The shared objects are transferred.

B. The shared objects become accessible.

C. The shared objects are copied.

D. The shared objects can be re-shared.

正解：C 解答を投票する

出題：4

Which command is used to unload data from a Snowflake table into a file in a stage?

A. EXTRACT INTO

B. GET

C. COPY INTO

D. WRITE

正解：C 解答を投票する

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

出題：5

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

出題：6

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

A. Business Critical

B. Enterprise

C. Virtual Private Snowflake

D. Standard

正解：A 解答を投票する

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

出題：7

A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

A. verify @file__stage

B. show @file__stage

C. view @file__stage

D. list @file__stage

正解：D 解答を投票する

出題：8

The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers

A. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

B. The size of the data required for each query

C. The complexity of each query

D. The tool that s executing the query

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

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

出題：9

What is the minimum Snowflake edition required for row level security?

A. Business Critical

B. Enterprise

C. Virtual Private Snowflake

D. Standard

正解：B 解答を投票する

出題：10

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 メンバーにのみ表示されます)

出題：11

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

A. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

B. The listing is replicated into all selected regions automatically, the data is not.

C. Shares attached to listings in remote regions can be viewed from any account in an organization.

D. There is no need to have a Snowflake account in the target region, a share will be created for each user.

E. The user must have the ORGADMIN role available in at least one account to link accounts for replication.

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

出題：12

True or False: An active warehouse is required to run a COPY INTO statement.

A. True

B. False

正解：A 解答を投票する

出題：13

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

A. SELECT AVG(ORDER_QTY) FROM SALES;

B. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

C. SELECT MIN(ORDER_AMT) FROM SALES;

D. SELECT SUM (ORDER_AMT) FROM SALES;

正解：A 解答を投票する

出題：14

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

出題：15

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

A. No virtual warehouse will be used, data will be read from the result cache.

B. No virtual warehouse will be used, data will be read from the local disk cache.

C. The virtual warehouse that is defined at the session level will be used to read all data.

D. The default virtual warehouse will be used to read all data.

正解：A 解答を投票する

出題：16

What is cached during a query on a virtual warehouse?

A. The columns in the result set of the query

B. All rows accessed during the query

C. Any columns accessed during the query

D. All columns in a micro-partition

正解：C 解答を投票する

出題：17

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A. The RESULT_SCAN table function can access and filter the contents of the query result cache.

B. When the data cache is full, the least-recently used data will be cleared to make room.

C. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

D. A user can only access their own queries from the query result cache.

E. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

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

出題：18

True or False: A single database can exist in more than one Snowflake account.

A. True

B. False

正解：B 解答を投票する

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

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