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

出題：1

Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

A. USAGE_VIEWER

B. OBJECT_VIEWER

C. SECURITY_VIEWER

D. GOVERNANCE_VIEWER

正解：D 解答を投票する

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

出題：2

What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

A. 7 days

B. 1 day

C. 14 days

D. 0 days

正解：D 解答を投票する

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

出題：3

Which Snowflake feature can be used to find sensitive data in a table or column?

A. Masking policies

B. Data classification

C. External functions

D. Row level policies

正解：B 解答を投票する

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

出題：4

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A. Changing a column that is not in the cached query

B. Executing the RESULTS_SCAN() table function

C. Stopping the virtual warehouse that the query is running against

D. Clustering of the data used by the query

E. Removing a column from the query SELECT list

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

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

出題：5

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

A. Secure User Defined Functions (UDFs)

B. Sequences

C. Tables

D. Materialized views

E. Procedures

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

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

出題：6

Which command is used to unload data from a Snowflake table into a file in a stage?

A. EXTRACT INTO

B. GET

C. COPY INTO

D. WRITE

正解：C 解答を投票する

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

出題：7

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

A. Reorder the rows in a relational table and then unload the rows into a file

B. Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

C. Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

D. Reorder the data columns according to a target table definition and then unload the rows into the table.

正解：C 解答を投票する

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

出題：8

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.
How can this be accomplished?

A. select dealership from car_sales;

B. select src:Dealership from car_sales;

C. select src.dealership from car_sales;

D. select src:dealership from car_sales;

正解：C 解答を投票する

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

出題：9

A user wants to upload a file to an internal Snowflake stage using a put command.
Which tools and or connectors could be used to execute this command? (Select TWO).

A. SnowCD

B. SQL API

C. Python connector

D. SnowSQL

E. Snowsight worksheets

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

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

出題：10

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

A.

B.

C.

D.

正解：C 解答を投票する

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

出題：11

Which Snowflake object does not consume any storage costs?

A. Materialized view

B. Transient table

C. Secure view

D. Temporary table

正解：D 解答を投票する

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

出題：12

Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?

A. JAROWINKLER_SIMILARITY

B. MINHASH COMBINE

C. APPROXIMATE_SIMILARITY

D. APPROXIMATE_JACCARD_INDEX

正解：A 解答を投票する

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

出題：13

What is the MAXIMUM Time Travel retention period for a transient table?

A. 90 days

B. 7 days

C. 1 day

D. O days

正解：C 解答を投票する

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

出題：14

What is the minimum Snowflake edition required to create a materialized view?

A. Standard Edition

B. Business Critical Edition

C. Virtual Private Snowflake Edition

D. Enterprise Edition

正解：D 解答を投票する

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

出題：15

What step can reduce data spilling in Snowflake?

A. Increasing the amount of remote storage for the virtual warehouse

B. Using a common table expression (CTE) instead of a temporary table

C. Using a larger virtual warehouse

D. Increasing the virtual warehouse maximum timeout limit

正解：C 解答を投票する

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

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