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

• A.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
• B.They should use the SYSADMIN role to perform administrative work on database objects
• C.They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
• D.Their default role should be set to SYSTEMADMIN (the lower of the two)
• E.They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

Comment: *

Name: *

Email: *

Verification: *

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

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

Comment: *

Name: *

Email: *

Verification: *

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements is true of data loading?

• A.The "deal file size for loading is 16MB to match micro-partition size
• B.Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
• C.Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

Comment: *

Name: *

Email: *

Verification: *

True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *