A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe.
What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?

• A.OWNERSHIP on the named pipe, USAGE on the named stage, target database, and schema, and INSERT and SELECT on the target table
• B.OWNERSHIP on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table
• C.CREATE on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table
• D.USAGE on the named pipe, named stage, target database, and schema, and INSERT and SELECT on the target table

Comment: *

Name: *

Email: *

Verification: *

The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps:
Step 1: Data files are loaded in a stage.
Step 2: An Amazon S3 event notification, published by SNS, informs Snowpipe - by way of Amazon Simple Queue Service (SQS) - that files are ready to load. Snowpipe copies the files into a queue.
Step 3: A Snowflake-provided virtual warehouse loads data from the queued files into the target table based on parameters defined in the specified pipe.

If an AWS Administrator accidentally deletes the SQS subscription to the SNS topic in Step 2, what will happen to the pipe that references the topic to receive event messages from Amazon S3?

• A.The pipe will continue to receive the messages as Snowflake will automatically restore the subscription to the same SNS topic and will recreate the pipe by specifying the same SNS topic name in the pipe definition.
• B.The pipe will no longer be able to receive the messages and the user must wait for 24 hours from the time when the SNS topic subscription was deleted. Pipe recreation is not required as the pipe will reuse the same subscription to the existing SNS topic after 24 hours.
• C.The pipe will continue to receive the messages as Snowflake will automatically restore the subscription by creating a new SNS topic. Snowflake will then recreate the pipe by specifying the new SNS topic name in the pipe definition.
• D.The pipe will no longer be able to receive the messages. To restore the system immediately, the user needs to manually create a new SNS topic with a different name and then recreate the pipe by specifying the new SNS topic name in the pipe definition.

Comment: *

Name: *

Email: *

Verification: *

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

• A.Thee CHANGE_DATA_CAPTURE command
• B.The CHANGES clause
• C.The MERGE command
• D.The UPSERT command
• E.A STREAM object

Comment: *

Name: *

Email: *

Verification: *

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

• A.At the root level (HSM)
• B.At the account level (AMK)
• C.At the table level (TMK)
• D.At the micro-partition level

Comment: *

Name: *

Email: *

Verification: *

A 2 TB table with 400 columns is queried frequently to calculate average employee tenure by country and career level. The query exhibits poor partition pruning and runs on an X-Small warehouse.
What improvement meets the requirements with the LEAST operational overhead?

• A.Add clustering keys on COUNTRY and EMPLOYMENT_STATUS.
• B.Enable Query Acceleration Service (QAS).
• C.Enable search optimization on equality predicates for COUNTRY and EMPLOYMENT_STATUS.
• D.Build a materialized view for latest active employee records per country.

Comment: *

Name: *

Email: *

Verification: *