You have configured a Snowpipe to load data from an AWS S3 bucket into a Snowflake table. The data in S3 is updated frequently. You've noticed that despite the Snowpipe being active and the S3 event notifications being configured correctly, some newly added files are not being picked up by the Snowpipe. You run 'SYSTEM$PIPE and see the 'executionstate' is 'RUNNING' but the 'pendingFileCount' remains at O, even after new files are placed in the S3 bucket. Choose all of the reasons that could explain the observations.

• A. The S3 event notification configuration is missing the 's3:ObjectCreated: event type, meaning that new file creation events are not being sent to the SQS queue or SNS topic.
• B. There is an insufficient warehouse size configured for the Snowpipe. Increase the warehouse size for optimal performance.
• C. The file format specified in the Snowpipe definition does not match the actual format of the files being placed in the S3 bucket.
• D. The IAM role associated with your Snowflake account does not have sufficient permissions to read from the S3 bucket. Specifically, it lacks the 's3:GetObject' permission.
• E. The SQS queue or SNS topic associated with the S3 event notifications has a message retention period that is too short. Messages containing event details for new files are being deleted before Snowpipe can process them.

You are ingesting data from an external stage (AWS S3) into a Snowflake table using Snowpipe. Data files are continuously being uploaded to the stage. After several hours, you notice that some data files are not being loaded. You check the Snowpipe error notifications and see 'net.snowflake.ingest.errors.FileSizeLimitExceededError'. You have already verified that the Snowpipe is correctly configured and the user has the necessary permissions. What are the MOST LIKELY reasons for this error and how can you resolve them?

• A. The Snowpipe configuration is incorrect; specifically, the 'FILE FORMAT parameter is not correctly specified to handle the file type. Reconfigure the Snowpipe with the correct 'FILE FORMAT.
• B. The Snowpipe is encountering a transient network error. Reset the pipe using ALTER PIPE REFRESH;
• C. The data files are being uploaded to the stage faster than Snowpipe can process them. Increase the value of the 'MAX CONCURRENCY parameter in the Snowpipe definition.
• D. Snowflake has reached its maximum allowable data storage capacity. Increase your Snowflake storage capacity to resolve this issue.
• E. The size of the data files in the stage exceeds the maximum allowed size for Snowpipe. Split the large files into smaller files before uploading to the stage.

A data engineering team is building a real-time data pipeline in Snowflake. Data arrives continuously and needs to be processed with minimal latency. The team is using Snowflake Streams and Tasks for incremental data processing. However, they are encountering issues where the tasks are sometimes skipped or delayed, leading to data inconsistencies. Which combination of actions would BEST address these issues and ensure reliable near real-time data processing?

• A. Configure the tasks to run using a serverless compute model (Snowflake-managed compute). Ensure the parameter is set to a higher value and implement error handling within the task using TRY/CATCH blocks.
• B. Disable task scheduling and rely solely on Snowflake's Auto-Resume feature for warehouses. This simplifies the pipeline and reduces the chance of errors.
• C. Increase the warehouse size to ensure sufficient compute resources. This will prevent tasks from being skipped due to resource contention.
• D. Monitor the 'TASK HISTORY view regularly to identify skipped or delayed tasks and manually re-run them as needed. This is a reactive approach and does not prevent future occurrences.
• E. Adjust the ' ERROR_INTEGRATION' parameter on the task definition to send notifications when tasks fail. This allows for manual intervention but does not prevent skipping.

You have implemented a masking policy on the 'EMAIL' column of a 'USERS' table. The policy masks the email address for all users except those with the 'SUPPORT' role. You now need to grant the 'SELECT' privilege on this table to a new role, 'ANALYST. You want to ensure that the masking policy continues to work as expected for the 'ANALYST' role. Which of the following SQL statements should you execute?

• A.
  
• B.
  
• C.
  
• D.
  
• E.