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

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

出題：3

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

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

出題：4

Which SQL command can be used to see the CREATE definition of a masking policy?

A. LIST MASKING POLICIES

B. DESCRIBE MASKING POLICY

C. SHOW MASKING POLICIES

D. GET_DDL

正解：D 解答を投票する

出題：5

True or False: Fail-safe can be disabled within a Snowflake account.

A. True

B. False

正解：B 解答を投票する

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

出題：6

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

A. True

B. False

正解：A 解答を投票する

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

出題：7

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

出題：8

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

出題：9

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

出題：10

What are common issues found by using the Query Profile? (Choose two.)

A. Identifying queries that will likely run very slowly before executing them

B. Locating queries that consume a high amount of credits

C. Data spilling to a local or remote disk

D. Identifying inefficient micro-partition pruning

E. Identifying logical issues with the queries

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

出題：11

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

A. Incoming data can be joined with other tables

B. Row level access can be defined

C. Columns can be reordered

D. Columns can be omitted

E. Data can be filtered by an optional where clause

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

出題：12

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?

A. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

B. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

C. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

正解：A 解答を投票する

出題：13

True or False: Data Providers can share data with only the Data Consumer.

A. True

B. False

正解：B 解答を投票する

出題：14

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?