COF-C03問題集、Snowflake実際の試験問題

質問 1

Which Snowflake data governance feature can support auditing when a user query reads column data?

A. Object dependencies

B. Column-level security

C. Access History

D. Data classification

正解: C

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

質問 2

What happens when a cloned table is replicated to a secondary database? (Select TWO)

A. Metadata pointers to cloned tables are replicated

B. The physical data is replicated

C. A read-only copy of the cloned tables is stored.

D. The replication will not be successful.

E. Additional costs for storage are charged to a secondary account

正解: A,B

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

質問 3

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

A. Local disk caching

B. Query processing

C. Database storage

D. Metadata management

E. Authentication and access control

正解: D,E

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

質問 4

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

A. Allows a user to import the files in a sequential order

B. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

C. Increases the latency staging and accuracy when loading the data

D. Allows optimization of parallel operations

正解: D

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

質問 5

How are serverless features billed?

A. Per second multiplied by an automatic sizing for the job

B. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

D. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

正解: D

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

質問 6

When cloning a database, what is cloned with the database? (Choose two.)

A. Existing child objects within the database

B. Only schemas and tables within the database

C. Future child objects within the database

D. Privileges on the database

E. Privileges on the schemas within the database

正解: A,D

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

質問 7

What is a feature of column-level security in Snowflake?

A. Internal tokenization

B. Role access policies

C. External tokenization

D. Network policies

正解: B

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

質問 8

When do Snowflake object owners lose their ability to make grant decisions?

A. When the object owner has been granted an account role

B. When the object owner has been granted a database role

C. When the object is part of a regular schema

D. When the object is part of a managed access schema

正解: D

質問 9

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

A. Internal tokenization

B. Tags

C. Row access policies

D. Comments

正解: B

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

質問 10

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A. Time Travel

B. Fail-safe

C. Data encryption

D. Tri-Secret Secure

E. External stages

正解: A,B

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

質問 11

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

A. Maintaining Availability Zones

B. Management of metadata

C. Infrastructure security

D. Parsing and optimizing queries

E. Computing the data

正解: B,D

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

質問 12

How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

A. A defined level of access to an object

B. Each object has an owner, who can in turn grail access to that object.

C. An entity in which access can be granted

D. Access privileges are assigned to roles. which are in turn assigned to use's

正解: D

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

質問 13

What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

A. WRTTF

B. READ

C. USAGK

D. OWNERSHIP

正解: B

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

Snowflake SnowPro® Core Certification (COF-C03) - COF-C03 模擬練習