Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 32 of 60
Free Preview · 60 of 198 · questions 1–60 of 198 are free. Sign up free to sync your progress across devices.
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Valid as external tables + materiablized view combination makes it instantly accesible & performance efficient
A & C are correct The input is an external stage A -> is valid option to make a newly arrived files data accessible instantly B-> Copy command with a task scheudle has a lag so not a valid option c-> Valid as external tables + materiablized view combination makes it instantly accesible & performance efficient d-> Just copy into statment manually is not feeasible e-> Stream can't be applied on an external stage it needs an external table so not correct So A & C are correct options
A & B are possible options independent of each other. We dont need combination of tasks and streams, as there is no use case in this requirement for them.