ARA-C01 exam

While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.A . TRUE B. FALSEView AnswerAnswer: A Explanation: non-equality JOINS are usually slower compared to equality joins. This is a very important thing to remember when you work on snowflake.

Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated

The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.A . The post can contain at most 5000 files. B. Each file path given must be <= 1024 bytes long when...

Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:

Choose the different ways that you have to optimize query performanceA . Clustering a table B. Creating one or more materialized views C. Search Optimization D. VacuumingView AnswerAnswer: A,B,C Explanation: Please note that search optimization is still in preview mode. But this will be a powerful feature to optimize your...

Which role in Snowflake allows a user to administer users and manage all database objects?A . ACCOUNTADMIN B. SYSADMIN C. ROOT D. SECURITYADMINView AnswerAnswer: A

What conditions should be true for a table to consider search optimizationA . The table size is at least 100 GB B. The table is not clustered OR The table is frequently queried on columns other than the primary cluster key C. The table can be of any sizeView AnswerAnswer:...

You have create a task as below CREATE TASK mytask1 WAREHOUSE = mywh SCHEDULE = '5 minute' WHEN SYSTEM$STREAM_HAS_DATA('MYSTREAM') AS INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT'; Which statement is true below?A . If SYSTEM$STREAM_HAS_DATA returns false, the task will be skipped B. If SYSTEM$STREAM_HAS_DATA...

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

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