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

出題：1

How can a user access information about a query execution plan without consuming virtual warehouse compute resources?

A. Review the data in the Account_Usage view.

B. Use the EXPLAIN function.

C. Review the Query Profile metrics.

D. Use the Snowsight dashboard.

正解：B 解答を投票する

出題：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. Create a data share from the production account to the non-production account.

B. Clone the data 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.

正解：A 解答を投票する

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

出題：3

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

A. Pipe

B. Stream

C. Task

D. Materialized View

正解：B 解答を投票する

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

出題：4

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

A. The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

B. Compute can be scaled up or down without the requirement to add more storage.

C. Storage volume growth and compute usage growth can be tightly coupled.

D. The separation ensures consistent data encryption across all virtual data warehouses.

E. The separation allows independent scaling of computing resources.

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

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

出題：5

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

A. Streams

B. Sequences

C. Secure User-Defined Functions (UDFs)

D. Files

E. External tables

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

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

出題：6

Which Query Profile metrics can be used to determine if a query is pruning efficiently?

A. Number of rows inserted and Number of rows updated

B. Partitions scanned and Partitions total

C. Bytes spilled to local storage and Bytes spilled to remote storage

D. Bytes read from result and Bytes written to result

正解：B 解答を投票する

出題：7

A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?

A. The temporary table will take precedence over the permanent table.

B. The permanent table will take precedence over the temporary table.

C. The table that was created most recently will take precedence over the older table.

D. An error will say there cannot be two tables with the same name in a schema.

正解：A 解答を投票する

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

出題：8

Which command will indicate whether a materialized view is being used in a query?

A. EXPLAIN

B. USE

C. DESCRIBE

D. SHOW

正解：A 解答を投票する

出題：9

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

A. Contact Snowflake Support to have the data retrieved from Fail-safe storage.

B. The transient table version cannot be retrieved after 24 hours.

C. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

正解：C 解答を投票する

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

出題：10

Which function is used to convert rows in a relational table to a single VARIANT column?

A. ARRAY_AGG

B. ARRAY_CONSTRUCT

C. OBJECT_CONSTRUCT

D. OBJECT_AGG

正解：C 解答を投票する

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

出題：11

Which commands are supported by the query acceleration service? (Select TWO).

A. UPDATE

B. SELECT

C. MERGE

D. DELETE

E. INSERT

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

出題：12

Which of the following objects are contained within a schema? (Choose two.)

A. Share

B. Stream

C. Role

D. Warehouse

E. User

F. External table

正解：B,F 解答を投票する

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

出題：13

What is the default file size when unloading data from Snowflake using the COPY command?

A. 8 GB

B. 16 MB

C. 32 MB

D. 5 MB

正解：B 解答を投票する

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

出題：14

Which roles can make grant decisions to objects within a managed access schema? (Select TWO)

A. ACCOUNTADMIN

B. SECURITYADMIN

C. ORGADMIN

D. USERADMIN

E. SYSTEMADMIN

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

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

出題：15

What is the default character set used when loading CSV files into Snowflake?

A. ISO S859-1

B. UTF-16

C. UTF-8

D. ANSI_X3.A

正解：C 解答を投票する

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

出題：16

What type of function returns one value for each Invocation?

A. Window

B. Aggregate

C. Table

D. Scalar

正解：D 解答を投票する

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

出題：17

What can be interpreted based on the number of nodes reported in a Query Profile?

A. Data spillage

B. Compute required for metadata management

C. Network bandwidth during query execution

D. Query execution time

正解：D 解答を投票する

出題：18

A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.
Which Snowflake do it the user's IP address does not match the user-level network policy rules?

A. Log the user out.

B. Prevent the user from executing additional queries.

C. Allow the user to continue until the session or login token expires.

D. Deactivate the network policy.

正解：B 解答を投票する

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