Snowflake COF-R02 Practice Test – Member Shared Questions, Page 7

Question 61

How a Snowpipe charges calculated?

A.

Per-second/per Warehouse size

B.

Per-second/per-core granularity

C.

Number of Pipes in account

D.

Total storage bucket size

Show Answer Comment (0)

Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

asked 23/09/2024

Tiro malope

43 questions

Question 62

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

A.

True

B.

False

Show Answer Comment (0)

Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

asked 23/09/2024

Mehr Khan

42 questions

Question 63

True or False: Snowflake supports federated authentication in all editions.

A.

True

B.

False

Show Answer Comment (0)

Suggested answer: A

Explanation:

Reference: https://community.snowflake.com/s/news/federated-authentication-sso-now-availablein-all-snowflake-editions-MC6N3I63LJGNGMHCTKGKFDH4NH2Q

asked 23/09/2024

Tom Bodett

40 questions

Question 64

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

A.

True

B.

False

Show Answer Comment (0)

Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

asked 23/09/2024

Nicolas Da Silva

45 questions

Question 65

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

A.

True

B.

False

Show Answer Comment (0)

Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

asked 23/09/2024

JEROME SANANES

46 questions

Question 66

True or False: During data unloading, only JSON and CSV files can be compressed.

A.

True

B.

False

Show Answer Comment (0)

Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

asked 23/09/2024

wilson rodriguez

41 questions

Question 67

True or False: Data Providers can share data with only the Data Consumer.

A.

True

B.

False

Show Answer Comment (0)

Suggested answer: B

Explanation:

Topic 2, Exam pool B

asked 23/09/2024

Rajesh Gurav

32 questions

Question 68

The fail-safe retention period is how many days?

A.

1 day

B.

7 days

C.

45 days

D.

90 days

Show Answer Comment (0)

Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

asked 23/09/2024

Naveen Kotipalli

40 questions

Question 69

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A.

True

B.

False

Show Answer Comment (0)

Suggested answer: A

Explanation:

You can experiment the same with snowflake UI.

asked 23/09/2024

Bart Sandifort

38 questions

Question 70

How would you determine the size of the virtual warehouse used for a task?

A.

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B.

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C.

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D.

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule