A. A directory table will be automatically added to a stage.
B. Directory tables store data file metadata.
C. Directory table data can not be refreshed manually.
D. Directory tables do not have their own grantable privileges.
E. A directory table is a separate database object.
A. OBJECT
B. VARIANT
C. GEOGRAPHY
D. BINARY
E. GEOMETRY
A. Internal tokenization
B. Comments
C. Tags
D. Row access policies
A. It is automatically granted to the role that creates a database object within the schema.
B. It must be granted to a role in order to alter warehouse settings.
C. It allows a role to manage grants on the schema.
D. It grants the ability to query data from the schema.
E. It can be transferred from one role to another for a specific schema.
A. SHOW SCHEMAS
B. CREATE SHARE
C. DESCRBE TABLE
D. DROP ROLE
E. ALTER WAREHOUSE
A. ACCOUNTADMIN
B. SYSADMIN
C. SECURITYADMIN
D. ORGADMIN
A. Organize files into logical paths
B. Load the data in one large file
C. Store the files on the external stage to ensure caching is maintained
D. Use pattern matching for regular expression execution
A. If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.
B. If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.
C. If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.
D. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.
E. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.
