Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

• A.SHOW STORAGE BY TABLE;
• B.Information Schema -> TASLE_HISTORY
• C.Information Schema -> TABLE_STORAGE_METRICS
• D.SHOW TABLES;

Comment: *

Name: *

Email: *

Verification: *

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

• A.STRIP_NULL_VALUES
• B.SKIP_BYTE_ORDER_MARK
• C.REPLACE_INVALID_CHARACTERS
• D.VALIDATION_MODE

Comment: *

Name: *

Email: *

Verification: *

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

• A.list @bronzestage;
• B.select * from directory(@bronzestage);
• C.select metadata$filename from @bronzestage;
• D.select * from table(information_schema.stage_directory_file_registration_history(

Comment: *

Name: *

Email: *

Verification: *

Which Query Profile operator is considered a DML operator?

• A.ExternalScan
• B.Flatten
• C.Merge
• D.Sort

Comment: *

Name: *

Email: *

Verification: *

What can the Snowflake SCIM API be used to manage? (Select TWO).

• A.Integrations
• B.Network policies
• C.Session policies
• D.Roles
• E.Users

Comment: *

Name: *

Email: *

Verification: *