Question list
List of questions
Related questions
Question 29 - DEA-C01 discussion
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
A.
create or replace materialized view DataReportMV as
B.
select Item_id, Item_price from Items; Step 2: He joined a materialized view with a sales table as
C.
create or replace view Revenue as
D.
select m.item_id, sum(ifnull(s.quantity, 0)) as quantity,
E.
sum(ifnull(quantity * (s.price - m.item_price), 0)) as profit
F.
from DataReportMV as m left outer join sales as s on s.item_id = m.item_id
G.
group by m.item_id;Step 3: After 1 hour, he decided to temporarily suspend the use (and maintenance) of the DataReportMV materialized view for cost saving purpose.alter materialized view DataReportMV suspend; Please select what Alex is doing wrong here?
H.
A materialized view, DataReportMV does not support Join operations, so Step 2 would be failed & he cannot proceed further.
I.
Materialized view on top of External tables is not supported feature.
J.
Once DataReportMV got suspended , any query on the top of the view will generate er-ror like:Failure during expansion of view 'DATAREPORTMV': SQL compilation error: Material-ized view DataReportMV is invalid.
K.
There is no command like suspend for temporarily suspension of Materialized views, Step 3 will give error like invalid Suspend command.
L.
Alex is doing everything correct.
Previous
Next
Your answer:
0 comments
Sorted by
Leave a comment first
