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

出題：1

How would a user execute a series of SQL statements using a task?

A. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

B. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

C. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..

D. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

正解：A 解答を投票する

出題：2

True or False: Snowflake supports federated authentication in all editions.

A. True

B. False

正解：A 解答を投票する

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

出題：3

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

A. Pre-signed URL

B. Signed URL

C. Scoped URL

D. File URL

正解：B 解答を投票する

出題：4

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

A. The Pipe load history is reset to empty.

B. The REFRESH command is executed.

C. The stage will be purged.

D. The destination table is truncated.

正解：B 解答を投票する

出題：5

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

A. 10 minutes

B. 4 minutes

C. 24 minutes

D. 14 minutes

正解：D 解答を投票する

出題：6

A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

A. Increase the warehouse size from Medium to 2XL.

B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

D. Configure the warehouse to a multi-cluster warehouse.

正解：B 解答を投票する

出題：7

Which statement describes how Snowflake supports reader accounts?

A. A reader account can consume data from the provider account that created it and combine it with its own data.

B. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

C. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

D. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

正解：B 解答を投票する

出題：8

What type of query benefits the MOST from search optimization?

A. A query that uses only disjunction (i.e., OR) predicates

B. A query that includes analytical expressions

C. A query that uses equality predicates or predicates that use IN

D. A query that filters on semi-structured data types

正解：C 解答を投票する

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

出題：9

Which of the following are characteristics of security in Snowflake?

A. Account and user authentication is only available with the Snowflake Business Critical edition.

B. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

C. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

D. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

正解：B 解答を投票する

出題：10

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

B. A Data Exchange allows groups of accounts to share data privately among the accounts.

C. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

D. A Data Exchange allows accounts to share data with third, non-Snowflake parties.

E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

正解：B 解答を投票する

出題：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

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

出題：13

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

A. To accommodate more users

B. To accommodate more queries

C. To accommodate fluctuations in workload

D. To accommodate a more complex workload

正解：D 解答を投票する

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

出題：14

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

出題：15

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A. The ability to scale up warehouses

B. The use of warehouse indexing

C. The use of warehouse auto scaling

D. Use of multi-clustered warehouses

E. The ability to resize warehouses

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

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