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

出題：1

What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

A. FIELD_OPTIONALLY_ENCLOSED_BY

B. ESCAPE_UNENCLOSED_FIELD

C. BINARY_FORMAT

D. SKIP BYTE ORDER MARK

正解：A 解答を投票する

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

出題：2

How can a Snowflake user traverse semi-structured data?

A. Insert a double colon (: :) between the VARIANT column name and any second-level element.

B. Insert a colon (:) between the VARIANT column name and any second-level element. C. Insert a double colon (: :) between the VARIANT column name and any first-level element.

C. Insert a colon (:) between the VARIANT column name and any first-level element.

正解：C 解答を投票する

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

出題：3

Which Snowflake view is used to support compliance auditing?

A. COPY_HISTORY

B. ROW ACCESS POLICIES

C. QUERY_HISTORY

D. ACCESS_HISTORY

正解：D 解答を投票する

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

出題：4

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

A. DATA_TRANSFER_HISTORY

B. WAREHOUSE_METERING_HISTORY

C. MONETIZED_USAGE_DAILY

D. ACCESS_HISTORY

E. LISTING TELEMETRY DAILY

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

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

出題：5

Which function should be used to find the query ID of the second query executed in a current session?

A. Select LAST_QUERY_ID(-2)

B. Select LAST_QUERY_ID(2)

C. Select LAST_QUERY_ID(2)

D. Select LAST_QUERY_ID(1)

正解：A 解答を投票する

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

出題：6

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

A. Running COPY commands

B. Running EXPLAIN and SHOW commands

C. Caching query results

D. Running a custom query

E. Cloning a database

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

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

出題：7

Why would a Snowflake user decide to use a materialized view instead of a regular view?

A. The query is not resource intensive.

B. The query results are not used frequently.

C. The base tables do not change frequently.

D. The results of the view change often.

正解：C 解答を投票する

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

出題：8

Which of the following describes a Snowflake stored procedure?

A. They can contain only a single SQL statement.

B. They can only access tables from a single database.

C. They can be created to run with a caller's rights or an owner's rights.

D. They can be created as secure and hide the underlying metadata from the user.

正解：C 解答を投票する

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

出題：9

Which function should be used to insert JSON format string data inot a VARIANT field?

A. CHECK_JSON

B. PARSE_JSON

C. TO_VARIANT

D. FLATTEN

正解：B 解答を投票する

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

出題：10

When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? {Select TWO).

A. output_file

B. force_put_overwrite

C. output_format

D. echo

E. quiet

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

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

出題：11

What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

A. 1 Terabyte (TB)

B. 1 Kilobyte (KB)

C. 1 Megabyte (MB)

D. 1 Gigabyte (GB)

正解：A 解答を投票する

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

出題：12

Which command removes a role from another role or a user in Snowflak?

A. REVOKE ROLE

B. USE SECONDARY ROLES

C. ALTER ROLE

D. USE ROLE

正解：A 解答を投票する

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

出題：13

Which types of subqueries does Snowflake support? (Select TWO).

A. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only

B. EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

C. EXISTS, ANY / ALL, and IN subqueries in where clauses: these subqueries can be correlated only

D. Uncorrelated scalar subqueries in any place that a value expression can be used

E. Uncorrelated scalar subqueries in WHERE clauses

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

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

出題：14

Which user object property requires contacting Snowflake Support in order to set a value for it?

A. MINS TO BYPASS MFA

B. MINS TO BYPASS NETWORK POLICY

C. DISABLED

D. MINS TO UNLOCK

正解：A 解答を投票する

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

出題：15

A stream can be created on which Snowflake objects to record data manipulation language(DML) changes?
(Select TWO).

A. Standard tables

B. Standard views

C. Schemas

D. Standard tables

E. Database

F. Pipes

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

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

出題：16

Which role has the ability to create and manage users and roles?

A. SYSADMIN

B. SECURITYADMIN

C. ORGADMIN

D. USERADMIN

正解：D 解答を投票する

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

出題：17

What is a responsibility of Snowflake's virtual warehouses?

A. Permanent storage of micro-partitions

B. Query execution

C. Query parsing and optimization

D. Metadata management

E. Infrastructure management

正解：B 解答を投票する

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

出題：18

User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?

A. User2 will be unable to view the result set of the query executed by User1.

B. If User2 has the securityadmin role they will be able to see the results.

C. If User2 has the ACCOUNTADMIN role they will be able to see the results.

D. If User2 has the sysadmin role they will be able to see the results.

正解：C 解答を投票する

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

出題：19

Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

A. RSA SecurlD Access

B. Duo Security

C. Authy

D. One Login

正解：B 解答を投票する

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

出題：20

Which commands can only be executed using SnowSQL? (Select TWO).

A. GET

B. COPY INTO

C. REMOVE

D. LIST

E. PUT

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

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

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