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

問題1

If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

A. Maximized mode

B. Economy scaling policy

C. Auto-scale mode

D. Standard scaling policy

正確答案: C

說明：（僅 Fast2test 成員可見）

問題2

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

A. The table has no overlapping micro-partitions.

B. The table has no micro-partitions.

C. The table has 1 overlapping micro-partition.

D. The table has only 1 micro-partition.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題3

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

A. GET_DDL

B. DESCRIBE MASKING POLICY

C. SHOW MASKING POLICIES

D. LIST MASKING POLICIES

正確答案: A

說明：（僅 Fast2test 成員可見）

問題4

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

A. COPY INTO <table>

B. CREATE PIPE

C. CREATE STAGE

D. COPY INTO <location>

正確答案: D

說明：（僅 Fast2test 成員可見）

問題5

What is the minimum Snowflake edition required for row level security?

A. Standard

B. Enterprise

C. Business Critical

D. Virtual Private Snowflake

正確答案: B

說明：（僅 Fast2test 成員可見）

問題6

Which stream type can be used for tracking the records in external tables?

A. Standard

B. Insert-only

C. Append-only

D. External

正確答案: D

說明：（僅 Fast2test 成員可見）

問題7

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

A. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

B. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

C. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

D. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題8

Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).

A. ARRAY

B. VARIANT

C. VARCHAK

D. TEXT

E. BINARY

正確答案: A,B

說明：（僅 Fast2test 成員可見）

問題9

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

B. When the data cache is full, the least-recently used data will be cleared to make room.

C. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

D. A user can only access their own queries from the query result cache.

E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

正確答案: B,E

說明：（僅 Fast2test 成員可見）

問題10

Which copy INTO command outputs the data into one file?

A. MULTIPLE=FAISE

B. SINGLE=TRUE

C. FILE_NUMBER=1

D. MAX_FILE_NUMBER=1

正確答案: D

說明：（僅 Fast2test 成員可見）

問題11

Will data cached in a warehouse be lost when the warehouse is resized?

A. Yes. became the new compute resource will no longer have access to the cache encryption key

B. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

C. Yes. because the compute resource is replaced in its entirety with a new compute resource.

D. No. because the size of the cache is independent from the warehouse size

正確答案: D

說明：（僅 Fast2test 成員可見）

問題12

Which file format will keep floating-point numbers from being truncated when data is unloaded?

A. Parquet

B. JSON

C. ORC

D. CSV

正確答案: A

說明：（僅 Fast2test 成員可見）

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

聯系我們

站內鏈接

最新更新