Which stage type can be altered and dropped?

• A.Database stage
• B.External stage
• C.Table stage
• D.User stage

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

• A.It removes null values from all columns in the data.
• B.It converts null values to empty strings during loading.
• C.It skips rows with null values during the loading process.
• D.It removes object or array elements containing null values.

Comment: *

Name: *

Email: *

Verification: *

What is the recommended way to change the existing file format type in my format from CSV to JSON?

• A.CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
• B.REPLACE FILE FORMAT my format TYPE-JSON;
• C.ALTER FILE FORMAT my_format SET TYPE=JSON;
• D.ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

Comment: *

Name: *

Email: *

Verification: *

How are network policies defined in Snowflake?

• A.They are a set of rules that define the network routes within Snowflake.
• B.They are a set of rules that dictate how Snowflake accounts can be used between multiple users.
• C.They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.
• D.They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect to Snowflake.

Comment: *

Name: *

Email: *

Verification: *

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *