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

  1. Question 30: A Data Engineer wants to check the status of a pipe named my_pipe. The pipe is inside a database named test and a schema named Extract (case-sensitive). Which…
  2. Question 31: Company A and Company B both have Snowflake accounts. Company A's account is hosted on a different cloud provider and region than Company B's account. Companie…
  3. Question 33: 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 la…
  4. Question 34: Within a Snowflake account. permissions have been defined with custom roles and role hierarchies. To set up column-level masking using a role in the hierarchy…
  5. Question 35: Assuming a Data Engineer has all appropriate privileges and context, which statements would be used to assess whether the User-Defined Function (UDF), MYDATABA…
  6. Question 36: A Data Engineer has written a stored procedure that will run with caller's rights. The Engineer has granted ROLEA the right to use this stored procedure. What…
  7. Question 37: What is a characteristic of the use of binding variables in JavaScript stored procedures in Snowflake?
  8. Question 38: Which use case would be BEST suited for the search optimization service?
  9. Question 39: What is a characteristic of the operations of streams in Snowflake?
  10. Question 40: At what isolation level are Snowflake streams?