Practice ARA-R01 Exam Online

Question 1

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

A : Create multiple clustering keys for a table.

B : Create multiple materialized views with different cluster keys.

C : Create super projections that will automatically create clustering.

D : Create a clustering key that contains all columns used in the access paths.

Answer: B

Question 2

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)

A : Clone a table from a share.

B : Grant modify permissions on the share.

C : Create a table from the shared database.

D : Create additional views inside the shared database.

E : Create a table stream on the shared table.

Answer: A,D

Question 3

When using the copy into < table > command with the CSV file format, how does the match_by_column_name parameter behave?

A :

It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.

B : The parameter will be ignored.

C : The command will return an error.

D : The command will return a warning stating that the file has unmatched columns.

Answer: B

Question 4

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

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

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

C :

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

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

Answer: A

Question 5

How can the Snowpipe REST API be used to keep a log of data load history?

A : Call insertReport every 20 minutes, fetching the last 10,000 entries.

B : Call loadHistoryScan every minute for the maximum time range.

C : Call insertReport every 8 minutes for a 10-minute time range.

D : Call loadHistoryScan every 10 minutes for a 15-minutes range.

Answer: D

Name:	SnowPro Advanced: Architect Recertification
Exam Code:	ARA-R01
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	136
Last Updated:	Apr 25, 2024

Snowflake ARA-R01