Free Practice Questions for SnowPro Core Certification Exam (COF-C02) (COF-C02)

A. The stage definition

B. The table definition

C. The use of a copy into statement

D. The use of a copy INTO statement

Correct Answer: C
When loading data into Snowflake, the file format options specified in theCOPY INTO <table>statement take the highest precedence over other locations such as the stage or table definitions. This ensures that any specific settings for a particular load operation are applied correctly.
✑ File Format Hierarchy:
✑ Example Usage: COPY INTO my_table FROM @my_stage
FILE_FORMAT = (FORMAT_NAME = 'my_format' FIELD_OPTIONALLY_ENCLOSED_BY
= '"');
References:
✑ Snowflake Documentation: Copy into Table
✑ Snowflake Documentation: File Format Options

QUESTION 117

- (Topic 3)
What is the recommended way to change the existing file format type in my format from CSV to JSON?

A. ALTER FILE FORMAT my_format SET TYPE=JSON;
B. ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
C. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
D. REPLACE FILE FORMAT my format TYPE-JSON;

Correct Answer: A
To change the existing file format type from CSV to JSON, the recommended way is to use the ALTER FILE FORMAT command with the SET TYPE=JSON clause. This alters the file format specification to use JSON instead of CSV. References: Based on my internal knowledge as of 2021.

QUESTION 118

- (Topic 3)
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

A. Authy
B. Duo Security
C. One Login
D. RSA SecurlD Access

Correct Answer: B
Snowflake integrates Duo Security to support Multi-Factor Authentication (MFA). This feature provides increased login security for users connecting to Snowflake, and it is managed completely by Snowflake without the need for users to sign up separately with Duo4.

QUESTION 119

- (Topic 3)
How many network policies can be assigned to an account or specific user at a time?

A. One
B. Two
C. Three
D. Unlimited

Correct Answer: A
According to my knowledge, a security administrator can create multiple network policies, but only one network policy can be active for an account or specific user at any given time. This ensures that there is a clear and consistent policy being applied without conflicts. References: Based on my internal knowledge as of 2021.

QUESTION 120

- (Topic 6)
What does a table with a clustering depth of 1 mean in Snowflake?

A. The table has only 1 micro-partition.
B. The table has 1 overlapping micro-partition.
C. The table has no overlapping micro-partitions.
D. The table has no micro-partitions.

Correct Answer: C
In Snowflake, a table's clustering depth indicates the degree of micro- partition overlap based on the clustering keys defined for the table. A clustering depth of 1 implies that the table has no overlapping micro-partitions. This is an optimal scenario, indicating that the table's data is well-clustered according to the specified clustering keys. Well-clustered data can lead to more efficient query performance, as it reduces the amount of data scanned during query execution and improves the effectiveness of data pruning. References:
✑ Snowflake Documentation on Clustering: Understanding Clustering Depth

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

Want to Unlock All Questions for this Exam?
98.4% Pass Rate

Full Exam Access

COF-C02 Dumps

COF-C02 Free Practice Test

Snowflake COF-C02: SnowPro Core Certification Exam (COF-C02)

Practice Test