Free Practice Snowflake ARA-C01 Exam Questions 2025

Stay ahead with 100% Free SnowPro Advanced Architect Certification ARA-C01 Dumps Practice Questions

Page: 1 / 89

Total 442 Questions | Updated On: Apr 10, 2025

Add To Cart

Question 1

What does a response error code of 429 from the insertFiles, insertReport, or loadHistoryScan API of Snowpipe mean?

A : Failure. Request rate limit exceeded

B : Failure. Invalid request due to an invalid format or limit exceeded

C : Failure. PipeName not recognized

Answer: A

Question 2

What will happen to ALTER a column setting it to NOT NULL if it contains NULL values?

A : Snowflake deletes the rows with NULL values.

B : NULL values are changed to an empty string " "

C : Snowflake returns an error

D : NULL values are changed to 0

Answer: C

Question 3

You have an inventory table. You created two views on this table. The views look like as below

CREATE VIEW NON_SECURE_INVENTORY AS

SELECT BIBNUMBER, TITLE, AUTHOR,ISBN

FROM INVENTORY

WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);

CREATE SECURE VIEW SECURE_INVENTORY AS

SELECT BIBNUMBER, TITLE, AUTHOR,ISBN

FROM INVENTORY

WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);

You ran the below queries

ALTER SESSION SET USE_CACHED_RESULT=FALSE;--This is to ensure that we do not retrieve from query cache

SELECT * FROM NON_SECURE_INVENTORY WHERE BIBNUMBER =511784;

SELECT * FROM SECURE_INVENTORY WHERE BIBNUMBER =511784;

The query profile for the first query looks as below

2020-09-06-20-26-48-21b07202e527a5b67bbba720952a3ecf

However, the query profile for the second one looks like as below

Both the views use the same columns from the same underlying view. So, why is this difference in query profiles.

A : Secure views do not expose the underlying tables or internal structural details for a view

B : The query profile is corrupted

C : The query is run by a role that did not have access to the view

Answer: A

Question 4

Assuming all Snowflake accounts are using an Enterprise edition or higher, in which development and testing scenarios would be copying of data be required, and zero-copy cloning not be suitable? (Select TWO).

A : Developers create their own datasets to work against transformed versions of the live data.

B : Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.

C : Data is in a production Snowflake account that needs to be provided to Developers in a separate development/testing Snowflake account in the same cloud region.

D : Developers create their own copies of a standard test database previously created for them in the development account, for their initial development and unit testing.

E : The release process requires pre-production testing of changes with data of production scale and complexity. For security reasons, pre-production also runs in the production account.

Answer: A,C

Question 5

One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage). What may be the cause of this?

A : The amount of memory available for the servers used to execute the operation might not be sufficient to hold intermediate results

B : The size of the AWS bucket used to hold the data is not sufficient for the query

C : Number of disks attached to the virtual warehouse is not enough for the processing

Answer: A

Page: 1 / 89

Total 442 Questions | Updated On: Apr 10, 2025

Add To Cart