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 only the newly-added files will be appended to the table.
• C.The operation will fail with the error uncertain files in stage.
• D.All data from all of the files on the stage will be appended to the table

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements would be used to export/unload data from Snowflake?

• A.COPY INTO @slage
• B.INSERT INTO @stage
• C.EXPORT TO @stage
• D.EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Comment: *

Name: *

Email: *

Verification: *

What is the recommended Snowflake data type to store semi-structured data like JSON?

• A.VARCHAR
• B.RAW
• C.LOB
• D.VARIANT

Comment: *

Name: *

Email: *

Verification: *

A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify & Suspend Immediately".

What is the MAXIMUM limit of credits that Warehouse 2 can consume?

• A.0
• B.1500
• C.3500
• D.5000

Comment: *

Name: *

Email: *

Verification: *

True or False: Pipes can be suspended and resumed.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *