Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
To monitor data storage for individual tables, the commands and objects that can be used are 'SHOW STORAGE BY TABLE;' and the Information Schema view 'TABLE_STORAGE_METRICS'.These tools provide detailed information about the storage utilization for tables. Reference: Snowflake Documentation
When retrieving data from a table which type of query will benefit the MOST from use of the search optimization service?
When a schema is cloned what happens to the tags that reside in that schema or database?
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select TWO).
When unloading data in Snowflake, it is essential to differentiate between empty strings and NULL values to preserve data integrity. The parameters FIELD_OPTIONALLY_ENCLOSED_BY and EMPTY_FIELD_AS_NULL are used together to address this:
FIELD_OPTIONALLY_ENCLOSED_BY: This parameter specifies the character used to enclose fields, which can differentiate between empty strings (as enclosed fields) and NULLs.
EMPTY_FIELD_AS_NULL: By setting this parameter, Snowflake interprets empty fields as NULL values when unloading data, ensuring accurate representation of NULLs versus empty strings.
These parameters are crucial when exporting data for systems that need explicit differentiation between NULL and empty string values.
What actions can be performed by a consumer account on a shared database? (Select TWO)
Olivia King
11 days agoOlivia Allen
14 days agoYusuf Qureshi
26 days agoManish Reddy
1 month agoXiao Lim
2 months agoRebecca Moore
2 months agoHamza Hashmi
2 months agoAiko Do
3 months agoKhalid Nawaz
3 months agoManish Patel
3 months agoEmma Walker
4 months ago