Online Access Free Snowflake.COF-C02.v2024-07-08.q327 Practice Test (Page 47)

COF-C02 Exam Question 226

True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

A.True

B.False

COF-C02 Exam Question 227

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

A.TSV

B.JSON

C.PDF

D.Avro

E.Parquet

F.JPEG

COF-C02 Exam Question 228

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?

A.GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

B.GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C.ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D.GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

COF-C02 Exam Question 229

While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).

A.GEOMETRY

B.BINARY

C.GEOGRAPHY

D.VARIANT

E.OBJECT

COF-C02 Exam Question 230

True or False: A Virtual Warehouse can be resized while suspended.