SnowPro Advanced Data Engineer Exam

Exam SnowPro Advanced Data Engineer All QuestionsBrowse all questions from this exam

Question 22

A Data Engineer needs to ingest invoice data in PDF format into Snowflake so that the data can be queried and used in a forecasting solution.

What is the recommended way to ingest this data?

Use Snowpipe to ingest the files that land in an external stage into a Snowflake table.

Use a COPY INTO command to ingest the PDF files in an external stage into a Snowflake table with a VARIANT column.

Create an external table on the PDF files that are stored in a stage and parse the data into structured data.

Create a Java User-Defined Function (UDF) that leverages Java-based PDF parser libraries to parse PDF data into structured data.

Correct Answer: D

To ingest PDF data into Snowflake and make it queryable, creating a Java User-Defined Function (UDF) that leverages Java-based PDF parser libraries is the most recommended approach. This method allows you to parse the PDF data directly into structured data, which can then be ingested into Snowflake tables for querying and use in forecasting solutions. Other options do not address the need for parsing the PDF format into a structured format that can be easily queried.

Discussion

Snow_POption: D

Using python or java libraries so I guess D