- All Exams Instant Download
Which of the below commands will use warehouse credits?
Which of the below commands will use warehouse credits?A . SHOW TABLES LIKE 'SNOWFL%'; B. SELECT MAX(FLAKE_ID) FROM SNOWFLAKE; C. SELECT COUNT(*) FROM SNOWFLAKE; D. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;View AnswerAnswer: D Explanation: Try this your self CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); INSERT INTO SNOWFLAKE VALUES(1111,...
Which statement is not true about shared database?
Which statement is not true about shared database?A . Shared databases are read only B. Shared databases cannot be cloned C. Time travel is not supported on a shared database D. Shared databases can be re-shared with other accountsView AnswerAnswer: D Explanation: General Limitations for Shared Databases Shared databases have...
Which option will you choose to setup the access?
Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only. Which option will you choose...
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?A . Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can execute B. Only if the system estimates there’s enough query load...
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....
