Snowflake SnowPro Advanced: Data Architect (ADA-C01)

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 engineer notices that a query against a large Snowflake table takes 45 seconds. When examining the query profile in Snowsight, they see that 80% of the time is spent in the 'TableScan' node and the bytes spilled to local disk metric is zero. What is the most likely cause of the slow performance?

4. A Snowflake query profile shows high 'Bytes spilled to remote disk' for a complex aggregation query. Which action will most directly reduce remote disk spillage?

5. A data architect at a retail company notices that queries against a 10 TB sales table are performing slowly despite adequate warehouse sizing. The table is partitioned by micro-partitions, and the queries filter on the ORDER_DATE column. The architect observes that the SYSTEM$CLUSTERING_INFORMATION function reports a high average overlap depth. What is the MOST likely root cause of the slow query performance?