What type of query benefits the MOST from search optimization?

• A.A query that uses only disjunction (i.e., OR) predicates
• B.A query that includes analytical expressions
• C.A query that filters on semi-structured data types
• D.A query that uses equality predicates or predicates that use IN

Comment: *

Name: *

Email: *

Verification: *

When should a multi-cluster warehouse be used in auto-scaling mode?

• A.When it is unknown how much compute power is needed
• B.If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• C.If the runtime of the executed query is very slow
• D.When a large number of concurrent queries are run on the same warehouse

Comment: *

Name: *

Email: *

Verification: *

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.CREATE TABLE <table_name> LIKE TABLE_A;
• B.CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
• C.CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
• D.CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;

Comment: *

Name: *

Email: *

Verification: *

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

• A.ORGADMIN
• B.SYSADMIN
• C.USERADMIN
• D.PUBLIC

Comment: *

Name: *

Email: *

Verification: *

Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

• A.QUERY_HISTORY
• B.LOAD_HOSTORY
• C.ACCESS_HISTORY
• D.COPY_HISTORY

Comment: *

Name: *

Email: *

Verification: *