- All Exams Instant Download
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScan
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScanA . Reading the last 10 minutes of history every 8 minutes B. Read the last 24 hours of history every minute C. Read the last 7 days of history every hourView AnswerAnswer: A Explanation: This endpoint...
What datatype Snowflake will use for EMPLOYEE_ID?
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 optimization
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 performance
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...
What datatype Snowflake will use for EMPLOYEE_ID?
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 will be the impact on the table data?
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....
How will you monitor how much credit is getting burnt for the auto clustering in the past week for a specific table?
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....
What does that mean?
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 snowflake
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?
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
