ARA-C01 exam

If you run the below commands in your worksheet, what will happen? CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE STUDENT_TABLE_CLONE CLONE STUDENT_TABLE;A . A temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE B. Only the STUDENT_TABLE_CLONE will be...

Which semi-structured data function returns an OBJECT constructed from the arguments.A . OBJECT_CONSTRUCT B. OBJECT_ARRAY C. OBJECT_INSPECTView AnswerAnswer: A Explanation: OBJECT_CONSTRUCT Returns an OBJECT constructed from the arguments. Let us do a hands-on exercise to understand this select object_construct('a',1,'b','BBBB', 'c',null); +----------------------------------------------+ | OBJECT_CONSTRUCT('A',1,'B','BBBB', 'C',NULL) | |----------------------------------------------| | { | |...

A stream stores data with the same columns as the source data but with additional columns. What are those additional columns?A . METADATA$ACTION B. METADATA$ISUPDATE C. METADATA$ROW_ID D. METADATA$DELETEView AnswerAnswer: A,B,C Explanation: https://docs.snowflake.com/en/user-guide/streams.html#stream-columns Stream Columns A stream stores data in the same shape as the source table (i.e. the same...

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

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