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?
  • 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?
  • 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?