COF-R02試験無料問題集（332題）「Snowflake SnowPro Core Recertification 認定」

出題：1

Which of the following statement is true of Snowflake?
Select one.

A. it was built as an on-premises solution and then potted to the cloud

B. It was built specifically for the cloud

C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D. It's based on an Oracle Architecture

E. It was built for Hadoop architecture

正解：B 解答を投票する

出題：2

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

A. SHOW GRANTS TO USER INQUISITIVE_PERSON

B. SHOW GRANTS OF ROLE DATA_SCIENCE

C. SHOW GRANTS ON ROLE DATA_SCIENCE

D. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

正解：D 解答を投票する

出題：3

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

A. Parquet

B. JPEG

C. PDF

D. Avro

E. TSV

F. JSON

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

出題：4

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

A. IBM Cloud

B. Google Cloud Platform

C. Amazon Web Services

D. Oracle Cloud

E. Microsoft Azure Cloud

F. Docker

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

出題：5

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

A. The clone is created almost instantly.

B. The clone will have time travel history from the original table.

C. The clone saves space by not duplicating storage.

D. The clone always stays in sync with the original table.

E. The clone has better query performance.

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

出題：6

What are the default Time Travel and Fail-safe retention periods for transient tables?

A. Transient tables are retained in neither Fail-safe nor Time Travel

B. Time Travel - 1 day. Fail-safe - 1 day

C. Time Travel - 0 days. Fail-safe - 1 day

D. Time Travel - 1 day. Fail-safe - 0 days

正解：D 解答を投票する

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

出題：7

Network policies can be set at which Snowflake levels? (Choose two.)

A. Account

B. Role

C. Database

D. User

E. Tables

F. Schema

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

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

出題：8

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

A. 60 Days

B. 90 Days

C. 30 Days

D. 365 Days.

正解：D 解答を投票する

出題：9

True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

A. True

B. False

正解：A 解答を投票する

出題：10

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)

A. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

B. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

C. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

D. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

E. The ACCOUNTADMIN role must be granted to only one user.

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

出題：11

Which Snowflake tool would be BEST to troubleshoot network connectivity?

A. SnowUI

B. SnowCD

C. SnowCLI

D. SnowSQL

正解：B 解答を投票する

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

出題：12

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

A. The operation will fail with the error uncertain files in stage.

B. All data from only the newly-added files will be appended to the table.

C. Only data about new customers from the new files will be appended to the table

D. All data from all of the files on the stage will be appended to the table

正解：D 解答を投票する

出題：13

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A. Each Snowflake account can be hosted in a different cloud vendor and region.

B. Each Snowflake account must be hosted in a different cloud vendor and region

C. All Snowflake accounts must be hosted in the same cloud vendor and region

D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

正解：B 解答を投票する

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

出題：14

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

A. GET

B. SELECT

C. COPY

D. PUT

正解：A 解答を投票する

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

出題：15

Which type of table corresponds to a single Snowflake session?

A. Permanent

B. Temporary

C. Provisional

D. Translent

正解：B 解答を投票する

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

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