What does Snowflake recommend when planning virtual warehouse usage for a data load?

• A.Load the fewest possible number of large files.
• B.Use several single-duster warehouses.
• C.Dedicate a separate warehouse for loading data.
• D.Increase the size of the warehouse used.

Comment: *

Name: *

Email: *

Verification: *

What information in a secure User-Defined Function, or UDF, is only available to authorized users? Select TWO.

• A.The UDF definition code
• B.Return type
• C.Parameter types
• D.List of data imports
• E.Handler language

Comment: *

Name: *

Email: *

Verification: *

Which role has the ability to create a share from a shared database by default?

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

Comment: *

Name: *

Email: *

Verification: *

What will be the result of this command?
SELECT value FROM LATERAL FLATTEN(input = > parse_json( ' [1, 2, 3] ' ));

• A.It will return a single row with the array [1, 2, 3].
• B.It will return a single row with three columns with values 1, 2, and 3.
• C.It will return three rows with the values 1, 2, and 3.
• D.It will return a single row with the values 1, 2, and 3 concatenated.

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: *