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...
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...
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
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...
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...
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
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:
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:
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
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.