View Full Snowflake SnowPro Advanced Data Engineer Exam Dumps and Practice Test Dumps

 

Question 301

Which command creates a stream on an existing table?

1. BUILD STREAM
2. CREATE CHANGE STREAM
3. CREATE STREAM
4. MAKE STREAM

Correct Answer: 3

Explanation:

CREATE STREAM creates a stream object that records changes occurring on a supported source object. Streams are important for incremental data pipelines because they allow downstream processes to identify newly inserted, deleted, or updated records without repeatedly comparing complete table snapshots. Engineers can then consume those changes through SQL statements and tasks. When creating a stream, the source object, initialization behavior, and required privileges should be considered carefully. Proper stream design can significantly reduce unnecessary processing in large-scale transformation workflows.

Question 302

Which statement consumes stream records in a transformation?

1. MERGE
2. READ STREAM
3. APPLY STREAM
4. PROCESS CHANGES

Correct Answer: 1

Explanation:

A MERGE statement can consume stream records and apply inserts, updates, or deletes to a target table according to matching conditions. This pattern is widely used for incremental data pipelines because only changed records need to be processed rather than rebuilding the complete target dataset. Engineers can combine stream metadata with MERGE logic to distinguish different change types. The target transformation should be designed carefully so that duplicate processing, unmatched records, and business-key behavior are handled consistently during repeated pipeline executions.

Question 303

Which stream property defines whether updates are represented as separate changes?

1. APPEND_ONLY
2. UPDATE_TRACKING
3. CHANGE_MODE
4. CAPTURE_UPDATES

Correct Answer: 1

Explanation:

APPEND_ONLY determines whether a stream is configured to capture only newly appended rows for supported source workloads. An append-only stream does not provide the same update and delete change information as a standard stream. This can simplify processing when the source table is naturally append-only, such as certain event or log datasets. Engineers should select this mode only when the source behavior matches the intended semantics. Using append-only processing on mutable data can cause downstream consumers to miss important changes.

Question 304

Which task condition can prevent execution when no changes exist?

1. WHEN HAS_ROWS
2. WHEN STREAM_HAS_DATA
3. IF CHANGES_EXIST
4. WHEN DATA_READY

Correct Answer: 2

Explanation:

The WHEN condition of a task can use SYSTEM$STREAM_HAS_DATA to determine whether a stream contains relevant change information before executing downstream processing. This pattern helps event-driven pipelines avoid unnecessary task runs when there is nothing new to process. Engineers commonly combine this condition with a scheduled task so the task periodically checks for changes. The approach can reduce unnecessary compute consumption while maintaining automated processing. Task scheduling, stream retention, and processing frequency should still be designed according to freshness requirements.

Question 305

Which command resumes a suspended task?

1. START TASK
2. ALTER TASK … RESUME
3. ENABLE TASK
4. ACTIVATE TASK

Correct Answer: 2

Explanation:

ALTER TASK … RESUME changes a suspended task to a resumed state so that its configured scheduling or dependency-based execution can proceed. Resuming a task is an administrative operation and does not itself redesign the task’s SQL logic or dependencies. Engineers should verify the task definition, predecessor relationships, schedule, and target objects before resuming production workloads. In task graphs, dependency states should also be reviewed because resuming one task does not necessarily mean every related task has been activated.

Question 306

Which command suspends a running task?

1. ALTER TASK … SUSPEND
2. STOP TASK EXECUTION
3. DISABLE TASK NOW
4. PAUSE TASK

Correct Answer: 1

Explanation:

ALTER TASK … SUSPEND suspends a task so that its scheduled or dependency-driven executions do not continue normally. This can be useful during maintenance, troubleshooting, schema changes, or controlled deployment activities. Engineers should understand that suspending a task is different from deleting it because the task definition remains available. Before suspending a production pipeline, teams should consider downstream dependencies and determine whether queued or dependent processing requires additional operational handling.

Question 307

Which object can coordinate dependent task execution?

1. Task graph
2. Pipeline table
3. Workflow schema
4. Execution chain

