When a pipe is recreated using the CREATE on REPLAC PIPE command:
Select one.

• A.The Pipe load history is reset to empty
• B.All of the above
• C.The REFRESH parameter is set to TRUE
• D.Previously loaded files will be ignored

Comment: *

Name: *

Email: *

Verification: *

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers

• A.UPDATE
• B.COPY
• C.MIN(< < column value>>)
• D.SUM(<< column value >>)

Comment: *

Name: *

Email: *

Verification: *

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles?
Choose 3 answers

• A.They should use the SYSADMIN role to perform administrative work on database objects
• B.Their default role should be set to SYSTEMADMIN (the lower of the two)
• C.They should not set up multi_Factor Authentication (MFA)-as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
• D.They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
• E.They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

Comment: *

Name: *

Email: *

Verification: *

Which item in the Data Warehouse migration process does not apply in Snowflake?

• A.Build the Data Pipeline
• B.Migrate Indexes
• C.Migrate Users
• D.Migrate Schemas

Comment: *

Name: *

Email: *

Verification: *

The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers

• A.The complexity of each query
• B.The tool that s executing the query
• C.The size of the data required for each query
• D.The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

Comment: *

Name: *

Email: *

Verification: *