SnowPro Advanced: Data Engineer Free Practice Exam Questions

105 real SnowPro Advanced: Data Engineer exam questions with answers and AI explanations. Snowflake certification prep — page 9 of 11.

  1. Question 97: A Data Engineer is using Time Travel to clone a table using this query: CREATE TABLE MY_TABLE_CLONE CLONE MY_TABLE AT (OFFSET => -60*30); An error is returned.…
  2. Question 98: How can a Data Engineer return all the errors encountered during a previous file upload that used the COPY command?
  3. Question 99: A company is running several machine learning models that were developed in Scala and are running on-premises. A Data Engineer has been asked to design a solut…
  4. Question 100: How are overlapping columns handled when joining DataFrames in Snowpark?
  5. Question 101: A Data Engineer needs to monitor data usage patterns, performance metrics, and query efficiency to optimize the data workloads in a Snowflake account. The Engi…
  6. Question 102: A tag named DEPARTMENT has two values, MARKETING and FINANCE. Which command will add a third value, ENGINEERING, to the tag?
  7. Question 103: A Data Engineer is planning to run a set of Data Metric Functions (DMFs) against a table using this query: select snowflake.core.max( select c_name from snowfl…
  8. Question 104: A Data Engineer is trying to clone a very large table from a source environment that has set DATA_RETENTION_TIME_IN_DAYS = 0. During the cloning operation, Dat…
  9. Question 105: When working with semi-structured data in a VARIANT column, which Snowflake functions will allow a user to write queries that extract values using a hierarchy…
  10. Question 106: A retail store's application team needs to build a loyalty program for their customers. The customer table contains Personal Identifiable Information (PII), an…