Correct Answer: 1

Explanation:

A task graph coordinates execution among related Snowflake tasks by defining dependencies between parent and child tasks. This allows data engineers to organize multi-step workflows such as ingestion, validation, transformation, and publishing. Dependencies can establish the required execution order without requiring every stage to be controlled externally. Engineers should keep task graphs understandable and avoid unnecessary complexity. Clear dependency design makes failures easier to diagnose and helps ensure that downstream tasks do not process incomplete upstream data.

Question 308

Which Snowflake object supports automated file ingestion logic?

1. Pipe
2. Stream
3. Task
4. View

Correct Answer: 1

Explanation:

A pipe stores the loading definition used by Snowpipe for continuous file ingestion. Its definition generally contains a COPY INTO statement that describes how staged files should be loaded into a target table. Pipes can operate with automatic cloud notifications when configured for automated ingestion. Engineers should carefully configure stages, file formats, permissions, notification infrastructure, and target tables because an error in any component can prevent expected files from being processed.

Question 309

Which function reports the status of a Snowpipe pipe?

1. SYSTEM$PIPE_STATUS
2. PIPE_STATUS
3. SYSTEM$INGESTION_STATE
4. GET_PIPE_STATUS

Correct Answer: 1

Explanation:

SYSTEM$PIPE_STATUS returns status information for a Snowpipe pipe and is useful when investigating ingestion activity. Engineers can use the function to inspect operational details and determine whether a pipe has pending or problematic processing. This information can be combined with loading history and cloud-storage checks during troubleshooting. Monitoring pipe status is particularly important in automated ingestion architectures because files may arrive continuously without a human initiating each load operation.

Question 310

Which setting enables automatic Snowpipe ingestion?

1. AUTO_LOAD
2. AUTO_INGEST
3. CONTINUOUS_LOAD
4. EVENT_INGEST

Correct Answer: 2

Explanation:

AUTO_INGEST = TRUE enables supported Snowpipe configurations to use cloud event notifications for automated file ingestion. When new files arrive in the configured external storage location, notification events can cause Snowpipe to process those files. This reduces the need for repeatedly executing manual loading commands. Engineers must configure both Snowflake and the cloud provider correctly, including notification services, storage permissions, stages, and pipe definitions. Monitoring should verify that incoming files generate the expected ingestion activity.

Question 311

Which object defines parsing rules for staged files?

1. File format
2. Storage integration
3. Pipe
4. Directory table

Correct Answer: 1

Explanation:

A file format defines how Snowflake interprets staged files during loading or unloading operations. Depending on the format, settings can describe delimiters, compression, quotation characters, null handling, encoding, and other parsing behavior. Named file formats can be reused across multiple stages and pipelines, promoting consistent ingestion configuration. Engineers should validate file-format definitions against actual producer output because even a small mismatch can produce incorrect columns, parsing errors, or unexpected null values.

Question 312

Which object provides metadata about files stored in a stage?

1. Stage stream
2. Directory table
3. File catalog
4. Storage view

Correct Answer: 2

Explanation:

A directory table provides metadata describing files associated with a stage. This can support workflows that need to inspect staged objects, identify available files, or build metadata-driven processing logic. Directory information is different from the contents of the files themselves because it represents file-level metadata rather than materialized source rows. Engineers can use directory metadata alongside loading mechanisms when designing controlled ingestion workflows, especially where source-file discovery and processing status need to be incorporated into pipeline logic.

Question 313

Which integration provides controlled access to external cloud storage?

1. Storage integration
2. Cloud credential object
3. External access integration
4. Storage permission profile

Correct Answer: 1

Explanation:

A storage integration provides Snowflake with a managed configuration for accessing supported external cloud storage. It allows cloud authorization details to be centralized rather than embedding long-lived credentials directly into individual external stages. Engineers can then reference the integration when configuring stages that point to cloud storage locations. Proper cloud-side permissions remain essential because the Snowflake integration and provider authorization must work together. Storage integrations help make external-stage configurations more consistent and easier to govern.

