ARA-C01

Schema owner can grant object privileges in a regular schemaA . TRUE B. FALSEView AnswerAnswer: B Explanation: Another important topic to remember. Please also go through the difference between a managed schema and a regular schema https://docs.snowflake.com/en/user-guide/security-access-control-configure.html#creating-managed-acc ess-schemas

To convert JSON null value to SQL null value, you will useA . STRIP_NULL_VALUE B. IS_NULL_VALUE C. NULL_IFView AnswerAnswer: A Explanation: STRIP_NULL_VALUE Converts a JSON “null” value to a SQL NULL value. All other variant values are passed unchanged. Please remember this is semi structured data function and is different...

Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated

How do you validate the data that is unloaded using COPY INTO commandA . After unloading, load the data into a relational table and validate the rows B. Load the data into a CSV file to validate the rows C. Use validation_mode='RETURN_ROWS'; with COPY commandView AnswerAnswer: C Explanation: Validating Data...

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

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

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

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;