Practice ARA-C01 Exam Online

Question 1

A Snowflake Architect is writing a User-Defined Function (UDF) with some unqualified object names.

How will those object names be resolved during execution?

A : Snowflake will resolve them according to the SEARCH_PATH parameter.

B : Snowflake will first check the current schema, and then the PUBLIC schema of the current database.

C : Snowflake will first check the current schema, and then the schema the previous query used.

D : Snowflake will only check the schema the UDF belongs to.

Answer: D

Question 2

How does Snowflake charge for the compute resources of the cloud services layer?

A : It’s a stable cost of 10$ per month

B : It’s included in the computing cost

C : The typical utilization of the cloud services layer (up to 10% of daily compute credits) is included for free. You pay the excess after this 10%.

D : The typical utilization of the cloud services layer (up to 10% of daily compute credits) is included for free. You pay the excess after this 20%.

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

What is the function of Resource Monitors regarding data pipelines?

A : Make data not being replicated twice in the same pipeline

B : It performs backups for your pipelines every 5 minutes

C : It helps you monitor and control the costs of your pipelines

Answer: C

Question 5

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

Name:	SnowPro Advanced Architect Certification
Exam Code:	ARA-C01
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	442
Last Updated:	Apr 24, 2024

Snowflake ARA-C01