What are the three classifications of loss in Insurance policies?A . Direct Loss Loss of use Extra C expense loss (e.g., cost of defending a liability suit or paying a judgement) B. Indirect Loss Loss of use Extra C expense loss (e.g., cost of defending a liability suit or paying...
You have a table named JSON_TBL which has a variant column JSON_VAR. The json stored in that table looks as below { "COURSE_DESC": "SNOWFLAKE CERTIFICATION", "COURSE_ID": 1000, "DURATION": 2 } if you run a query SELECT JSON_VAR:Course_id FROM JSON_TBL; what will it returnA . NULL B. 1000 C. 2View AnswerAnswer:...
Search optimization does not support Materialized views and External TablesA . TRUE B. FALSEView AnswerAnswer: A Explanation: Current Limitations of the Search Optimization Service The search optimization service does not support the following:
Search optimization does not support Materialized views and External TablesA . TRUE B. FALSEView AnswerAnswer: A Explanation: Current Limitations of the Search Optimization Service The search optimization service does not support the following:
You need to choose a high cardinality column for the clustering keyA . TRUE B. FALSEView AnswerAnswer: B Explanation: A column with very low cardinality (e.g. a column that indicates only whether a person is male or female) might yield only minimal pruning. At the other extreme, a column with...
Materialized views are recommended for all of the scenarios exceptA . Query results contain a small number of rows and/or columns relative to the base table B. Query results contain results that require significant processing C. The query is on an external table D. The view’s base table changes frequentlyView...
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,...
What are the five most common identifiers used to verify education history in a background check?A . Name while attending school Dates of attendance Graduation date Degree obtained Date of birth B. Name of primary school Dates of attendance Graduation date Degree obtained Date of birth C. Name while attending...
What value does company prosecution of employee drug offenses have?A . Minimal value B. More than $1000 C. More than $1500 D. Value less than $2000View AnswerAnswer: A
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...
