ARA-C01 exam

Please select the correct hierarchy from below A . B. C. D.View AnswerAnswer: C Explanation: Always remember this, account is the top most container. user, role, database, warehouse objects are contained within account. Schema is within a database. All other objects table, function, views, stored procedure, file format, stage, sequence...

While choosing a cluster key, what is recommended by snowflake?A . Cluster columns that are most actively used in selective filters B. If there is room for additional cluster keys, then consider columns frequently used in join predicates C. Choose a key with high cardinalityView AnswerAnswer: A,B Explanation: Snowflake recommends...

Which command below will load data from result_scan to a table?A . CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from table(result_scan(last_query_id())); B. CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from result_scan(last_query_id()); C. INSERT INTO STORE_FROM_RESULT_SCAN select * from result_scan(last_query_id());View AnswerAnswer: A Explanation: RESULT_SCAN is a system defined table...

Running EXPLAIN on a query does not require a running warehouseA . TRUE B. FALSEView AnswerAnswer: A Explanation: EXPLAIN compiles the SQL statement, but does not execute it, so EXPLAIN does not require a running warehouse. Although EXPLAIN does not consume any compute credits, the compilation of the query does...

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

One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?A . 14 hours B. 2 days C. 2 hours D. 24 hoursView AnswerAnswer: B Explanation: This is actually a dangerous thing to happen in production, hence...

Select the true statements about TASKSA . TASKS cannot be triggered manually B. TASKS can be scheduled for SQL execution C. TASKS can be used for change data capture D. TASKS can be used with STREAMSView AnswerAnswer: A,B,D

You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data. What is the best option?A . CREATE TABLE customer_table_other CLONE customer_table B. CREATE TABLE customer_table_other AS SELECT * FROM customer_table C. ALTER TABLE customer_table_other...

Validation mode can take the below optionsA . RETURN_<n>_ROWS B. RETURN_ERRORS C. RETURN_ALL_ERRORS D. RETURN_SEVERE_EERORS_ONLYView AnswerAnswer: A,B,C Explanation: VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests...

This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database. Which is that role?A . IMPORTED PRIVILEGES B. SHARED PRIVILEGES C. IMPORT SHAREView AnswerAnswer: A Explanation: IMPORTED PRIVILEGES Grants ability to enable roles other than the owning...