
Ultimate access to all questions.
A junior data engineer has created a global temporary view named orders_vw for a specific task. However, when attempting to query this view with SELECT * FROM orders_vw, an error occurs. As a senior data engineer, what would you advise your colleague to correct in order to successfully execute this query?*
A
SELECT * FROM gbl_tmp.orders_vw*
B
SELECT * FROM global_temp.orders_vw*
C
SELECT * FROM gbl_temp.orders_vw*
D
SELECT * FROM global_temporary.orders_vw*
E
SELECT * FROM gbl_temporary.orders_vw*