A company has several sites in different regions from which the company wants to ingest data.
Which of the following will enable this type of data ingestion?

• A.The company should use a storage integration for the external stage.
• B.The company should provision a reader account to each site and ingest the data through the reader accounts.
• C.The company must have a Snowflake account in each cloud region to be able to ingest data to that account.
• D.The company must replicate data between Snowflake accounts.

Comment: *

Name: *

Email: *

Verification: *

Which requirements indicate that a multi-account Snowflake strategy should be used? (Select TWO).

• A.A requirement to use different Snowflake editions.
• B.A requirement for easy object promotion using zero-copy cloning.
• C.A requirement to use Snowflake in a single cloud or region.
• D.A requirement to minimize complexity of changing database names across environments.
• E.A requirement to use RBAC to govern DevOps processes across environments.

Comment: *

Name: *

Email: *

Verification: *

Which SQL ALTER command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

• A.ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 1;
• B.ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 2;
• C.ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 8;
• D.ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 16;

Comment: *

Name: *

Email: *

Verification: *

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend - 60 and used exclusively for this task, which statement is true?

• A.The warehouse MY_WH will be made active every five minutes to check the stream.
• B.The warehouse MY_WH will only be active when there are results in the stream.
• C.The warehouse MY_WH will never suspend.
• D.The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Comment: *

Name: *

Email: *

Verification: *

What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Select TWO).

• A.The clone inherits all granted privileges of all child objects in the source object, excluding the database.
• B.Any pipes in the source referring to internal stages are not cloned.
• C.Any pipes in the source referring to external stages are not cloned.
• D.Any pipes in the source are not cloned.
• E.The clone inherits all granted privileges of all child objects in the source object, including the database.

Comment: *

Name: *

Email: *

Verification: *