- All Exams Instant Download
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 below select query will fail for this table?
You have created a table as below CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); Which of the below select query will fail for this table?A . SELECT * from snowflake; B. SELECT * from Snowflake; C. SELECT * from "snowflake"; D. SELECT * FROM "SNOWFLAKE";View AnswerAnswer: C Explanation: Try it...
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...
Which metrics below will help you take a decision if you need to resize your warehouse?
Which metrics below will help you take a decision if you need to resize your warehouse?A . QUERY_HISTORY.BYTES_SCANNED B. QUERY_HISTORY.REMOTE_SPILLAGE_BYTES C. QUERY_HISTORY.SCANNED_ROWSView AnswerAnswer: A Explanation: Be very careful in answering these type of questions. Read it again. You may be tempted to pick up QUERY_HISTORY.REMOTE_SPILLAGE_BYTES, but there is no metrics...
How do you find your procedures and functions in snowflake?
You have written a procedure and a function in snowflake. How do you find your procedures and functions in snowflake?A . SHOW PROCEDURES; B. SHOW FUNCTIONS; C. SHOW ALL PROCEDURES AND FUNCTIONS D. SHOW PROCEDURES, FUNCTIONSView AnswerAnswer: B Explanation: This will list all objects that your current role has access...
The kafka connector creates one pipe for each partition in a Kafka topic.
The kafka connector creates one pipe for each partition in a Kafka topic.A . TRUE B. FALSEView AnswerAnswer: A Explanation: The connector creates one pipe for each partition in a Kafka topic. The format of the pipe name is: SNOWFLAKE_KAFKA_CONNECTOR_<connector_name>_<PIPE_table_name>_<partition_number> https://docs.snowflake.com/en/user-guide/kafka-connector-manage.html#dropping-pipes
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...
Refreshing a secondary database is not allowed in the following circumstances
Refreshing a secondary database is not allowed in the following circumstancesA . Materialized views B. Primary database contains transient tables C. Databases created from shares D. Primary database has external tableView AnswerAnswer: C,D Explanation: Creating or refreshing a secondary database is blocked if an external table exists in the primary...
Search optimization does not support Materialized views and External Tables
Search optimization does not support Materialized views and External TablesA . TRUE B. FALSEView AnswerAnswer: A Explanation: Current Limitations of the Search Optimization Service The search optimization service does not support the following:
Which of the two are limitations of the insertReport API of SnowPipe?
Which of the two are limitations of the insertReport API of SnowPipe?A . The 10,000 most recent events are retained B. Events are retained for a maximum of 10 minutes C. Events are retained for a maximum of 24 hoursView AnswerAnswer: A,B Explanation: Endpoint: insertReport Retrieves a report of files...
