A. Distinct values
B. Range of values
C. Sorted values
D. Null values
E. Index values
A. Micro-partitions
B. Persisted query results
C. Query history
D. Standard and secure view results
E. Snowflake parameters
A. Increases the latency staging and accuracy when loading the data
B. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
C. Allows optimization of parallel operations
D. Allows a user to import the files in a sequential order
A. Information_schema.warehouse_load_history
B. Resource monitor
C. Information schema.warehouse metering history
D. Account_usage. query_history
A. Send an alert notification to all account users who have notifications enabled.
B. Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
C. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
D. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.
A. It provides detailed statistics about which queries are using the greatest number of compute resources.
B. It provides a graphic representation of the main components of the query processing.
C. It can provide statistics on a maximum number of 100 queries per week.
D. It can be used by third-party software using the Query Profile API.
A. The data is cloned into a historical object.
B. The object containing the historical data is dropped.
C. Time Travel on the historical data is dropped.
D. The data moves to Fail-safe
A. 7 days
B. 64 days
C. 1 day
D. 14 days
A. SHOW GRANTS ON ROLE MY_ROLE
B. SHOW GRANTS OF ROLE MY_ROLE
C. SHOW GRANTS FOR ROLE MY_ROLE
D. SHOW GRANTS TO ROLE MY_ROLE
A. ACCOUNTADMIN
B. SYSADMIN
C. SECURITYADMIN
D. ORGADMIN
A. Updating data
B. Execute a COPY command
C. Scaling up a warehouse
D. AUTOMATIC__CLUSTERING
E. Snowpipe
A. Disaster recovery
B. Fail-safe
C. Database failover and fallback
D. Data security
E. Time Travel
A. Queries too large to fit in memory
B. Ambiguous column names
C. Inefficient pruning
D. Syntax error
E. Object does not exist or not authorized
A. The objects enter the Time Travel period.
B. The objects enter the Fail-safe period.
C. The objects are immediately moved to the provider account.
D. The objects are dropped.
A. BLOB
B. Array
C. Object
D. GeoJSON
E. XML