ARA-C01

You have created a table as below CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR); What datatype Snowflake will use for EMPLOYEE_ID?A . FIXED B. INTEGER C. NUMBERView AnswerAnswer: A Explanation: Please try this for yourself. Note that this advanced certification requires working experience, so some of these hands-on will help in...

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

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

You have created a table as below CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR); What datatype Snowflake will use for EMPLOYEE_ID?A . FIXED B. INTEGER C. NUMBERView AnswerAnswer: A Explanation: Please try this for yourself. Note that this advanced certification requires working experience, so some of these hands-on will help in...

You have set time-travel retention to 10 days. You now increase the retention period by 10 more days to make it 20 days. What will be the impact on the table data?A . Any data that is 10 days older and moved to fail-safe will not have any impact B....

You have turned on auto clustering in your table. How will you monitor how much credit is getting burnt for the auto clustering in the past week for a specific table?A . Run the below query select * from table(information_schema.automatic_clustering_history(date_range_start=>dateadd(d, -7, current_date), date_range_end=>current_date, table_name=>'mydb.myschema.mytable')); B. SHOW AUTO CLUSTERING INFO C....

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

With default settings, how long will a query run on snowflakeA . Snowflake will cancel the query if it runs more than 48 hours B. Snowflake will cancel the query if it runs more than 24 hours C. Snowflake will cancel the query if the warehouse runs out of memory...

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

During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?A . Snowpipe loads duplicate data into the source table B. Data loading will fail when the snowpipe...