SnowPro-Core無料問題集「Snowflake SnowPro Core Certification」

質問 1

How often are the Account and Table master keys automatically rotated by Snowflake?

（A）30 Days

（B）90 Days

（C）365 Days.

（D）60 Days

正解：A 解答を投票する

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

質問 2

How would a user run a multi-cluster warehouse in maximized mode?

（A）Configure the maximum clusters setting to "Maximum."

（B）Set the minimum clusters and maximum clusters settings to different values.

（C）Set the minimum Clusters and maximum Clusters settings to the same value.

（D）Turn on the additional clusters manually after starting the warehouse.

正解：C 解答を投票する

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

質問 3

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

（A）File URL

（B）Scoped URL

（C）Relative URL

（D）Pre-Signed URL

正解：B 解答を投票する

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

質問 4

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

（A）Duo Security

（B）RSA SecurlD Access

（C）Authy

（D）One Login

正解：A 解答を投票する

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

質問 5

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

（A）Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.

（B）Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days.

（C）Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days.

（D）Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days.

（E）Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day.

（F）Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.

正解：F 解答を投票する

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

質問 6

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

（A）SYSTEMADMIN

（B）USERADMIN

（C）SECURITYADMIN

（D）ACCOUNTADMIN

（E）ORGADMIN

正解：C、D 解答を投票する

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

質問 7

Which function returns the URL of a stage using the stage name as the input?

（A）GET_PRESIGNED_URL

（B）GET STAGE LOCATION

（C）BUILD_STAGE_FILE_URL

（D）BUILD_SCOPED_FILE_URL

正解：A 解答を投票する

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

質問 8

How can a data provider ensure that a data consumer is going to have access to the required objects?

（A）Enable the data sharing feature in the account and validate the view.

（B）Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

（C）Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

（D）Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

正解：A 解答を投票する

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

質問 9

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

（A）Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

（B）Smaller micro-partitions are created for common data values to allow for more parallelism

（C）Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

（D）Data is hashed by the cluster key to facilitate fast searches for common data values

正解：A 解答を投票する

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

質問 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）

正解：B 解答を投票する

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

質問 11

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

（A）Query parsing and optimization

（B）Physical storage of micro-partitions

（C）Query execution

（D）Authentication

（E）Resource management

（F）Virtual warehouse caching

正解：A、D、E 解答を投票する

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

質問 12

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

（A）echo

（B）force_put_overwrite

（C）quiet

（D）output_format

（E）output_file

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

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

質問 13

A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?

（A）Source_column.element[1]:name

（B）Source_column.element[1].name

（C）Source_column.element[0]:name

（D）Source_column.element[0]:name

正解：B 解答を投票する

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

SnowPro-Core 無料問題集「Snowflake SnowPro Core Certification」

弊社を連絡する

関連リンク

トップ試験