SnowPro Advanced: Architect — Question 89

Which technique will efficiently ingest and consume semi-structured data for Snowflake data lake workloads?

Answer options

• A. IDEF1X
• B. Schema-on-write
• C. Schema-on-read
• D. Information schema

Correct answer: C

Explanation

The correct answer, Schema-on-read, allows for flexibility in handling semi-structured data by applying a schema at the time of querying rather than during data ingestion. In contrast, Schema-on-write requires a predefined schema, which can be restrictive for semi-structured data formats. IDEF1X and Information schema are not relevant techniques for data ingestion in this context.