Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

• A.Running EXPLAIN and SHOW commands
• B.Running a custom query
• C.Cloning a database
• D.Running COPY commands
• E.Caching query results

Comment: *

Name: *

Email: *

Verification: *

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

• A.Partitions scanned is equal to partitions total
• B.The query is spilling to remote storage
• C.A single join node uses more than 50% of the query time
• D.An AggregateOperacor node is present

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.All data from all of the files on the stage will be appended to the table
• B.Only data about new customers from the new files 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: *

The Snowflake Cloud Data Platform is described as having which of the following architectures?

• A.Shared-nothing
• B.Multi-cluster shared data
• C.Serverless query engine
• D.Shared-disk

Comment: *

Name: *

Email: *

Verification: *

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

• A.UPDATE TABLE FROM STREAM
• B.ALTER TABLE AS SELECT FROM STREAM
• C.INSERT INTO TABLE SELECT FROM STREAM
• D.BEGIN COMMIT
• E.SELECT FROM STREAM

Comment: *

Name: *

Email: *

Verification: *