When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

• A.The Pipe load history is reset to empty
• B.The REFRESH parameter is set to TRUE
• C.Previously loaded files will be ignored
• D.All of the above

Comment: *

Name: *

Email: *

Verification: *

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

• A.Only data about new customers from the new files will be appended to the table
• B.All data from all of the files on the stage will be appended to the table
• C.The operation will fail with the error uncertain files in stage.
• D.All data from only the newly-added files will be appended to the table.

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes the Snowflake Cloud Services layer?

• A.Executes queries submitted by the Snowflake account users
• B.Manages the virtual warehouse cache to speed up queries
• C.Manages quotas on the Snowflake account storage
• D.Coordinates activities in the Snowflake account

Comment: *

Name: *

Email: *

Verification: *

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

• A.Security
• B.Time Travel data
• C.Data loading
• D.Authentication and access control
• E.Query execution

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

• A.Storage expands without the requirement to add more compute
• B.Growth of storage and compute are tightly coupled together
• C.Multiple compute clusters can access stored data without contention
• D.Compute can be scaled up or down without the requirement to add more storage

Comment: *

Name: *

Email: *

Verification: *