COF-C02試験無料問題集（715題）「Snowflake SnowPro Core Certification 認定」

出題：1

What is the MAXIMUM Time Travel retention period for a transient table?

A. 90 days

B. 7 days

C. 1 day

D. O days

正解：C 解答を投票する

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

出題：2

What command is used to export or unload data from Snowflake?

A. INSERT @mystage

B. COPY INTO @mystage

C. GET @mystage

D. PUT @mystage

正解：D 解答を投票する

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

出題：3

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

A. MODIFY

B. PURGE

C. REMOVE

D. DELETE

正解：C 解答を投票する

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

出題：4

Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

A. CHECK_JSON

B. PARSE_XML

C. PARSE_JSON

D. JSON_EXTRACT_PATH_TEXT

正解：C 解答を投票する

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

出題：5

What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?

A. IO

B. Pruning

C. Spilling

D. Network

正解：C 解答を投票する

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

出題：6

What is the difference between a stored procedure and a User-Defined Function (UDF)?

A. Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

B. Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

C. Returning a value is required in a stored procedure while returning values in a UDF is optional.

D. Stored procedures can execute database operations while UDFs cannot.

正解：D 解答を投票する

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

出題：7

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

A. Bytes spilled to remote storage.

B. Bytes spilled to local cache.

C. Bytes spilled to remote metastore.

D. Bytes spilled to remote cache.

E. Bytes spilled to local storage.

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

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

出題：8

What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

A. Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list

B. Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

C. Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.

D. Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

正解：D 解答を投票する

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

出題：9

In Snowflake, what allows users to perform recursive queries?

A. QUALIFY

B. LATERAL

C. PIVOT

D. CONNECT BY

正解：D 解答を投票する

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

出題：10

What does a table with a clustering depth of 1 mean in Snowflake?

A. The table has only 1 micro-partition.

B. The table has no micro-partitions.

C. The table has 1 overlapping micro-partition.

D. The table has no overlapping micro-partitions.

正解：D 解答を投票する

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

出題：11

A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify & Suspend Immediately".

What is the MAXIMUM limit of credits that Warehouse 2 can consume?

A. 5000

B. 1500

C. 3500

D. 0

正解：B 解答を投票する

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

出題：12

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

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

出題：13

When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select TWO).

A. REPLACE_INVALID_CHARACTERS

B. FIELD_OPTIONALLY_ENCLOSED_BY

C. EMPTY_FIELD_AS_NULL

D. ESCAPE_UNENCLOSED_FIELD

E. SKIP_BLANK_LINES

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

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

出題：14

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

A. When the system has enough load for 10 minutes

B. When the system has enough load for 8 minutes

C. When the system has enough load for 2 minutes

D. When the system has enough load for 6 minutes

正解：C 解答を投票する

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

出題：15

How can a user get the MOST detailed information about individual table storage details in Snowflake?

A. TABLE STORAGE METRICS view

B. SHOW EXTERNAL TABLES command

C. SHOW TABLES command

D. TABLES view

正解：A 解答を投票する

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

出題：16

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

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

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