ARA-C01 Exam Question 86
A stream stores data with the same columns as the source data but with additional columns.
What are those additional columns?
What are those additional columns?
ARA-C01 Exam Question 87
You have create a task as below
CREATE TASK mytask1
WAREHOUSE = mywh
SCHEDULE = '5 minute'
WHEN
SYSTEM$STREAM_HAS_DATA('MYSTREAM')
AS
INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT';
Which statement is true below?
CREATE TASK mytask1
WAREHOUSE = mywh
SCHEDULE = '5 minute'
WHEN
SYSTEM$STREAM_HAS_DATA('MYSTREAM')
AS
INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT';
Which statement is true below?
ARA-C01 Exam Question 88
An Architect needs to allow a user to create a database from an inbound share.
To meet this requirement, the user's role must have which privileges? (Choose two.)
To meet this requirement, the user's role must have which privileges? (Choose two.)
ARA-C01 Exam Question 89
You have written a procedure and a function in snowflake.
How do you find your procedures and functions in snowflake?
How do you find your procedures and functions in snowflake?
ARA-C01 Exam Question 90
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?
