Examers.io
ExamsOrganizationsHow it worksPricingHelp & FAQ
Sign inStart free
Snowflake logo

SnowflakeSnowPro Advanced — Data Engineer

Domain 2Objective 3

Process Semi-Structured Data DEA-C02 Practice Questions (Page 3)

Part of the Data Transformation domain, which accounts for 25% of the DEA-C02 exam.

12questions here
3free pages
8concepts
25%of the exam

Questions 11–12

  1. 11foundation · medium

    While transforming semi-structured data, a data engineer needs to ensure that when a nested field is absent from the source record, the target column receives a NULL instead of causing the transformation to fail. Which Snowflake function or construct is designed to return NULL when a specified path does not exist in a VARIANT value?

    Select an answer first
  2. 12foundation · easy

    Which Snowflake function extracts an attribute from an XML element stored in a VARIANT?

    Select an answer first
Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DEA-C02

Keep studying — Data Transformation

Full DEA-C02 curriculum →Every domain, objective & concept — with linked practiceDEA-C02 exam overview →Snowflake SnowPro Advanced — Data Engineer

Other objectives in Data Transformation

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “DEA-C02” is a trademark of its owner, used for identification only.