Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

27
Students signed up in the last 24H

Snowflake SnowPro Advanced Data Engineer Exam Actual Questions

The questions for SnowPro Advanced Data Engineer were last updated on May 13, 2024.
  • Viewing page 1 out of 17 pages.
  • Viewing questions 1-4 out of 65 questions
 

Topic 1 - Exam A

Question #1 Topic 1

A Data Engineer is investigating a query that is taking a long time to return. The Query Profile shows the following:

What step should the Engineer take to increase the query performance?

  • A. Add additional virtual warehouses.
  • B. Increase the size of the virtual warehouse.
  • C. Rewrite the query using Common Table Expressions (CTEs).
  • D. Change the order of the joins and start with smaller tables first.
Reveal Solution Hide Solution   Discussion   2

Correct Answer: B 🗳️

Question #2 Topic 1

How can the following relational data be transformed into semi-structured data using the LEAST amount of operational overhead?

  • A. Use the TO_JSON function.
  • B. Use the PARSE_JSON function to produce a VARIANT value.
  • C. Use the OBJECT_CONSTRUCT function to return a Snowflake object.
  • D. Use the TO_VARIANT function to convert each of the relational columns to VARIANT.
Reveal Solution Hide Solution   Discussion   5

Correct Answer: C 🗳️

Question #3 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.)

  • A. The results must be reused within 72 hours.
  • B. The query must be executed using the same virtual warehouse.
  • C. The USED_CACHED_RESULT parameter must be included in the query.
  • D. The table structure contributing to the query result cannot have changed.
  • E. The new query must have the same syntax as the previously executed query.
  • F. The micro-partitions cannot have changed due to changes to other data in the table.
Reveal Solution Hide Solution   Discussion   10

Correct Answer: EDF 🗳️

Question #4 Topic 1

A Data Engineer needs to load JSON output from some software into Snowflake using Snowpipe.
Which recommendations apply to this scenario? (Choose three.)

  • A. Load large files (1 GB or larger).
  • B. Ensure that data files are 100-250 MB (or larger) in size, compressed.
  • C. Load a single huge array containing multiple records into a single table row.
  • D. Verify each value of each unique element stores a single native data type (string or number).
  • E. Extract semi-structured data elements containing null values into relational columns before loading.
  • F. Create data files that are less than 100 MB and stage them in cloud storage at a sequence greater than once each minute.
Reveal Solution Hide Solution   Discussion   3

Correct Answer: BDE 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel