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: *

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

How can performance be optimized for a query that returns a small amount of data from a very large base table?

• A.Use clustering keys
• B.Create materialized views
• C.Use the search optimization service
• D.Use the query acceleration service

Comment: *

Name: *

Email: *

Verification: *

In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).

• A.Implementation of column-level security will optimize query performance.
• B.Column-level security supports encryption of the entire database.
• C.Column-level security ensures that only the table owner can access the data.
• D.Column-level security limits access to specific columns within a table based on user privileges
• E.Column-level security allows the application of a masking policy to a column within a table or view.

Comment: *

Name: *

Email: *

Verification: *

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

• A.Execute a COPY command
• B.Updating data
• C.Snowpipe
• D.AUTOMATIC__CLUSTERING
• E.Scaling up a warehouse

Comment: *

Name: *

Email: *

Verification: *