SnowPro-Core問題集、Snowflake実際の試験問題

質問 1

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory?
(Select TWO).

A. Bytes scanned

B. Partitions scanned

C. Percentage scanned from cache

D. Bytes spilled to remote storage

E. Bytes spilled to local storage

正解: D,E

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

質問 2

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

A. Clone the data from the production account to the non-production account.

B. Create a data share from the production account to the non-production account.

C. Create a reader account using the production account and link the reader account to the non-production account.

D. Create a subscription in the production account and have it publish to the non-production account.

正解: B

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

質問 3

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

A. There are multiple SOL UDFs with the same names and the same number of arguments.

B. There are multiple SQL UDFs with the same names and the same number of argument types.

C. There are multiple SQL UDFs with different names but the same number of arguments or argument types.

D. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

正解: D

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

質問 4

What tasks can an account administrator perform in the Data Exchange? (Select TWO).

A. Approve and deny listing approval requests.

B. Delete data categories.

C. Transfer listing ownership.

D. Transfer ownership of a provider profile.

E. Add and remove members.

正解: A,E

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

質問 5

Which formats does Snowflake store unstructured data in? (Choose two.)

A. Array

B. XML

C. GeoJSON

D. BLOB

E. Object

正解: B,C

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

質問 6

What is the MINIMUM permission needed to access a file URL from an external stage?

A. USAGE

B. READ

C. SELECT

D. MODIFY

正解: A

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

質問 7

By default, which role can create resource monitors?

A. SYSADMIN

B. USERADMIN

C. ACCOUNTADMIN

D. SECURITYADMIN

正解: C

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

質問 8

Which of the following are best practices for loading data into Snowflake? (Choose three.)

A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

B. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

C. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

D. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

E. Enclose fields that contain delimiter characters in single or double quotes.

F. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

正解: A,B,E

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

質問 9

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

A. USAGE

B. MONITOR

C. MODIFY

D. OPERATE

正解: D

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

Snowflake SnowPro Core Certification - SnowPro-Core 模擬練習