Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

A user needs to automatically retrieve Iceberg column definitions using the INFER_SCHEMA function for semi-structured...

Snowflake COF-C03 Full Course Access
Snowflake COF-C03 View All Questions

A user needs to automatically retrieve Iceberg column definitions using the INFER_SCHEMA function for semi-structured files stored on a stage. Which file format configuration will help them achieve this?

A.

CREATE FILE FORMAT my_ff TYPE = ORC;

B.

CREATE FILE FORMAT my_ff TYPE = AVRO;

C.

CREATE FILE FORMAT my_ff TYPE = PARQUET USE_VECTORIZED_SCANNER = TRUE;

D.

CREATE FILE FORMAT my_ff TYPE = PARQUET USE_VECTORIZED_SCANNER = FALSE;

COF-C03 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now COF-C03 pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
How does Snowflake utilize clustering information to improve query performance?
Why would a Snowflake user load JSON data into a VARIANT column instead of a...
Previous