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

문제1

Which of the following commands are not blocking operations?
Choose 2 answers

A. MERGE

B. UPDATE

C. INSERT

D. COPY

정답: C,D

문제2

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)
Choose 2 answers

A. HIVE

B. R

C. SnowSQL

D. ODBC

정답: C,D

문제3

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

A. True

B. False

정답: B

문제4

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

A. More micro-partitions

B. Better query scheduling

C. Double the numbers of servers In the compute duster

D. Higher storage costs

정답: C

문제5

Snowflake is designed for which type of workloads? (Choose two.)

A. On-premise workloads

B. OLTP (Transactional) workloads

C. OLAP (Analytics) workloads

D. Concurrent workloads

정답: C,D

문제6

Which of the following statements is true of Snowflake?

A. It was built specifically for the cloud

B. It was built as an on-premises solution and then ported to the cloud

C. It was built for Hadoop architecture

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

E. It's based on an Oracle Architecture

정답: A

문제7

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

A. True

B. False

정답: B

문제8

Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

A. SHOW STORAGE BY TABLE;

B. Information Schema -> TASLE_HISTORY

C. Information Schema -> TABLE_STORAGE_METRICS

D. SHOW TABLES;

정답: C,D

문제9

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

A. MIN(< < column value>>)

B. UPDATE

C. COPY

D. SUM(<< column value >>)

정답: B,C,D

문제10

How would you execute a series of SQL statements using Task?

A. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);

B. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1 where ..

C. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

D. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():

정답: D

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

우리와 연락하기

유용한 링크

최신 업데이트