The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

• A.Partitions scanned
• B.Partitions total
• C.Bytes scanned
• D.Bytes read from result
• E.Bytes written

Comment: *

Name: *

Email: *

Verification: *

Will data cached in a warehouse be lost when the warehouse is resized?

• A.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
• B.Yes. because the compute resource is replaced in its entirety with a new compute resource.
• C.No. because the size of the cache is independent from the warehouse size
• D.Yes. became the new compute resource will no longer have access to the cache encryption key

Comment: *

Name: *

Email: *

Verification: *

Which SQL command can be used to see the CREATE definition of a masking policy?

• A.SHOW MASKING POLICIES
• B.DESCRIBE MASKING POLICY
• C.GET_DDL
• D.LIST MASKING POLICIES

Comment: *

Name: *

Email: *

Verification: *

Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?

• A.Only while in the ACCOUNTADMIH role
• B.Only while in the securityadmin role
• C.Only the role with the ownership privilege on the network policy
• D.Only Snowflake Support can set the value for this object property

Comment: *

Name: *

Email: *

Verification: *

Which SQL statement will require a virtual warehouse to run?

• A.SELECT COUNT{*) FROM TBL_EMPLOYEE;
• B.ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);
• C.INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam*,20000,* Finance');
• D.CREATE OR REPLACE TABLE TBL_EMPLOYEE (

Comment: *

Name: *

Email: *

Verification: *