Question 314

Which object defines allowed outbound network locations?

1. External access integration
2. Network rule
3. Secret
4. API integration

Correct Answer: 2

Explanation:

A network rule identifies approved network locations that can be referenced by Snowflake configurations supporting controlled external connectivity. Depending on the rule type, it can represent supported hostnames, IP ranges, or other network identifiers. Network rules help establish explicit boundaries for outbound access rather than allowing unrestricted destinations. Engineers should keep these definitions appropriately scoped and review them as external service requirements change. Network rules are typically combined with other security objects when configuring external access.

Question 315

Which object securely stores credentials for external services?

1. Secret
2. Credential table
3. Password stage
4. Authentication record

Correct Answer: 1

Explanation:

A Snowflake secret securely stores supported authentication information used by external access configurations and compatible code. Secrets help prevent credentials from being embedded directly in SQL procedures or function definitions. Depending on the secret type, they can hold information such as passwords, tokens, or other authentication material. Engineers should apply strict privileges to secrets because access may provide authentication to an external service. External access integrations can reference approved secrets when establishing controlled connectivity.

Question 316

Which feature allows Snowflake SQL to invoke a remote API service?

1. External function
2. Remote table
3. API view
4. Service procedure

Correct Answer: 1

Explanation:

An external function allows Snowflake SQL to invoke a remotely hosted service through an appropriate integration and endpoint configuration. This capability is useful when a transformation requires specialized processing or an external service that does not run directly inside Snowflake. Engineers should consider latency, availability, authentication, data-transfer costs, and failure handling before placing external function calls inside high-volume transformations. External dependencies should be monitored because service interruptions can affect otherwise healthy Snowflake pipelines.

Question 317

Which object can expose data through a reusable query definition?

1. View
2. Pipe
3. Stage
4. Stream

Correct Answer: 1

Explanation:

A standard view stores a SQL query definition and exposes its resulting dataset to authorized consumers. Views are useful for abstraction, reusable transformations, security-oriented presentation layers, and simplified access to complex joins or filters. Because a standard view does not independently store a materialized result, its queries generally execute against the underlying objects when accessed. Engineers should use views when logical abstraction is more important than maintaining a physically stored query result.

Question 318

Which object automatically maintains a stored query result?

1. Dynamic table
2. Materialized view
3. Standard view
4. External table

Correct Answer: 2

Explanation:

A materialized view maintains a stored representation of a query result that Snowflake can maintain automatically. This can improve performance for suitable recurring query patterns because users may avoid recalculating the complete underlying transformation each time. Materialized views differ from standard views, which store only query definitions. Engineers should evaluate query patterns, supported SQL constructs, maintenance behavior, and workload benefits before selecting materialized views for production data-serving requirements.

Question 319

Which command creates a zero-copy clone?

1. CREATE CLONE
2. CREATE TABLE … CLONE
3. CLONE TABLE USING
4. COPY TABLE METADATA

Correct Answer: 2

Explanation:

CREATE TABLE … CLONE creates a zero-copy clone of a supported source table. Initially, the clone shares underlying micro-partition storage rather than creating an immediate physical duplicate of every source record. This makes cloning useful for development environments, testing, rapid recovery workflows, and controlled transformation experiments. As the source or clone changes, Snowflake manages storage according to its copy-on-write architecture. Engineers should still consider retention, permissions, and downstream object dependencies when using clones.

Question 320

Which command restores a previously dropped schema?

1. RESTORE SCHEMA
2. UNDROP SCHEMA
3. RECOVER SCHEMA
4. REBUILD SCHEMA

Correct Answer: 2

Explanation:

UNDROP SCHEMA restores a previously dropped schema when it remains available under Snowflake’s applicable retention rules. This can recover the schema and supported objects that existed within it at the time of deletion. Engineers should act promptly when accidental deletion occurs because historical recovery depends on retention and object availability. Before restoring the schema, teams should also check whether an object with the same name already exists and understand how the recovery affects dependent workloads.