When would you usually consider to add clustering key to a table

When would you usually consider to add clustering key to a tableA . 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...

May 24, 2023 No Comments READ MORE +

You need to choose a high cardinality column for the clustering key

You need to choose a high cardinality column for the clustering keyA . TRUE B. FALSEView AnswerAnswer: B Explanation: A column with very low cardinality (e.g. a column that indicates only whether a person is male or female) might yield only minimal pruning. At the other extreme, a column with...

May 24, 2023 No Comments READ MORE +

Which of the below objects cannot be replicated from one region to the other?

Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated

May 24, 2023 No Comments READ MORE +

Which alter command below may affect the availability of column with respect to time travel?

Which alter command below may affect the availability of column with respect to time travel?A . ALTER TABLE...DROP COLUMN B. ALTER TABLE...SET DATA TYPE C. ALTER TABLE...SET DEFAULTView AnswerAnswer: B Explanation: If the precision of a column is decreased below the maximum precision of any column data retained in Time...

May 24, 2023 No Comments READ MORE +

What datatype Snowflake will use for EMPLOYEE_ID?

You have created a table as below CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR); What datatype Snowflake will use for EMPLOYEE_ID?A . FIXED B. INTEGER C. NUMBERView AnswerAnswer: A Explanation: Please try this for yourself. Note that this advanced certification requires working experience, so some of these hands-on will help in...

May 24, 2023 No Comments READ MORE +

SNOWPIPE_AUTO_INGEST is supported for external stages only

SNOWPIPE_AUTO_INGEST is supported for external stages onlyA . TRUE B. FALSEView AnswerAnswer: A Explanation: Snowpipe auto-ingest only works with the external stage object. However, Snowpipe REST APIs work with both internal and external stages

May 24, 2023 No Comments READ MORE +

Loading data using snowpipe REST API is supported for external stage only

Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:

May 24, 2023 No Comments READ MORE +

Which are those?

Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENT B. RECORD_METADATA C. RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:

May 24, 2023 No Comments READ MORE +

Which of the following are characteristics of Snowflake’s parameter hierarchy?

Which of the following are characteristics of Snowflake’s parameter hierarchy?A . Session parameters override virtual warehouse parameters. B. Virtual warehouse parameters override user parameters. C. Table parameters override virtual warehouse parameters. D. Schema parameters override account parameters.View AnswerAnswer: A

May 23, 2023 No Comments READ MORE +

You have created a reader account for sharing data. who will pay for the compute usage of the account

You have created a reader account for sharing data. who will pay for the compute usage of the accountA . Provider B. ConsumerView AnswerAnswer: A Explanation: Reader account is a way to share data with stakeholders who do not have any snowflake account. They will use providers warehouse for compute.

May 23, 2023 No Comments READ MORE +