
Ultimate access to all questions.
What will be the outcome of executing the following set of statements in a Databricks notebook, assuming 'viewer' is a pre-defined delta table with columns 'name' and 'age'?
CREATE VIEW viewing AS SELECT age FROM viewer; CREATE TEMP VIEW viewing AS SELECT name FROM viewer; CREATE VIEW viewing AS SELECT age FROM viewer; SELECT * FROM viewing;*
A
All commands execute successfully, displaying the 'age' column as output.
B
The third command fails, and the 'name' column is displayed as output.
C
All commands execute successfully, displaying the 'name' column as output.
D
The second and third commands fail, and the 'age' column is displayed as output.
E
All commands execute successfully, but no output is displayed.