Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. SnowPro Advanced Data Engineer

Snowflake SnowPro Advanced Data Engineer Exam Questions
SnowPro Advanced Data Engineer (Page 3 )

Updated On: 19-Feb-2026
Page 3 of 24
PDF with 162 Questions

Which Snowflake objects does the Snowflake Kafka connector use? (Choose three.)

  1. Pipe
  2. Serverless task
  3. Internal user stage
  4. Internal table stage
  5. Internal named stage
  6. Storage integration

Answer(s): A,D,E



A Data Engineer is implementing a near real-time ingestion pipeline to load data into Snowflake using the Snowflake Kafka connector. There will be three Kafka topics created.

Which Snowflake objects are created automatically when the Kafka connector starts? (Choose three.)

  1. Tables
  2. Tasks
  3. Pipes
  4. Internal stages
  5. External stages
  6. Materialized views

Answer(s): A,C,D



Which stages support external tables?

  1. Internal stages only; within a single Snowflake account
  2. Internal stages only; from any Snowflake account in the organization
  3. External stages only; from any region, and any cloud provider
  4. External stages only; only on the same region and cloud provider as the Snowflake account

Answer(s): C



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 query will provide the status of the pipe?

  1. SELECT SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");
  2. SELECT SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
  3. SELECT * FROM SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
  4. SELECT * FROM SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");

Answer(s): B



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. Companies A and B are not in the same Snowflake organization.

How can Company A share data with Company B? (Choose two.)

  1. Create a share within Company A's account and add Company B's account as a recipient of that share.
  2. Create a share within Company A's account, and create a reader account that is a recipient of the share.
    Grant Company B access to the reader account.
  3. Use database replication to replicate Company A's data into Company B's account. Create a share within Company B's account and grant users within Company B's account access to the share.
  4. Create a new account within Company A's organization in the same cloud provider and region as Company B's account. Use database replication to replicate Company A's data to the new account. Create a share within the new account, and add Company B's account as a recipient of that share.
  5. Create a separate database within Company A's account to contain only those data sets they wish to share with Company B. Create a share within Company A's account and add all the objects within this separate database to the share. Add Company B's account as a recipient of the share.

Answer(s): A,B






Post your Comments and Discuss Snowflake SnowPro Advanced Data Engineer exam dumps with other Community members:

Join the SnowPro Advanced Data Engineer Discussion