Question 1

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Options :

A : OPERATE

B : MONITOR

C : MODIFY

D : USAGE

Answer: A

Question 2

In this scenarios, files are constantly getting ingested in an external stage, the files are between 1 and 4 MB. You want to load the data immediately into a table without any human intervention. What will you use?

Options :

A : Create a materialize view on the external stage

B : Use Snowpipe rest APIs

C : Use Snowpipe with auto ingest

Answer: C

Question 3

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

Options :

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

Question 4

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 5

Data sharing is supported only between provider and consumer accounts in same region

Options :

A : TRUE

B : FALSE

Answer: B

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

Buying Options: