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 21, 2025

Add To Cart

Question 1

What is the meaning of “Processing” in the query profiler menu when running a query?

A : The time when the processing was waiting for the network data transfer.

B : The time spent on data processing by the CPU.

C : The time when the processing was blocked by local disk access.

Answer: B

Question 2

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

A : A task scheduled in a UTC-based schedule will have no issues with the time changes.

B : Task schedules can be designed to follow specified or local time zones to accommodate the time changes.

C : A task will move to a suspended state during the daylight savings time change.

D : A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

E : A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

Answer: B,D

Question 3

create or replace table result_scan_table_1 like result_scan_table;

Will the above query cost compute credits?

A : No, since it is a metadata operation only

B : Yes, it will need compute as the table structure is also getting created

C : It is hard to say without looking at query profile

Answer: A

Question 4

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 :

Answer: A

Question 5

What are characteristics of Dynamic Data Masking? (Select TWO).

A : A masking policy that Is currently set on a table can be dropped.

B : A single masking policy can be applied to columns in different tables.

C : A masking policy can be applied to the value column of an external table.

D : The role that creates the masking policy will always see unmasked data In query results

E : A masking policy can be applied to a column with the GEOGRAPHY data type.

Answer: A,B

Page: 1 / 89

Total 442 Questions | Updated On: Apr 21, 2025

Add To Cart