Free Snowflake SnowPro-Advanced-Architect Exam Questions

The table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below:

Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses. Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries.

The Architect must design a clustering key for this table to improve the query performance.

Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?

Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.) 

By executing the 'SHOW TABLES' command, we can list all the tables in all the schemas even if we do not have access to all the tables

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided? 

Remote service in external function can be an AWS Lambda function