← Back to exam page

Free SNOWPRO-ADVANCED-DATA-ENGINEER – Snowflake SNOWPRO-ADVANCED-DATA-ENGINEER Practice Test Question

Loading demo links...

Showing 1–3 of 13 questions

Question 1 (Topic 1)

A Data Engineer executes a complex query and wants to make use of Snowflake’s query results caching capabilities to reuse the results. Which conditions must be met? (Choose three.)

Select an option, then click Submit answer.

  • ○ The results must be reused within 72 hours.
  • ○ The query must be executed using the same virtual warehouse.
  • ○ The USED_CACHED_RESULT parameter must be included in the query.
  • ○ The table structure contributing to the query result cannot have changed.
  • ○ The new query must have the same syntax as the previously executed query.
  • ○ The micro-partitions cannot have changed due to changes to other data in the table.
Question 2 (Topic 1)

The JSON below is stored in a VARIANT column named V in a table named jCustRaw: Which query will return one row per team member (stored in the teamMembers array) along with all of the attributes of each team member?

Select an option, then click Submit answer.

  • ○

  • ○

  • ○

  • ○

Question 3 (Topic 1)

A Data Engineer is working on a continuous data pipeline which receives data from Amazon Kinesis Firehose and loads the data into a staging table which will later be used in the data transformation process. The average file size is 300-500 MB. The Engineer needs to ensure that Snowpipe is performant while minimizing costs. How can this be achieved?

Select an option, then click Submit answer.

  • ○ Increase the size of the virtual warehouse used by Snowpipe.
  • ○ Split the files before loading them and set the SIZE_LIMIT option to 250 MB.
  • ○ Change the file compression size and increase the frequency of the Snowpipe loads.
  • ○ Decrease the buffer size to trigger delivery of files sized between 100 to 250 MB in Kinesis Firehose.