Create a task and a stream following the below steps. So, when the system$stream_has_data('rawstream1') condition returns false, what will happen to the task ? -- Create a landing table to store raw JSON data. -- Snowpipe could load data into this table. create or replace table raw (var variant); --...
Who should be responsible for shutting down equipment in an emergency?A . Those already familiar with the process. B. Senior Engineer on Duty C. All Security Personnel D. Chief Security Officer on dutyView AnswerAnswer: A
If you run the below commands in your worksheet, what will happen? CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE STUDENT_TABLE_CLONE CLONE STUDENT_TABLE;A . A temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE B. Only the STUDENT_TABLE_CLONE will be...
Which semi-structured data function returns an OBJECT constructed from the arguments.A . OBJECT_CONSTRUCT B. OBJECT_ARRAY C. OBJECT_INSPECTView AnswerAnswer: A Explanation: OBJECT_CONSTRUCT Returns an OBJECT constructed from the arguments. Let us do a hands-on exercise to understand this select object_construct('a',1,'b','BBBB', 'c',null); +----------------------------------------------+ | OBJECT_CONSTRUCT('A',1,'B','BBBB', 'C',NULL) | |----------------------------------------------| | { | |...
A stream stores data with the same columns as the source data but with additional columns. What are those additional columns?A . METADATA$ACTION B. METADATA$ISUPDATE C. METADATA$ROW_ID D. METADATA$DELETEView AnswerAnswer: A,B,C Explanation: https://docs.snowflake.com/en/user-guide/streams.html#stream-columns Stream Columns A stream stores data in the same shape as the source table (i.e. the same...
According to Davidov and Malone, what is the centrepiece of the new global economy?A . The relationship between economics, security and policy B. Economics and Technology C. Vendor Ownership and Management Process recognition D. The virtual product, where major business functions are outsourced with hardly any internal departmentalization.View AnswerAnswer: D
Which command can be run to list all shares that have been created in your account or are available to consume by your accountA . SHOW SHARES B. LIST SHARES C. DESCRIBE SHARESView AnswerAnswer: A Explanation: SHOW SHARES Lists all shares available in the system: Outbound shares (to consumers) that...
What are the three types of attacks used to defeat an access-controlled entry point?A . Deceit Physical attack Technical attack B. Social Engineering Physical attack Technical attack C. Assault Physical attack Technical attack D. Bribery Physical attack Technical attackView AnswerAnswer: A
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?...
