A.Materialized views

B.User-Defined Functions (UDFs)

C.External tables

D.Secure views

A.A compressed file size greater than 100 MB, and up to 250 MB

B.A compressed file size greater than 100 GB, and up to 250 GB

C.A compressed file size greater than 10 MB, and up to 100 MB

D.A compressed file size greater than 1 GB, and up to 2 GB

A.Within a control table

B.Within the policy DDL

C.By future APPLY for all objects in a schema

D.Within the create table or create view DDL

E.Using the command ALTER <object> ADD ROW ACCESS POLICY <policy>;

A.The query consumes many compute resources every time it runs.

B.The results of the query do not change often and are used frequently.

C.The base table gets updated frequently.

D.There is minimal cost associated with running the query.

E.The query is highly optimized and does not consume many compute resources.

A.Time Travel - 1 day. Fail-safe - 1 day

B.Time Travel - 0 days. Fail-safe - 1 day

C.Time Travel - 1 day. Fail-safe - 0 days

D.Transient tables are retained in neither Fail-safe nor Time Travel