ARA-C01

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

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

It is recommended to assign ACCOUNTADMIN role to atleast two userA . TRUE B. FALSEView AnswerAnswer: A Explanation: Control the Assignment of the ACCOUNTADMIN Role to Users We strongly recommend the following precautions when assigning the ACCOUNTADMIN role to users: Assign this role only to a select/limited number of people...