You have created a table as below CREATE TABLE TEST_01 (NAME STRING(10)); What data type SNOWFLAKE will assign to column NAME?A . LONGCHAR B. STRING C. VARCHARView AnswerAnswer: C Explanation: Try it yourself Execute the below commands CREATE TABLE TEST_01 (NAME STRING(10)); DESCRIBE TABLE TEST_01;
What four questions does risk management attempt to answer?A . What can be done? What options are available? What are the associated trade-offs in terms of costs, benefits, and risks? What are the impacts of current management decisions on future options? B. What is the cost? What options are available?...
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...
