Snowflake SnowPro Advanced: Architect Recertification - ARA-R01 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate redundancy when managing logins.
What Snowflake functionality should be used to meet these requirements? (Choose two.)

A. Set up replication to allow users to connect from outside the company VPN. B. Use private connectivity from a cloud provider. C. Use a proxy Snowflake account outside the VPN, enabling client redirect for user logins. D. Set up SSO for federated authentication. E. Provision a unique company Tri-Secret Secure key.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question 2

Which SQL alter command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

A.

B.

C.

D.

Discussion 0

Correct Answer: D Vote an answer

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

Question 3

An Architect needs to design a Snowflake account and database strategy to store and analyze large amounts of structured and semi-structured data. There are many business units and departments within the company. The requirements are scalability, security, and cost efficiency.
What design should be used?

A. Set up separate Snowflake accounts and databases for each department or business unit, to ensure data isolation and security. B. Create a single Snowflake account and database for all data storage and analysis needs, regardless of data volume or complexity. C. Use a centralized Snowflake database for core business data, and use separate databases for departmental or project-specific data. D. Use Snowflake's data lake functionality to store and analyze all data in a central location, without the need for structured schemas or indexes

Discussion 0

Correct Answer: C Vote an answer

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

Question 4

Which Snowflake data modeling approach is designed for BI queries?

A. 3 NF B. Snowflake schema C. Star schema D. Data Vault

Discussion 0

Correct Answer: C Vote an answer

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

Question 5

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 account level (AMK) B. At the micro-partition level C. At the root level (HSM) D. At the table level (TMK)

Discussion 0

Correct Answer: A Vote an answer

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

Question 6

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

A. The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML. B. Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time. C. The Connector creates and manages its own stage, file format, and pipe objects. D. The Connector only works in Snowflake regions that use AWS infrastructure.

Discussion 0

Correct Answer: C Vote an answer

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

Question 7

An Architect for a multi-national transportation company has a system that is used to check the weather conditions along vehicle routes. The data is provided to drivers.
The weather information is delivered regularly by a third-party company and this information is generated as JSON structure. Then the data is loaded into Snowflake in a column with a VARIANT data type. This table is directly queried to deliver the statistics to the drivers with minimum time lapse.
A single entry includes (but is not limited to):
- Weather condition; cloudy, sunny, rainy, etc.
- Degree
- Longitude and latitude
- Timeframe
- Location address
- Wind
The table holds more than 10 years' worth of data in order to deliver the statistics from different years and locations. The amount of data on the table increases every day.
The drivers report that they are not receiving the weather statistics for their locations in time.
What can the Architect do to deliver the statistics to the drivers faster?

A. Divide the table into several tables for each location by using the location address information from the JSON dataset in order to process the queries in parallel. B. Divide the table into several tables for each year by using the timeframe information from the JSON dataset in order to process the queries in parallel. C. Create an additional table in the schema for longitude and latitude. Determine a regular task to fill this information by extracting it from the JSON dataset. D. Add search optimization service on the variant column for longitude and latitude in order to query the information by using specific metadata.

Discussion 0

Correct Answer: D Vote an answer

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

Question 8

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend - 60 and used exclusively for this task, which statement is true?

A. The warehouse MY_WH will be made active every five minutes to check the stream. B. The warehouse MY_WH will automatically resize to accommodate the size of the stream. C. The warehouse MY_WH will never suspend. D. The warehouse MY_WH will only be active when there are results in the stream.

Discussion 0

Correct Answer: D Vote an answer

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

Question 9

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

A. Shared databases must be refreshed in order for new data to be visible. B. Shared databases are not supported by Time Travel. C. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share. D. Shared databases cannot be cloned. E. Shared databases can also be created as transient databases. F. Shared databases are read-only.

Discussion 0

Correct Answer: B,D,F Vote an answer

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

Question 10

Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)

A. Extended Time Travel (up to 90 days) B. Federated authentication and SSO C. AWS, Azure, or Google Cloud private connectivity to Snowflake D. Periodic rekeying of encrypted data E. Customer-managed encryption keys through Tri-Secret Secure

Discussion 0

Correct Answer: C,E Vote an answer

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

Question 11

An Architect needs to allow a user to create a database from an inbound share.
To meet this requirement, the user's role must have which privileges? (Choose two.)

A. IMPORT DATABASE; B. IMPORT SHARE; C. CREATE DATABASE; D. IMPORT PRIVILEGES; E. CREATE SHARE;

Discussion 0

Correct Answer: A,C Vote an answer

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