Free Access Snowflake.SnowPro-Core.v2022-06-27.q91 Practice Test (Page 9)

Question 36

Which of the following is true of Snowpipe via REST API?
Choose 2 answers

A.Snowpipe keeps track of which files it has loaded

B.Snowflake automatically manages the compute required to execute the Pipe's copy into commands

C.All COPY INTO options are available fluting pipe creation

D.you can only use it on internal Stages

Question 37

How would you determine the size of the virtual warehouse used for a task?

A.If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

B.Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

C.Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

D.Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

Question 38

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

A.False

B.True

Question 39

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

A.True

B.False

Question 40

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.