Question 1

Which command can we use to convert JSON NULL values to SQL NULL values?

Options :

A : STRIP_NULL_VALUE

B : STRIP_OUTER_ARRAY

C : TRANSCRIPT_NULL

D : JSON_TO_SQL

Answer: A

Question 2

What types of objects does Snowflake return when we execute the function GET_OBJECT_REFERENCES? (Choose two)

Options :

A : UDFs

B : Materialized views

C : Views (including secure views)

D : Tables

E : Streams

Answer: C,D

Question 3

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?

Options :

A : The healthcare company will need to change the institute’s Snowflake edition in the accounts panel.

B : By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.

C : Contact Snowflake and they will execute the share request for the healthcare company.

D : Set the share_restriction parameter on the shared object to false.

Answer: D

Question 4

A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes. Cost is not a concern as long as the solution is the best available. The plan so far consists of the following steps: 1. Deployment of Snowflake accounts on two different cloud providers. 2. Selection of cloud provider regions that are geographically far apart. 3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts. 4. Implementation of Snowflake client redirect. What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

Options :

A :

Connect the applications using the - URL. Use the Business Critical Snowflake edition.

B : Connect the applications using the - URL. Use the Virtual

Private Snowflake (VPS) edition.

C :

Connect the applications using the - URL. Use the Enterprise Snowflake edition.

D :

Connect the applications using the - URL. Use the Business Critical Snowflake edition.

Answer: D

Question 5

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner. Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

Options :

A : Utilize a higher Buffer.flush.time in the connector configuration.

B : Utilize a higher Buffer.size.bytes in the connector configuration.

C : Utilize a lower Buffer.size.bytes in the connector configuration.

D : Utilize a lower Buffer.count.records in the connector configuration.

Answer: A

Higher Test Marks with Free Online SnowPro-Advanced-Architect Exam Practice

Buying Options: