NO.117 What integration object should be used to place restrictions on where data may be exported?

NO.118 What does Percentage scanned from cache in the query profile signify?

NO.119 A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period.
What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose two.)

NO.120 create or replace table result_scan_table as
select * from table(result_scan(last_query_id()));
Will the above query cost you any compute credits?

NO.121 When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

NO.122 Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?

NO.123 You will be using a multi cluster warehouse. You will statically control the available resources (i.e. servers) and you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly.
Which mode will you use for the warehouse?

NO.124 Which statement is not true about shared database?

NO.125 How do you validate the data that is unloaded using COPY INTO command

NO.126 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);
— Create a stream to capture inserts to the landing table.
— A task will consume a set of columns from this stream. create or replace stream rawstream1 on table raw;
— Create a second stream to capture inserts to the landing table.
— A second task will consume another set of columns from this stream. create or replace stream rawstream2 on table raw;
— Create a table that stores the names of office visitors identified in the raw data. create or replace table names (id int, first_name string, last_name string);
— Create a table that stores the visitation dates of office visitors identified in the raw data.
create or replace table visits (id int, dt date);
— Create a task that inserts new name records from the rawstream1 stream into the names table
— every minute when the stream contains records.
— Replace the ‘etl_wh’ warehouse with a warehouse that your role has USAGE privilege on. create or replace task raw_to_names
warehouse = etl_wh schedule = ‘1 minute’ when
system$stream_has_data(‘rawstream1’) as
merge into names n
using (select var:id id, var:fname fname, var:lname lname from rawstream1) r1 on n.id = to_number(r1.id)
when matched then update set n.first_name = r1.fname, n.last_name = r1.lname
when not matched then insert (id, first_name, last_name) values (r1.id, r1.fname, r1.lname)
;
— Create another task that merges visitation records from the rawstream1 stream into the visits table
— every minute when the stream contains records.
— Records with new IDs are inserted into the visits table;
— Records with IDs that exist in the visits table update the DT column in the table.
— Replace the ‘etl_wh’ warehouse with a warehouse that your role has USAGE privilege on. create or replace task raw_to_visits
warehouse = etl_wh schedule = ‘1 minute’ when
system$stream_has_data(‘rawstream2’) as
merge into visits v
using (select var:id id, var:visit_dt visit_dt from rawstream2) r2 on v.id = to_number(r2.id) when matched then update set v.dt = r2.visit_dt
when not matched then insert (id, dt) values (r2.id, r2.visit_dt)
;
— Resume both tasks.
alter task raw_to_names resume;
alter task raw_to_visits resume;
— Insert a set of records into the landing table. insert into raw
select parse_json(column1) from values
(‘{“id”: “123”,”fname”: “Jane”,”lname”: “Smith”,”visit_dt”: “2019-09-17”}’),
(‘{“id”: “456”,”fname”: “Peter”,”lname”: “Williams”,”visit_dt”: “2019-09-17”}’);
— Query the change data capture record in the table streams select * from rawstream1;
select * from rawstream2;

NO.127 This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database.
Which is that role?

NO.128 What conditions should be true for a table to consider search optimization

NO.129 Which of the below are securable objects?

NO.130 Remote service in external function can be an AWS Lambda function

NO.131 What are some of the characteristics of result set caches? (Choose three.)

NO.132 You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data.
What is the best option?

NO.133 The kafka connector creates one pipe for each partition in a Kafka topic.

NO.134 Which of the below privileges are required for search optimization?

NO.135 Please select the correct hierarchy from below

NO.136 The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements? (Choose two.)

NO.137 When does a multi-cluster warehouse shuts down with default scaling policy

NO.138 How do you refresh a materialized view?

NO.139 An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?

NO.140 Following objects can be cloned in snowflake