Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

• A.Custom
• B.Economy
• C.Optimized
• D.Standard

Comment: *

Name: *

Email: *

Verification: *

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

• A.STRIP_NULL_VALUES
• B.SKIP_BYTE_ORDER_MARK
• C.REPLACE_INVALID_CHARACTERS
• D.VALIDATION_MODE

Comment: *

Name: *

Email: *

Verification: *

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

• A.Smaller micro-partitions are created for common data values to allow for more parallelism
• B.Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
• C.Data is hashed by the cluster key to facilitate fast searches for common data values
• D.Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Comment: *

Name: *

Email: *

Verification: *

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.

• A.INITTIALLY_SUSPENDED = TRUE/FALSE
• B.START_AFTCR_CREATE = TRUE/FALSE
• C.START.TIME = CURRENT.DATE()
• D.START_TTIME = 60 // (seconds from now)

Comment: *

Name: *

Email: *

Verification: *

Which of the following roles is recommended to be used to create and manage users and roles?

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

Comment: *

Name: *

Email: *

Verification: *