Question 61
The following CREATE DATABASE command creates a clone of a database snowmy_db i.e.
Create database pods_db clone snowmy_db
before (statement => '7e5d0cb9-005e-94e6-b058-k8f5b37c5725');
What are possible reason of failing cloning operation for this database?
Create database pods_db clone snowmy_db
before (statement => '7e5d0cb9-005e-94e6-b058-k8f5b37c5725');
What are possible reason of failing cloning operation for this database?
Question 62
Alex, a Data Engineer with one of the Data analytics Organization, created the Materialized view over External tables to improve Data Reporting Experience.
Step 1: He created materialized view named DataReportMV
1.create or replace materialized view DataReportMV as
2.select Item_id, Item_price from Items;
Step 2: He joined a materialized view with a sales table as
1.create or replace view Revenue as
2.select m.item_id, sum(ifnull(s.quantity, 0)) as quantity,
3.sum(ifnull(quantity * (s.price - m.item_price), 0)) as profit
4.from DataReportMV as m left outer join sales as s on s.item_id = m.item_id
5.group by m.item_id;
Step 3: After 1 hour, he decided to temporarily suspend the use (and maintenance) of the DataRe-portMV materialized view for cost saving purpose.
alter materialized view DataReportMV suspend;
Please select what Alex is doing wrong here?
Step 1: He created materialized view named DataReportMV
1.create or replace materialized view DataReportMV as
2.select Item_id, Item_price from Items;
Step 2: He joined a materialized view with a sales table as
1.create or replace view Revenue as
2.select m.item_id, sum(ifnull(s.quantity, 0)) as quantity,
3.sum(ifnull(quantity * (s.price - m.item_price), 0)) as profit
4.from DataReportMV as m left outer join sales as s on s.item_id = m.item_id
5.group by m.item_id;
Step 3: After 1 hour, he decided to temporarily suspend the use (and maintenance) of the DataRe-portMV materialized view for cost saving purpose.
alter materialized view DataReportMV suspend;
Please select what Alex is doing wrong here?
Question 63
What kind of Snowflake integration is required when defining an external function in Snowflake?
Question 64
A Data Engineer wants to centralize grant management to maximize security. A user needs ownership on a table m a new schema However, this user should not have the ability to make grant decisions What is the correct way to do this?
Question 65
Snowflake does not provide which of following set of SQL functions to support retrieving infor-mation about tasks?
