SnowPro Advanced: Data Engineer

A data engineer has already staged a set of Parquet files and now wants to load them into a target Snowflake table. Which command performs the actual load step?

• AMERGE INTO
• BCOPY INTO <table>
• CPUT
• DGET

A team wants an external stage on S3 without embedding long-lived cloud keys directly in the stage definition. What should they use?

• AA storage integration
• BA resource monitor
• CA network policy
• DA failover group

Which staging pattern can support Snowpipe auto-ingest based on cloud event notifications?

• AAn internal named stage
• BA user stage only
• CAn external cloud stage
• DA table stage only

A pipeline owner wants to test whether staged files will load cleanly before writing any rows into the target table. Which COPY option is the best fit?

• AFORCE = TRUE
• BVALIDATION_MODE
• CPURGE = TRUE
• DSINGLE = TRUE

A file was already loaded successfully yesterday, but the engineer intentionally needs to load the same staged file again into the table. Which COPY option allows that?

• AMATCH_BY_COLUMN_NAME = CASE_INSENSITIVE
• BFORCE = TRUE
• CON_ERROR = CONTINUE
• DPURGE = TRUE

An external stage contains thousands of files, but only files with names starting with `sales_2026_03` should be loaded. Which COPY feature is designed for this?

• ACLUSTER BY
• BPATTERN
• CSEARCH OPTIMIZATION
• DQUALIFY

A team uses an internal stage for landing data and wants successfully loaded files removed automatically to reduce clutter. Which COPY option should they set?

• AAUTO_RESUME = TRUE
• BPURGE = TRUE
• CFORCE = TRUE
• DREFRESH_ON_CREATE = TRUE

Which statement correctly describes a Snowflake table stage?

• AIt can be shared across all schemas in the account
• BIt is automatically associated with a specific table
• CIt can only point to external cloud storage
• DIt is the only stage type that supports file formats

A CSV file arrives with more columns than the target table needs, and the engineer wants to transform and subset the data during the load step itself. Which approach is best?

• ACreate a reader account first
• BUse COPY INTO with a SELECT statement from the stage
• CSuspend the warehouse before the load
• DClone the target table before each load

If a batch load should continue loading good rows even when some rows are malformed, which COPY setting is the closest fit?

• AON_ERROR = CONTINUE
• BFORCE = TRUE
• CPURGE = TRUE
• DHEADER = TRUE

A developer tries to upload a local file to an external S3 stage using `PUT` from SnowSQL. Why will this fail?

• APUT requires an active multi-cluster warehouse
• BPUT works only with internal stages
• CPUT supports only Parquet files
• DPUT can be used only from Python, not SnowSQL

A security team wants cloud credential rotation for an external stage to happen centrally without editing every stage definition. What design best supports that?

• AUse a storage integration referenced by the stage
• BStore access keys in each COPY command
• CCreate one warehouse per stage
• DUse only temporary stages

Several ingestion jobs must parse the same CSV settings consistently across many tables. Which object should be created once and reused?

• AA network rule
• BA named file format
• CA row access policy
• DA data share

What Snowflake mechanism is primarily used to prevent the same staged file from being loaded repeatedly by accident?

• ALoad history metadata for previously processed files
• BAutomatic clustering on the target table
• CResult cache reuse
• DSearch optimization service

Which statement about Snowpipe compute is correct?

• ASnowpipe requires a dedicated warehouse that never suspends
• BSnowpipe uses Snowflake-managed serverless compute
• CSnowpipe runs only on reader accounts
• DSnowpipe can execute only after a task starts a warehouse

A team wants files in an S3 bucket to load into Snowflake automatically seconds after arrival. Besides the pipe itself, what is required for classic Snowpipe auto-ingest?

• AA masking policy on the target table
• BCloud storage event notifications
• CA materialized view on the stage
• DA secondary failover account

What does a Snowflake pipe encapsulate?

• AA query profile and result cache entry
• BA COPY INTO statement used for continuous ingestion
• CA role hierarchy for data loading
• DA failover policy for stages

An engineer wants to check whether a pipe is paused, running, or showing recent ingestion errors. Which system function is designed for that?

• ASYSTEM$PIPE_STATUS
• BSYSTEM$TASK_HISTORY
• CSYSTEM$CLUSTERING_INFORMATION
• DSYSTEM$ABORT_SESSION

A pipe was created after hundreds of files already existed in the external stage, and the team needs those older files ingested now. What should the engineer do?

• ASuspend and resume the warehouse
• BRefresh the pipe to backfill eligible staged files
• CConvert the table to transient
• DGrant OWNERSHIP on the stage to PUBLIC

Which workload is the best fit for Snowpipe instead of a once-per-night scheduled COPY job?

• AA daily finance close process that can wait until midnight
• BNew files landing throughout the day that must appear quickly
• CA static archive that never changes
• DA one-time migration completed months ago

A custom application emits thousands of small events per second and wants to push rows into Snowflake without first writing files to cloud storage. Which feature is the best fit?

• ASnowpipe Streaming
• BExternal tables
• CGET
• DDatabase failover

A team is choosing between classic Snowpipe and Snowpipe Streaming for an event-driven service. What is the main architectural difference?

• ASnowpipe Streaming writes rows without requiring staged files first
• BClassic Snowpipe supports only CSV while Snowpipe Streaming supports JSON
• CSnowpipe Streaming requires a larger warehouse size
• DClassic Snowpipe cannot load continuously

