最新的Snowflake COF-C02免費考試真題

問題1

Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

A. Stream

B. Materialized View

C. Task

D. Pipe

正確答案: A

說明：（僅 Fast2test 成員可見）

問題2

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

A. Parsing and optimizing queries

B. Maintaining Availability Zones

C. Computing the data

D. Management of metadata

E. Infrastructure security

正確答案: A,D

說明：（僅 Fast2test 成員可見）

問題3

If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

A. 6 minutes

B. 1 minute

C. 2 minutes

D. 8 minutes

正確答案: C

說明：（僅 Fast2test 成員可見）

問題4

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A. Time Travel

B. Fail-safe

C. Data encryption

D. External stages

E. Tri-Secret Secure

正確答案: A,B

說明：（僅 Fast2test 成員可見）

問題5

What is the MINIMUM Snowflake edition that supports the periodic rekeying of encrypted data?

A. Standard

B. Enterprise

C. Virtual Private Snowflake (VPS)

D. Business Critical

正確答案: B

問題6

A Snowflake user is creating a deployment pipeline for Snowflake objects.
What interface should be used to automate object deployment?

A. ODBC driver

B. SnowSQL

C. SnowCD

D. Snowflake Horizon Catalog

正確答案: B

問題7

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B. Allows optimization of parallel operations

C. Increases the latency staging and accuracy when loading the data

D. Allows a user to import the files in a sequential order

正確答案: B

說明：（僅 Fast2test 成員可見）

問題8

Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

A. A table with a materialized view

B. Directory table

C. Temporary table

D. Transient table

正確答案: B

說明：（僅 Fast2test 成員可見）

問題9

Assuming the data provider has granted the required permissions to the objects in a share, which statement will grant permissions to the role consumer_role, allowing access to the database share_db?

A. grant ownership on database share_db to role consumer_role;

B. grant imported privileges on database share_db to role consumer_role;

C. grant usage on database share_db to role consumer_role;

D. grant all on database share_db to role consumer_role;

正確答案: B

問題10

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

A. OBJECT

B. ARRAY

C. VARIANT

D. TEXT

正確答案: C

說明：（僅 Fast2test 成員可見）

問題11

Which feature is designed to reduce security risks associated with an individual user ' s password authentication?

A. Multi-Factor Authentication, or MFA

B. Standard authentication

C. External OAuth

D. Snowflake OAuth

正確答案: A

說明：（僅 Fast2test 成員可見）

問題12

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A. Databases

B. Warehouses

C. Users

D. Roles

E. Accounts

正確答案: C,E

說明：（僅 Fast2test 成員可見）

問題13

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A. The new query is run using the same virtual warehouse as the previous query

B. The query has been run within 24 hours of the previously-run query

C. The query includes a User Defined Function (UDF)

D. The user has the appropriate privileges on the objects associated with the query

E. Micro-partitions have been reclustered since the query was last run

正確答案: B,D

說明：（僅 Fast2test 成員可見）

最新的Snowflake SnowPro Core Certification - COF-C02免費考試真題

聯系我們

站內鏈接

最新更新