Enjoy 15% Discount With Coupon 15off

Monthly Archives - December 2022

What is the ‘broken windows’ theory?

What is the ‘broken windows’ theory?A . The theory proposed by Kelling and Wilson that leaving broken windows or other markers of decay, such as graffiti and trash, unattended or unrepaired can lead to the impression of abandonment and increase crime opportunity because no capable guardian (i.e. security presence) is...

Read more...

What is a Trademark

What is a TrademarkA . Legal protection for words, names, symbols, devices, or images applied to products or used in connection with goods or services to identify their source. B. Legal protection for a property right granted to an inventor to exclude others from making, using, offering for sale, or...

Read more...

system$stream_has_data(‘rawstream1’) condition returns false, what will happen to the task ?

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); --...

Read more...

If you run the below commands in your worksheet, what will happen?

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...

Read more...

Which semi-structured data function returns an OBJECT constructed from the arguments.

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) | |----------------------------------------------| | { | |...

Read more...

What are those additional columns?

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...

Read more...

According to Davidov and Malone, what is the centrepiece of the new global economy?

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

Read more...

Which command can be run to list all shares that have been created in your account or are available to consume by your account

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...

Read more...