A. Use the SHOW STAGES command.
B. Use the DESCRIBE STAGE command.
C. Use the GET_STAGE_LOCATION function.
D. Use the GET_ABSOLUTE_PATH function.
A. The length of time is specified in the expiration_time argument.
B. The encoded URL access is permanent.
C. When the data cache clears.
D. When the persisted query result period ends.
A. Add the search optimization service to the table.
B. Add a clustering key to the table.
C. Create a materialized view based on the query.
D. Enable the query acceleration service for the virtual warehouse.
A. Increasing the amount of remote storage for the virtual warehouse
B. Using a common table expression (CTE) instead of a temporary table
C. Using a larger virtual warehouse
D. Increasing the virtual warehouse maximum timeout limit
A. Standard Edition
B. Business Critical Edition
C. Virtual Private Snowflake Edition
D. Enterprise Edition
A. Share
B. Sequence
C. Private listing
D. Secure view
A. Use the INSERT command.
B. Use the COPY command.
C. Use Snowpipe.
D. Use an external table.
A. True
B. False
A. Filter using a where clause
B. Cast using a SELECT statement
C. Filter using a limit keyword
D. Order using an ORDER BY clause
A. Materialized views do not allow joins.
B. Multiple tables can be joined in the underlying query of a materialized view.
C. Aggregate functions can be used as window functions in materialized views.
D. Clones of materialized views can be created directly by the user.
A. Snowflake can run within a user's own Virtual Private Cloud (VPC).
B. Snowflake requires a user to configure an IAM user to connect to the database.
C. Snowflake leverages a Role-Based Access Control (RBAC) model.
D. All data in Snowflake is encrypted.
E. All data in Snowflake is compressed.
A. Newline Delimited JSON
B. Binary file in Avro
C. Binary file in Parquet
D. Comma-separated JSON
E. Plain text file containing XML elements
