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

出題：1

Which use case does the search optimization service support?

A. Conjunctions (AND) of multiple equality predicates

B. Disjuncts (OR) in join predicates

C. LIKE/ILIKE/RLIKE join predicates

D. Join predicates on VARIANT columns

正解：A 解答を投票する

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

出題：2

What is the purpose of setting the Query Acceleration Service scale factor?

A. To limit the number of users who can use the Query Acceleration Service

B. To establish the maximum number of clustering keys that can be created by the Query Acceleration Service

C. To control the potential costs associated with the Query Acceleration Service

D. To establish the maximum virtual warehouse size that can be used by the Query Acceleration Service

正解：C 解答を投票する

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

出題：3

What does the LATERAL modifier for the FLATTEN function do?

A. Casts the values of the flattened data

B. Retrieves a single instance of a repeating element in the flattened data

C. Extracts the path of the flattened data

D. Joins information outside the object with the flattened data

正解：D 解答を投票する

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

出題：4

How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

A. 128

B. 256

C. 32

D. 64

正解：A 解答を投票する

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

出題：5

A directory table that references an external stage is being refreshed manually.
What will happen to any scheduled automatic-refresh operations occurring at the same time as the manual- refresh operations?

A. The automatic-refresh operations will continue on the established schedule.

B. The automatic-refresh operations will be aborted.

C. The automatic-refresh operations will be performed more often.

D. The manual-refresh operations and the automatic-refresh operations will both take place.

正解：D 解答を投票する

出題：6

Which Snowflake command can be used to unload the result of a query to a single file?

A. Use COPY INTO < external stage > with SINGLE = TRUE followed by a PUT command to download the file.

B. Use COPY INTO < external stage > followed by a GET command to download the file.

C. Use COPY INTO < internal stage > with SINGLE = TRUE followed by a GET command to download the file.

D. Use COPY INTO < internal stage > followed by a put command to download the file.

正解：C 解答を投票する

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

出題：7

A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?

A. Clone the database as it existed before the table was dropped.

B. Run the UNDROP command against the table.

C. Recreate the table and reload the data.

D. Clone the table schema as it existed before the table was dropped.

正解：B 解答を投票する

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

出題：8

Which operator is used to evaluate query pruning efficiency by comparing partitions scanned to partitions total?

A. IndexScan

B. ExternalScan

C. Filter

D. TableScan

正解：D 解答を投票する

出題：9

What activities can a user with the ORGADMIN role perform? (Select TWO).

A. Edit the account data for an organization.

B. Delete the account data for an organization.

C. Select all the data in tables for all accounts in an organization.

D. Create an account for an organization.

E. View usage information for all accounts in an organization.

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

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

出題：10

Which constraint is enforced for standard Snowflake tables?

A. PRIMARY KEY

B. UNIQUE

C. FOREIGN KEY

D. NOT NULL

正解：D 解答を投票する

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

出題：11

Which file function gives a user or application access to download unstructured data from a Snowflake stage?

A. GET STAGE LOCATION

B. GET_PRESIGNED_URL

C. BUILD_SCOPED_FILE_URL

D. BUILD_STAGE_FILE_URL

正解：B 解答を投票する

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

出題：12

What is a key characteristic of managed access schemas?

A. Only the schema owner or roles with the MANAGE GRANTS privilege can grant privileges on objects.

B. The global MANAGE GRANTS privilege is not applicable for granting additional privileges to other roles.

C. Any user with object ownership can manage future grants independently.

D. Object owners can grant privileges on their objects to other roles.

正解：A 解答を投票する

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

出題：13

What is the MAXIMUM size limit for a record of a VARIANT data type?

A. 128MB

B. 32MB

C. 8MB

D. 16MB

正解：D 解答を投票する

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

出題：14

At what levels can a network policy be configured in Snowflake? (Select TWO).

A. User level

B. Database level

C. Account level

D. Role level

E. Virtual warehouse level

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

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