ARA-C01 V1

In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadminA . TRUE B. FALSEView AnswerAnswer: A Explanation: Role hierarchy is an important concept that you should read thoroughly. More than one question may appear in the exam on this topic. Please remember in snowflake you cannot...

You got a response code of 429 from the insertFiles API. What does that mean?A . Failure. Invalid request due to an invalid format, or limit exceeded B. Failure. pipeName not recognized C. Failure. Request rate limit exceeded D. Failure. Internal error occurredView AnswerAnswer: C Explanation: response body Response Codes:...

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;

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