A. Names and owners of the roles that are currently enabled in the session
B. History of the files that have been loaded into Snowflake
C. Query details such as the objects included and the user who executed the query
D. Details around the privileges that have been granted for all objects in an account
A. Query the secure view from a consumer account by setting the share_restrictions parameter.
B. Log in to the data consumer account and check if the secure view data is appearing as expected.
C. Simulate querying the secure view by setting the simulated_data_sharing_consumer session parameter.
D. Create a data share for a test data consumer account and check if the secure view data is appearing as expected.
A. Assign the custom role to the PUBLIC role
B. Add__CUSTOM to all custom role names
C. Assign the custom role to the SYSADMIN role
D. Create the custom role using the SYSADMIN role.
A. How often the underlying base table is queried
B. How often the base table changes
C. Whether the materialized view has a cluster key defined
D. Whether or not it is also a secure view
E. How often the materialized view is queried
A. ACCOUNTADMIN
B. SYSADMIN
C. SECURITYADMIN
D. ORGADMIN
A. TRUNC (ID_NUMBER, 5)
B. ID_NUMBER*100
C. TRUNC (ID_NUMBER, -6)
D. TO CHAR (ID NUMBER)
A. The query is spilling to remote storage
B. Partitions scanned is equal to partitions total
C. An AggregateOperacor node is present
D. A single join node uses more than 50% of the query time
A. src:customer.email
B. src[' customer' J ['EMAIL']
C. SRC:customer.email
D. SRC:Customer.Email
E. src['CUSTOMER'] ['Email*]
A. Last_QUERY_ID
B. UUID_STRING
C. CURRENT_STATEMENT
D. JOB_ID
A. The columns with very high cardinality.
B. The columns most actively used in the select filters.
C. The columns with many different values.
D. The columns that are queried in the select clause.
A. The columns in the result set of the query
B. All rows accessed during the query
C. Any columns accessed during the query
D. All columns in a micro-partition
A. Data can be loaded without the need to spin up a virtual warehouse
B. Columns can be reordered
C. Columns can be joined with an existing table
D. Columns can be aggregated
E. Columns can be omitted
C. PUBLIC
D. Any role that has the global ATTACH POLICY privilege
E. USERADMIN
A. 60 Days
B. 90 Days
C. 30 Days
D. 365 Days
A. 90 days
B. 31 days
C. There is no Fail-safe period for these tables.
D. 7 days
E. 1 day
A. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
B. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
D. Use the ENCODING file format option to change the encoding from the default UTF-8.
E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
