SnowPro Advanced: Architect Recertification Exam (ARA-R01) Free Practice Test

Question 1

A company needs to have the following features available in its Snowflake account:
1. Support for Multi-Factor Authentication (MFA)
2. A minimum of 2 months of Time Travel availability
3. Database replication in between different regions
4. Native support for JDBC and ODBC
5. Customer-managed encryption keys using Tri-Secret Secure
6. Support for Payment Card Industry Data Security Standards (PCI DSS)
In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

A. Standard

B. Enterprise

C. Virtual Private Snowflake (VPS)

D. Business Critical

Correct Answer: D

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

Question 2

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. Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share.

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

D. 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.

Correct Answer: C

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

Question 3

Based on the Snowflake object hierarchy, what securable objects belong directly to a Snowflake account?
(Select THREE).

A. Stage

B. Warehouse

C. Table

D. Role

E. Database

F. Schema

Correct Answer: B,D,E

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

Question 4

Which Snowflake architecture recommendation needs multiple Snowflake accounts for implementation?

A. Enable a disaster recovery strategy across multiple cloud providers.

B. Create external stages pointing to cloud providers and regions other than the region hosting the Snowflake account.

C. Enable zero-copy cloning among the development, test, and production environments.

D. Enable separation of the development, test, and production environments.

Correct Answer: D

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

Question 5

A company wants to Integrate its main enterprise identity provider with federated authentication with Snowflake.
The authentication integration has been configured and roles have been created in Snowflake. However, the users are not automatically appearing in Snowflake when created and their group membership is not reflected in their assigned rotes.
How can the missing functionality be enabled with the LEAST amount of operational overhead?

A. OAuth must be configured between the identity provider and Snowflake. Then the authorization server must be configured with the right mapping of users and roles.

B. SCIM must be enabled between the identity provider and Snowflake. Once both are synchronized through SCIM, their groups will get created as group accounts in Snowflake and the proper roles can be granted.

C. SCIM must be enabled between the identity provider and Snowflake. Once both are synchronized through SCIM. users will automatically get created and their group membership will be reflected as roles In Snowflake.

D. OAuth must be configured between the identity provider and Snowflake. Then the authorization server must be configured with the right mapping of users, and the resource server must be configured with the right mapping of role assignment.

Correct Answer: C

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

Question 6

What is a valid object hierarchy when building a Snowflake environment?

A. Organization --> Account --> Stage --> Table --> View

B. Account --> Schema > Table --> Stage

C. Organization --> Account --> Database --> Schema --> Stage

D. Account --> Database --> Schema --> Warehouse

Correct Answer: C

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

Question 7

What is a key consideration when setting up search optimization service for a table?

A. Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.

B. Search optimization service can significantly improve query performance on partitioned external tables.

C. Search optimization service works best with a column that has a minimum of 100 K distinct values.

D. The table must be clustered with a key having multiple columns for effective search optimization.

Correct Answer: C

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

Question 8

An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server.
How can this requirement be met?

A. Use the Snowpipe REST API.

B. Use the Snowflake SQL REST API.

C. Use SnowSQL.

D. Use the Snowflake ODBC driver.

Correct Answer: B

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

Welcome to TestSimulate

Snowflake SnowPro Advanced: Architect Recertification (ARA-R01) Free Practice Test