ExamTopics Logo
Mail Us[email protected]
Menu
 

SnowPro Advanced Data Engineer Actual Exam Questions

Last updated on Dec. 16, 2024.
Vendor:Snowflake
Exam Code:SnowPro Advanced Data Engineer
Exam Name:SnowPro Advanced Data Engineer
Exam Questions:65
97% Passed the exam with this material
 

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   3

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   7

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   11

Correct Answer: DEF 🗳️

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 🗳️

file Viewing page 1 out of 17 pages.
Viewing questions 1-4 out of 65 questions
Next Questions
Browse atleast 50% to increase passing rate cup
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.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago