Which privilege grants ability to set a Column-level Security masking policy on a table or view column.

• A.APPLY MASK
• B.APPLY MASKING POLICY
• C.ALTER COLUMN MASK

Comment: *

Name: *

Email: *

Verification: *

Cloud services can help in pruning even if the columns are variant columns.

• A.TRUE
• B.FALSE

Comment: *

Name: *

Email: *

Verification: *

Choose the different ways that you have to optimize query performance

• A.Clustering a table
• B.Vacuuming
• C.Search Optimization
• D.Creating one or more materialized views

Comment: *

Name: *

Email: *

Verification: *

You have a medium warehouse with auto suspend of 5 minutes. You ran a query on table#1. After 10 minutes, you ran a query that joins table#1 and table#2, but you see that the query did not use data
cache.
Why?

• A.The query that ran the second time is completely different from query that ran on table#1, hence it will not be able to use data cache
• B.When a warehouse is suspended, it may lose its data cache
• C.Joins cannot use any type of cache

Comment: *

Name: *

Email: *

Verification: *

Which copy options are not supported by CREATE PIPE...AS COPY FROM command?

• A.FILES = ( 'file_name1' [ , 'file_name2', ... ] )
• B.ON_ERROR = ABORT_STATEMENT
• C.MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONE
• D.FORCE = TRUE | FALSE
• E.VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS

Comment: *

Name: *

Email: *

Verification: *