ARA-C01 exam

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

Cloud services can help in pruning even if the columns are variant columns.A . TRUE B. FALSEView AnswerAnswer: A Explanation: Snowflake stores internally variant (json) data, in a independent column like structure for the 100+ most common elements, and the remainder in a leftovers like column. Those virtual columns have...

You have created a table as below CREATE TABLE SNOWFLAKE_BLOG(BLOG_ID NUMBER, BLOG_CONTENT VARCHAR,BLOG_AUTHOR VARCHAR,BLOG_CREATE_DATE TIMESTAMP ); Now you want to cluster it by BLOG_AUTHOR and BLOG_CREATE_DATE. Which command below will you choose?A . ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR) B. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR, BLOG_CREATE_DATE); C. ALTER TABLE...

JSON and PARQUET files can be loaded to columns in the same tableA . TRUE B. FALSEView AnswerAnswer: B Explanation: Let us try to answer some logical questions to arrive at the answer for this question

While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?A . Unlimited B. 3 to 4 C. Not more than 16 D. 32View AnswerAnswer: B Explanation: A single clustering key can contain one or more columns or...