Free SNOWPRO-ADVANCED-ARCHITECT Snowflake SNOWPRO-ADVANCED-ARCHITECT Practice Test Question - Page 2

Question 4 (Topic 1)

An Architect is designing a file ingestion recovery solution. The project will use an internal named stage for file storage. Currently, in the case of an ingestion failure, the Operations team must manually download the failed file and check for errors. Which downloading method should the Architect recommend that requires the LEAST amount of operational overhead?

Select an option, then click Submit answer.

○ Use the Snowflake Connector for Python, connect to remote storage and download the file.
○ Use the GET command in SnowSQL to retrieve the file.
○ Use the GET command in Snowsight to retrieve the file.
○ Use the Snowflake API endpoint and download the file.

Question 5 (Topic 1)

An Architect needs to meet a company requirement to ingest files from the company’s AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company's Snowflake account be initiated? (Choose two.)

Select an option, then click Submit answer.

○ Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
○ Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.
○ Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
○ Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.
○ Configure the client application to issue a COPY INTO command to Snowflake when new files have arrived in Amazon S3 Glacier storage.

Reference / correct answer:

Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

Most accepted answer: A. Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

Community votes: A=2, C=1, D=1

Selected Answer: AC I don't think D completely covers the requirements in the question. The way it is stated, the SNS only notifies when new files have arrived. It doesn't initiate the ingestion of the files. upvoted 1 times

Selected Answer: AD I think A and D os best. What is the advantage of setting up lambda instead of using SNS, which is recommended for Snowpipe? upvoted 2 times

A: This approach involves configuring a client application to detect new files in Amazon S3 and call the Snowpipe REST API to trigger the data loading process into Snowflake. This method provides flexibility and control over the ingestion process. C: Using AWS Lambda to automate the process of detecting new files in Amazon S3 and calling the Snowpipe REST API is an efficient and serverless solution. This approach leverages AWS Lambda's event-driven architecture to trigger Snowpipe ingestion automatically. upvoted 3 times

Question 6 (Topic 1)

A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes. Cost is not a concern as long as the solution is the best available. The plan so far consists of the following steps: 1. Deployment of Snowflake accounts on two different cloud providers. 2. Selection of cloud provider regions that are geographically far apart. 3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts. 4. Implementation of Snowflake client redirect. What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

Select an option, then click Submit answer.

○ Connect the applications using the - URL. Use the Business Critical Snowflake edition.
○ Connect the applications using the - URL. Use the Virtual Private Snowflake (VPS) edition.
○ Connect the applications using the - URL. Use the Enterprise Snowflake edition.
○ Connect the applications using the - URL. Use the Business Critical Snowflake edition.

Free SNOWPRO-ADVANCED-ARCHITECT – Snowflake SNOWPRO-ADVANCED-ARCHITECT Practice Test Question