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 8 of 11.

  1. Question 85: What action could a Data Engineer take to increase the query performance of an external table?
  2. Question 86: To meet governance requirements, a company needs to completely isolate its production environment from its development and testing environments. The solution m…
  3. Question 87: A Data Engineer would like to create a new empty table named CURRENT_STUDENT_COPY_DATA that has the same structure as the table CURRENT_STUDENT. Which statemen…
  4. Question 88: A table, mytable, is created using the following command in a schema called raw: create table mytable(col1 number, col2 date) data_retention_time_in_days=90; T…
  5. Question 89: A Data Engineer is creating a pipe by executing the following statement: create or replace pipe mypipe auto_ingest=true as copy into mytable from @mystage; The…
  6. Question 90: How can a directory table be used when working with unstructured data? (Choose two.)
  7. Question 91: A Data Engineer is using a Snowflake Standard edition and has an external function in schema A, a view in schema B, and then creates a SHARE and adds the view…
  8. Question 92: A Data Engineer is debugging a SQL stored procedure that contains a transaction with a rollback using this code: DROP TABLE A1; CREATE OR REPLACE TABLE A1(i in…
  9. Question 93: A Data Engineer needs to obtain details about data loading history for tables in a specific database and schema. The tables were loaded using Snowpipe in the l…
  10. Question 94: A Data Engineer is developing a data pipeline to ingest data from an Amazon S3 bucket into a Snowflake table. Files will be loaded into the S3 bucket randomly,…