ARA-C01 exam

You have created a table as below CREATE TABLE TEST_01 (NAME STRING(10)); What data type SNOWFLAKE will assign to column NAME?A . LONGCHAR B. STRING C. VARCHARView AnswerAnswer: C Explanation: Try it yourself Execute the below commands CREATE TABLE TEST_01 (NAME STRING(10)); DESCRIBE TABLE TEST_01;

You have a table named JSON_TBL which has a variant column JSON_VAR. The json stored in that table looks as below { "COURSE_DESC": "SNOWFLAKE CERTIFICATION", "COURSE_ID": 1000, "DURATION": 2 } if you run a query SELECT JSON_VAR:Course_id FROM JSON_TBL; what will it returnA . NULL B. 1000 C. 2View AnswerAnswer:...

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:

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:

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

Materialized views are recommended for all of the scenarios exceptA . Query results contain a small number of rows and/or columns relative to the base table B. Query results contain results that require significant processing C. The query is on an external table D. The view’s base table changes frequentlyView...

Which of the below commands will use warehouse credits?A . SHOW TABLES LIKE 'SNOWFL%'; B. SELECT MAX(FLAKE_ID) FROM SNOWFLAKE; C. SELECT COUNT(*) FROM SNOWFLAKE; D. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;View AnswerAnswer: D Explanation: Try this your self CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); INSERT INTO SNOWFLAKE VALUES(1111,...

Which statement is not true about shared database?A . Shared databases are read only B. Shared databases cannot be cloned C. Time travel is not supported on a shared database D. Shared databases can be re-shared with other accountsView AnswerAnswer: D Explanation: General Limitations for Shared Databases Shared databases have...

Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only. Which option will you choose...

With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?A . Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can execute B. Only if the system estimates there’s enough query load...