Which view should be checked to ensure that data has loaded successfully before removing staged files?

• A.STAGE_STORAGE_USAGE_HISTORY
• B.DATA TRANSFER HISTORY
• C.LOAD_HISTORY
• D.COPY_HISTORY

Comment: *

Name: *

Email: *

Verification: *

User-level network policies can be created by which of the following roles? (Select TWO).

• A.ROLEADMIN
• B.ACCOUNTADMIN
• C.SYSADMIN
• D.SECURITYADMIN
• E.USERADMIN

Comment: *

Name: *

Email: *

Verification: *

Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

• A.ACCOUNTADMIN
• B.SECURITYADMIN
• C.SYSADMIN
• D.ORGADMIN

Comment: *

Name: *

Email: *

Verification: *

What data-type constructs are used to create a hierarchy when organizing semi-structured data? (Select TWO).

• A.A VARIANT can hold a value of any other data type.
• B.An ARRAY or OBJECT holds a value of type VARCHAR.
• C.An ARRAY or OBJECT holds a value of type VARIANT.
• D.An ARRAY or OBJECT holds a value of type VECTOR.
• E.An ARRAY or OBJECT holds a value of type INTEGER.

Comment: *

Name: *

Email: *

Verification: *

A user creates a stage using the following command:
What will be the outcome?

• A.A stage with a directory table that has metadata that must be manually refreshed will be created.
• B.The command will fail to run because the name of the directory table is not specified.
• C.A stage with a directory table set to automatically refresh will be created.
• D.An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.

Comment: *

Name: *

Email: *

Verification: *