What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?

• A.IO
• B.Network
• C.Pruning
• D.Spilling

Comment: *

Name: *

Email: *

Verification: *

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.
How can this be accomplished?

• A.select src:dealership from car_sales;
• B.select src:Dealership from car_sales;
• C.select src.dealership from car_sales;
• D.select dealership from car_sales;

Comment: *

Name: *

Email: *

Verification: *

Which of the following are characteristics of security in Snowflake?

• A.Account and user authentication is only available with the Snowflake Business Critical edition.
• B.Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
• C.Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
• D.Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Comment: *

Name: *

Email: *

Verification: *

A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?

• A.The temporary table will take precedence over the permanent table.
• B.The permanent table will take precedence over the temporary table.
• C.An error will say there cannot be two tables with the same name in a schema.
• D.The table that was created most recently will take precedence over the older table.

Comment: *

Name: *

Email: *

Verification: *

Which statements are true of micro-partitions? Choose 2 answers

• A.They are only encrypted in the Enterprise edition and above
• B.They are approximately 16MB in size
• C.They are stored compressed only if COMPRESS=TRUE on Table
• D.They are Immutable

Comment: *

Name: *

Email: *

Verification: *