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

問題1

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

A. Relative URL

B. Pre-Signed URL

C. File URL

D. Scoped URL

正確答案: D

說明：（僅 Fast2test 成員可見）

問題2

Which objects together comprise a namespace in Snowflake? (Select TWO).

A. Database

B. Table

C. Schema

D. Account

E. Virtual warehouse

正確答案: A,C

說明：（僅 Fast2test 成員可見）

問題3

Which will enable temporary scaling for queries that contain complex computations that may consume many credits?

A. Query Acceleration Service

B. Virtual warehouse scaling policy

C. Multi-cluster virtual warehouse

D. Search Optimization Service

正確答案: A

說明：（僅 Fast2test 成員可見）

問題4

What consideration should be made when loading data into Snowflake?

A. Create small data files and stage them in cloud storage frequently.

B. Create large data files to maximize the processing overhead for each file.

C. The number of data files that are processed in parallel is determined by the virtual warehouse.

D. The number of load operations That run in parallel can exceed the number of data files to be loaded.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題5

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

A. Pipes

B. Procedures

C. Streams

D. Tasks

正確答案: C

說明：（僅 Fast2test 成員可見）

問題6

Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?

A. ALTER USER jsmith SET RSA_P8_KEY= ' MIIBIjANBgkqh... ' ;

B. ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh... ' ;

C. ALTER USER jsmith SET RSA_PRIVATE_KEY= ' MIIBIjANBgkqh... ' ;

D. ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh... ' ;

正確答案: B

說明：（僅 Fast2test 成員可見）

問題7

Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

A. OBJECT

B. VARIANT

C. INTEGER

D. VARCHAR

E. LIST

正確答案: A,B

說明：（僅 Fast2test 成員可見）

問題8

What does a Query Profile metric that shows excessive spillage indicate?

A. Expired temporary tables

B. Improper virtual warehouse sizing

C. Improper Common Table Expressions (CTEs)

D. Poor query optimization

正確答案: B

問題9

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

A. Access history

B. Data classification

C. Object tagging

D. Dynamic Data Masking

正確答案: A

說明：（僅 Fast2test 成員可見）

問題10

A user executed a SELECT query in Snowsight which returned a 1 GB result set. The user then downloads the files.
What will occur?

A. The download will result in an error because the filters of the SELECT query need to be changed so that Snowsight returns a smaller result set.

B. The result set will be automatically compressed and the data will be downloaded as individual files.

C. The result set will be successfully downloaded from Snowsight.

D. The download will fail because the result set needs to be broken up into files no greater than 50 MB before downloading.

正確答案: D

問題11

A user needs to automatically retrieve Iceberg column definitions using the INFER_SCHEMA function for semi-structured files stored on a stage. Which file format configuration will help them achieve this?

A. CREATE FILE FORMAT my_ff TYPE = PARQUET USE_VECTORIZED_SCANNER = TRUE;

B. CREATE FILE FORMAT my_ff TYPE = PARQUET USE_VECTORIZED_SCANNER = FALSE;

C. CREATE FILE FORMAT my_ff TYPE = AVRO;

D. CREATE FILE FORMAT my_ff TYPE = ORC;

正確答案: A

說明：（僅 Fast2test 成員可見）

問題12

How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

A. 60 minutes

B. 14 days

C. 30 days

D. 24 hours

正確答案: B

說明：（僅 Fast2test 成員可見）

問題13

Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

A. OBJECT

B. STRING

C. VARIANT

D. VARCHAR

E. NUMBER

正確答案: A,C

說明：（僅 Fast2test 成員可見）

最新的Snowflake SnowPro® Core Certification 2026 Exam (COF-C03) - COF-C03免費考試真題

聯系我們

站內鏈接

最新更新