Why is Snowpipe Streaming often preferred over classic file-based Snowpipe for very low-latency application events?

• AIt avoids the staged-file step and reduces ingest delay
• BIt automatically enables Search Optimization Service
• CIt eliminates the need for any Snowflake authentication
• DIt converts all incoming data to fully normalized tables

Which statement is true for classic Snowpipe but not required for Snowpipe Streaming?

• AIt loads data only from files available through a stage
• BIt can be used for near-real-time ingestion
• CIt uses Snowflake-managed compute
• DIt supports JSON data

A pipeline receives large files only once each night, and the business is fine waiting until the batch window finishes. Which option is usually the simplest and most cost-conscious choice?

• ARun a scheduled COPY INTO workflow
• BUse Snowpipe Streaming for each nightly file
• CCreate a reader account for the source system
• DEnable Search Optimization Service on the stage

A partner drops compressed files into an external stage every 10 minutes, and the team wants file-based near-real-time ingestion with minimal custom code. Which option is the best fit?

• AClassic Snowpipe
• BSnowpipe Streaming
• CGET into a user stage
• DA materialized view on the external stage

An application team wants to stream event rows directly from its service into Snowflake tables with the lowest practical latency. Which option should the architect recommend?

• AA nightly task that runs COPY INTO
• BSnowpipe Streaming
• CA private listing
• DA secure view

A company already publishes application events to Kafka and wants managed Snowflake ingestion with very low latency. Which integration path is the best fit?

• AThe Kafka connector with Snowpipe Streaming
• BManual GET commands every minute
• CA reader account for the Kafka brokers
• DA resource monitor on the topic

An internal web service needs to submit SQL statements to Snowflake over HTTPS without using JDBC or ODBC. Which interface is the best fit?

• AThe SQL API
• BA failover group
• CA row access policy
• DA search optimization service

A Snowflake external function must call a third-party REST endpoint during execution. Which Snowflake object is required for the remote service connection?

• AA data share
• BAn API integration
• CA file format
• DA resource monitor

A security review rejects stage definitions that include direct cloud keys for Azure Blob access. Which Snowflake feature addresses this concern?

• AA storage integration
• BA materialized view
• CA query tag
• DA masking policy

Which Snowflake command downloads files from an internal stage to a local machine?

• APUT
• BCOPY INTO
• CGET
• DMERGE

Which command uploads local files from a client machine into an internal Snowflake stage?

• APUT
• BGET
• CCREATE SHARE
• DSHOW IMPORTED KEYS

A development team is embedding Snowflake queries directly inside a Python data-ingestion application. Which access method is the most natural fit?

• AThe Python connector or Snowpark for Python
• BA reader account
• CA network rule only
• DA private listing

What is the main reason to use a named external stage instead of embedding the cloud URL directly inside every COPY command?

• AIt centralizes path and access configuration for reuse
• BIt guarantees zero-copy cloning of the files
• CIt removes the need for file formats
• DIt converts all loads into streaming ingestion

A team asks whether internal stages can be wired to cloud notifications for Snowpipe auto-ingest. What should the engineer answer?

• AYes, if the internal stage is named
• BNo, auto-ingest depends on notifications from external cloud storage
• CYes, but only for table stages
• DNo, because Snowpipe cannot ingest continuously

A partner-owned S3 bucket delivers data, and the Snowflake team wants the partner to rotate credentials without rewriting every pipeline. Which setup is best?

• AOne storage integration plus external stages that reference it
• BOne result cache per table
• COne reader account per bucket
• DOne task per object key

A data engineer wants application code to use DataFrame-style transformations in the same language as the service rather than building every step as plain SQL strings. Which Snowflake programming model is designed for that?

• ASnowpark
• BSearch Optimization Service
• CDatabase replication
• DAccount Usage

Which statement about external stages is correct?

• AThey can point to supported cloud object storage such as S3, Azure Blob, or GCS
• BThey store local laptop files directly inside Snowflake-managed storage
• CThey can be queried only through GET
• DThey eliminate the need for cloud IAM configuration

A pipeline must call a remote REST service to enrich data during execution, and the security team wants Snowflake-side governance over that outbound integration. Which design is correct?

• AUse an API integration with an external function
• BUse a storage integration with COPY INTO
• CUse a private listing with a reader account
• DUse Time Travel on the source table

A provider uses direct secure data sharing with another Snowflake account in the same region. What happens to the underlying data when the share is created?

• ASnowflake makes a full physical copy for the consumer
• BThe consumer receives read-only access without a data copy
• CThe provider loses access to the shared objects
• DThe objects are converted into transient tables

How does a consumer access data that a provider has shared directly?

• ABy cloning the provider database into their account
• BBy creating an imported database from the share
• CBy issuing GET commands against the provider stage
• DBy enabling Search Optimization Service on the provider account

Which statement about an imported database created from a share is correct?

• AIt is writable by the consumer if they have SYSADMIN
• BIt is read-only to the consumer
• CIt automatically becomes a failover database
• DIt can be used only with reader accounts

A company wants to provide data to a customer that does not have its own Snowflake account. Which collaboration option is designed for that?

• AReader account
• BTransient table
• CTask graph
• DNetwork policy

Who pays the virtual warehouse credits consumed in a reader account?

• AThe reader account user
• BSnowflake splits the bill between both parties
• CThe data provider that created the reader account
• DNo one, because reader accounts are free