- All Exams Instant Download
Following objects can be cloned in snowflake
Following objects can be cloned in snowflakeA . Permanent table B. Transient table C. Temporary table D. External tables E. Internal stagesView AnswerAnswer: A,B,C Explanation: For tables, Snowflake supports cloning permanent and transient tables; temporary tables can be cloned only to a temporary table or a transient table. For databases...
Which command can be run to list all shares that have been created in your account or are available to consume by your account
Which command can be run to list all shares that have been created in your account or are available to consume by your accountA . SHOW SHARES B. LIST SHARES C. DESCRIBE SHARESView AnswerAnswer: A Explanation: SHOW SHARES Lists all shares available in the system: Outbound shares (to consumers) that...
COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV
COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSVA . GZIP B. BZ2 C. BROTLI D. ZSTD E. DEFLATE F. RAW_DEFLATEView AnswerAnswer: A,B,D,E,F Explanation: AUTO Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use...
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:
