SnowPro Advanced: Architect Recertification Exam

Question 1

A company has an external vendor who puts data into Google Cloud Storage. The company's Snowflake account is set up in Azure.
What would be the MOST efficient way to load data from the vendor into Snowflake?

A. Copy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake.

B. Create an external stage on Google Cloud Storage and use the external table to load the data into Snowflake.

C. Create a Snowflake Account in the Google Cloud Platform (GCP), ingest data into this account and use data replication to move the data from GCP to Azure.

D. Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.
The data pipeline needs to run continuously ang efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.
Which design will meet these requirements?

A. Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create an external function to do model inference with Amazon Comprehend and write the final records to a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

B. Ingest the data using COPY INTO and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

C. Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

D. Ingest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark connector.
Apply transformations using another Spark job. Develop a python program to do model inference by leveraging the Amazon Comprehend text analysis API. Then write the results to a Snowflake table and create a listing in the Snowflake Marketplace to make the data available to other companies.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

How does a standard virtual warehouse policy work in Snowflake?

A. It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.

B. It prevents or minimizes queuing by starting additional clusters instead of conserving credits.

C. It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.

D. It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running.
Why is this occurring?

A. The Architect has insufficient privileges to alter tasks on the cloned database.

B. Cloned tasks are suspended by default and must be manually resumed.

C. The objects that the tasks reference are not fully qualified.

D. Tasks cannot be cloned.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.
What type of table you will use in this case to optimize cost

A. TEMPORARY

B. TRANSIENT

C. PERMANENT

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

Following objects can be cloned in snowflake

A. Permanent table

B. Internal stages

C. Transient table

D. Temporary table

E. External tables

Correct Answer: A,C,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

Which Snowflake objects can be used in a data share? (Select TWO).

A. Stored procedure

B. Secure view

C. Standard view

D. External table

E. Stream

Correct Answer: B,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

An Architect is implementing a CI/CD process. When attempting to clone a table from a production to a development environment, the cloning operation fails.
What could be causing this to happen?

A. The table is transient.

B. The retention time for the table is set to zero.

C. Tables cannot be cloned from a higher environment to a lower environment.

D. The table has a masking policy.

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 9

A company is using Snowflake in Azure in the Netherlands. The company analyst team also has data in JSON format that is stored in an Amazon S3 bucket in the AWS Singapore region that the team wants to analyze.
The Architect has been given the following requirements:
1. Provide access to frequently changing data
2. Keep egress costs to a minimum
3. Maintain low latency
How can these requirements be met with the LEAST amount of operational overhead?

A. Use AWS Transfer Family to replicate data between the S3 bucket in AWS Singapore and an Azure Netherlands Blob storage, then use an external table against the Blob storage.

B. Use an external table against the S3 bucket in AWS Singapore and copy the data into transient tables.

C. Use a materialized view on top of an external table against the S3 bucket in AWS Singapore.

D. Copy the data between providers from S3 to Azure Blob storage to collocate, then use Snowpipe for data ingestion.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Snowflake SnowPro Advanced: Architect Recertification - ARA-R01 Exam Practice Test

Latest Update

Useful Links

Contact Us