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 uses equality predicates or predicates that use IN
• D.A query that filters on semi-structured data types

Comment: *

Name: *

Email: *

Verification: *

By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

• A.ACCOUNTADMIN
• B.SECURITYADMIN
• C.SYSADMIN
• D.ORGADMIN

Comment: *

Name: *

Email: *

Verification: *

Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select TWO).

• A.Partitions scanned
• B.Partitions total
• C.Bytes spilled
• D.Bytes scanned
• E.Bytes written

Comment: *

Name: *

Email: *

Verification: *

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

• A.Whether or not it is also a secure view
• B.How often the underlying base table is queried
• C.How often the base table changes
• D.Whether the materialized view has a cluster key defined
• E.How often the materialized view is queried

Comment: *

Name: *

Email: *

Verification: *

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

• A.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.
• B.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.
• 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.

Comment: *

Name: *

Email: *

Verification: *