Snowflake SnowPro Advanced: Data Architect (ADA-C01) - 340 Questions

1. A data engineer needs to load CSV files from an S3 stage into a Snowflake table. Some files contain rows that violate the table constraints. The engineer wants the load to continue for valid rows and skip invalid ones without failing the entire COPY INTO command. Which ON_ERROR option should be used?

2. A data architect needs to create a Snowpipe that will automatically ingest files as they arrive in an Amazon S3 bucket. Which parameter must be included in the CREATE PIPE statement to enable event-based automatic ingestion?

3. A data architect wants to create a task DAG in Snowflake where multiple parallel child tasks run after a root task completes, and a final task runs only after all parallel branches finish. Which Snowflake task feature enables this pattern?

4. A data engineer is loading files into Snowflake using COPY INTO and wants to ensure that already-loaded files are automatically deleted from the stage after a successful load. Which COPY INTO option achieves this?

5. A company has configured Snowpipe with AUTO_INGEST = TRUE on AWS. After creating the pipe, which Snowflake function should the data architect call to retrieve the SQS queue ARN that must be configured in the S3 event notification settings?