A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

• A.The data from the permanent table.
• B.The data from the temporary table.
• C.An error stating that the view could not be compiled.
• D.An error stating that the referenced object could not be uniquely identified.

Comment: *

Name: *

Email: *

Verification: *

What does Snowflake recommend regarding database object ownership? (Select TWO).

• A.Create objects with ACCOUNTADMIN and do not reassign ownership.
• B.Create objects with SYSADMIN.
• C.Create objects with SECURITYADMIN to ease granting of privileges later.
• D.Create objects with a custom role and grant this role to SYSADMIN.
• E.Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Comment: *

Name: *

Email: *

Verification: *

When unloading data to an external stage, what is the MAXIMUM file size supported?

• A.16 GB
• B.10 GB
• C.1 GB
• D.5 GB

Comment: *

Name: *

Email: *

Verification: *

True or False: You can define multiple columns within a clustering key on a table.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which statement about billing applies to Snowflake credits?

• A.Credits are billed per-minute with a 60-minute minimum
• B.Credits are used to pay for cloud data storage usage
• C.Credits are consumed based on the number of credits billed for each hour that a warehouse runs
• D.Credits are consumed based on the warehouse size and the time the warehouse is running

Comment: *

Name: *

Email: *

Verification: *