최신 COF-C01 무료덤프 - Snowflake SnowPro Core Certification

문제1

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

A. 4

B. 128

C. 16

D. 32

정답: A

문제2

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

A. Via the Snowflake Web Interface (Ul)

B. Via the data_share=true parameter

C. Via SQL commands

D. Via Virtual Warehouses

정답: A,C

문제3

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A. True

B. False

정답: A

문제4

Which of the following are common use cases for zero-copy cloning? Choose 3 answers

A. Performance optimization

B. Quick provisioning of Dev and Test/QA environments

C. Point in time snapshots

D. Data backups

정답: B,C,D

문제5

Which are true of Snowflake roles?

A. The public role controls at other roles

B. Roles are a subset of users and users own objects In Snowflake

C. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation

D. All grants to objects are given to roles, and never to users

정답: C,D

문제6

What is the maximum compressed row size in Snowflake?

A. 16MB

B. 50MB

C. 4000GB

D. 8KB

정답: A

문제7

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

A. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

B. Their default role should be set to SYSTEMADMIN (the lower of the two)

C. They should use the SYSADMIN role to perform administrative work on database objects

D. They should not set up multi_Factor Authentication (MFA)-as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

E. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

정답: B,C,E

문제8

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

A. True

B. False

정답: B

문제9

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

A. True

B. False

정답: A

문제10

True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

A. True

B. False

정답: B

최신 COF-C01 무료덤프 - Snowflake SnowPro Core Certification

우리와 연락하기

유용한 링크

최신 업데이트