Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

• A.The column name and element names are both case-sensitive.
• B.The column name and element names are both case-insensitive.
• C.The column name is case-sensitive but element names are case-insensitive.
• D.The column name is case-insensitive but element names are case-sensitive.

Comment: *

Name: *

Email: *

Verification: *

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

• A.Standard
• B.Premier
• C.Enterprise
• D.Business Critical Edition

Comment: *

Name: *

Email: *

Verification: *

When unloading data to an external stage, what is the MAXIMUM file size supported?

• A.1 GB
• B.5 GB
• C.10 GB
• D.16 GB

Comment: *

Name: *

Email: *

Verification: *

Using variables in Snowflake is denoted by using which SQL character?

• A.@
• B.&
• C.$
• D.#

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