- All Exams Instant Download
While choosing a cluster key, what is recommended by snowflake?
While choosing a cluster key, what is recommended by snowflake?A . Cluster columns that are most actively used in selective filtersB . If there is room for additional cluster keys, then consider columns frequently used in join predicatesC . Choose a key with high cardinalityView AnswerAnswer: A,B Explanation: Snowflake recommends...
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?
A 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...
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?A . The Connector only works in Snowflake regions that use AWS infrastructure.B . The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.C . The Connector creates and manages its...
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?A . External tableB . Materialized viewC . Search optimizationD . Result cacheView AnswerAnswer: B
How do you refresh a materialized view?
How do you refresh a materialized view?A . ALTER VIEW <MV_NAME> REFRESHB . REFRESH MATERIALIZED VIEW <MV_NAME>C . Materialized views are automatically refreshed by snowflake and does not require manual interventionView AnswerAnswer: C Explanation: Materialized views are automatically and transparently maintained by Snowflake. A background service updates the materialized view...
Which best practice recommendations will meet data protection and compliance requirements?
A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI). The company must ensure compliance with all relevant privacy standards. Which best practice recommendations will meet data protection and compliance requirements? (Choose three.)A . Use, at minimum, the Business Critical edition of Snowflake.B . Create...
What is a valid object hierarchy when building a Snowflake environment?
What is a valid object hierarchy when building a Snowflake environment?A . Account --> Database --> Schema --> WarehouseB . Organization --> Account --> Database --> Schema --> StageC . Account --> Schema > Table --> StageD . Organization --> Account --> Stage --> Table --> ViewView AnswerAnswer: B
What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link?
A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity, an Architect performed the following steps: * Confirmed Private Link URLs are working by logging in with a username/password account * Verified...
When would you usually consider to add clustering key to a table
When would you usually consider to add clustering key to a table A. The performance of the query has deteriorated over a period of time. B. The number of users querying the table has increased C. it is a multi-terabyte size table D. The table has more than 20 columnsView...
