How should clustering be used to optimize the performance of queries that run on a very large table?
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?
Given the statement template below, which database objects can be added to a share?(Select TWO).
GRANT
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?
Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?
Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?
What causes objects in a data share to become unavailable to a consumer account?
How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
Which privilege is needed for a SnowFlake user to see the definition of a secure view?
What type of account can be used to share data with a consumer who does have a Snowflake account?
In the Data Exchange, who can get or request data from the listings? (Select TWO).
Which Snowflake table supports unstructured data?
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?
Snowflake users can create a resource monitor at which levels? (Select TWO).
