Which of the below commands will use warehouse credits?

• A.SHOW TABLES LIKE 'SNOWFL%';
• B.SELECT COUNT(*) FROM SNOWFLAKE;
• C.SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;
• D.SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

Comment: *

Name: *

Email: *

Verification: *

Assigning ACCOUNTADMIN as the default role for the account administrators is a best practice

• A.TRUE
• B.FALSE

Comment: *

Name: *

Email: *

Verification: *

You have a large warehouse with auto suspend configured for 10 minutes. You submitted a query and it is going to run for more than 10 minutes.
What will happen to the query?

• A.The query will go on a hold state
• B.The query will continue to run
• C.The query will automatically cancelled after 10 minutes

Comment: *

Name: *

Email: *

Verification: *

Which semi-structured data function returns an OBJECT constructed from the arguments.

• A.OBJECT_CONSTRUCT
• B.OBJECT_INSPECT
• C.OBJECT_ARRAY

Comment: *

Name: *

Email: *

Verification: *

A stream stores data with the same columns as the source data but with additional columns.
What are those additional columns?

• A.METADATA$ROW_ID
• B.METADATA$ACTION
• C.METADATA$DELETE
• D.METADATA$ISUPDATE

Comment: *

Name: *

Email: *

Verification: *